1. Tables and Views for HCM
  2. PAY_PER_OVR_REC_VL

PAY_PER_OVR_REC_VL

Details

  • Schema: FUSION

  • Object owner: PAY

  • Object type: VIEW

Columns

Name

RANGE_ITEM_ID

OBJECT_ACTION_ID

BASE_COMPONENT_NAME

COMPONENT_NAME

NAME

BASE_NAME

VALUE

UOM

PERIODICITY

Query

SQL_Statement

SELECT distinct

prif.range_item_id,

pra_l.payroll_rel_action_id object_action_id,

compDef.base_component_name,

compDef.component_name,

ao.PROMPT Name,

pvdd.BASE_NAME,

prif.value1 value,

nvl(pvdf.uom,pvdd.uom) uom,

nvl(pvdf.periodicity,pvdd.periodicity) periodicity

FROM

pay_payroll_rel_actions pra_l,

pay_payroll_actions ppa_l,

pay_dir_card_components_f comp,

pay_dir_card_comp_defs_vl compDef,

fusion.pay_old_value_defns_f pvdf,

fusion.pay_old_range_items_f prif,

fusion.pay_value_defs_f pvdd,

PAY_ALLOW_OVERRIDES_VL ao,

pay_dir_override_usages_f ou

where pra_l.payroll_action_id= ppa_l.payroll_action_id

and comp.creator_id= pra_l.payroll_rel_action_id

and ppa_l.effective_date between pvdd.effective_start_date and pvdd.effective_end_date

and ppa_l.effective_date between prif.effective_start_date and prif.effective_end_date

and ppa_l.effective_date between prif.effective_start_date and prif.effective_end_date

and ppa_l.effective_date between comp.effective_start_date and comp.effective_end_date

and ppa_l.effective_date between compDef.effective_start_date and compDef.effective_end_date

and compDef.dir_card_comp_def_id = comp.dir_card_comp_def_id

and compDef.navigation_use='Y'

and pvdf.source_id = comp.dir_card_comp_id

AND pvdf.parent_value_defn_id = pvdd.value_defn_id

AND ou.ALLOW_OVERRIDES_ID = ao.ALLOW_OVERRIDES_ID

AND ao.VALUE_DEFN_ID = pvdd.VALUE_DEFN_ID

AND prif.value_defn_id (+)= pvdf.value_defn_id

AND compDef.dir_card_comp_def_id = ou.dir_card_comp_def_id