DBA Data[Home] [Help]

APPS.PAY_RETRO_PKG dependencies on PAY_RETRO_DEFN_COMPONENTS

Line 1478: pay_retro_defn_components prdc2,

1474: pay_element_types_f pet1,
1475: pay_input_values_f piv1,
1476: pay_entry_process_details pepd,
1477: pay_retro_components prc,
1478: pay_retro_defn_components prdc2,
1479: pay_retro_defn_components prdc
1480: WHERE pet1.element_type_id = pepd.source_element_type_id
1481: and piv1.element_type_id = pet1.element_type_id
1482: and pepd.source_asg_action_id = p_asg_act_id

Line 1479: pay_retro_defn_components prdc

1475: pay_input_values_f piv1,
1476: pay_entry_process_details pepd,
1477: pay_retro_components prc,
1478: pay_retro_defn_components prdc2,
1479: pay_retro_defn_components prdc
1480: WHERE pet1.element_type_id = pepd.source_element_type_id
1481: and piv1.element_type_id = pet1.element_type_id
1482: and pepd.source_asg_action_id = p_asg_act_id
1483: AND pee.element_entry_id = peev.element_entry_id

Line 1585: pay_retro_defn_components prdc2,

1581: pay_entry_process_details pepd,
1582: pay_assignment_actions paa,
1583: pay_payroll_actions ppa,
1584: pay_retro_components prc,
1585: pay_retro_defn_components prdc2,
1586: pay_retro_defn_components prdc
1587: where paa.assignment_action_id = p_asg_act_id
1588: and paa.payroll_action_id = ppa.payroll_action_id
1589: and paa.assignment_id = pee.assignment_id

Line 1586: pay_retro_defn_components prdc

1582: pay_assignment_actions paa,
1583: pay_payroll_actions ppa,
1584: pay_retro_components prc,
1585: pay_retro_defn_components prdc2,
1586: pay_retro_defn_components prdc
1587: where paa.assignment_action_id = p_asg_act_id
1588: and paa.payroll_action_id = ppa.payroll_action_id
1589: and paa.assignment_id = pee.assignment_id
1590: and ppa.date_earned between pee.effective_start_date and pee.effective_end_date