DBA Data[Home] [Help]

APPS.PAY_RETRO_PKG dependencies on PAY_RETRO_DEFN_COMPONENTS

Line 1447: pay_retro_defn_components prdc2,

1443: pay_element_types_f pet1,
1444: pay_input_values_f piv1,
1445: pay_entry_process_details pepd,
1446: pay_retro_components prc,
1447: pay_retro_defn_components prdc2,
1448: pay_retro_defn_components prdc
1449: WHERE pet1.element_type_id = pepd.source_element_type_id
1450: and piv1.element_type_id = pet1.element_type_id
1451: and pepd.source_asg_action_id = p_asg_act_id

Line 1448: pay_retro_defn_components prdc

1444: pay_input_values_f piv1,
1445: pay_entry_process_details pepd,
1446: pay_retro_components prc,
1447: pay_retro_defn_components prdc2,
1448: pay_retro_defn_components prdc
1449: WHERE pet1.element_type_id = pepd.source_element_type_id
1450: and piv1.element_type_id = pet1.element_type_id
1451: and pepd.source_asg_action_id = p_asg_act_id
1452: AND pee.element_entry_id = peev.element_entry_id

Line 1552: pay_retro_defn_components prdc2,

1548: pay_entry_process_details pepd,
1549: pay_assignment_actions paa,
1550: pay_payroll_actions ppa,
1551: pay_retro_components prc,
1552: pay_retro_defn_components prdc2,
1553: pay_retro_defn_components prdc
1554: where paa.assignment_action_id = p_asg_act_id
1555: and paa.payroll_action_id = ppa.payroll_action_id
1556: and paa.assignment_id = pee.assignment_id

Line 1553: pay_retro_defn_components prdc

1549: pay_assignment_actions paa,
1550: pay_payroll_actions ppa,
1551: pay_retro_components prc,
1552: pay_retro_defn_components prdc2,
1553: pay_retro_defn_components prdc
1554: where paa.assignment_action_id = p_asg_act_id
1555: and paa.payroll_action_id = ppa.payroll_action_id
1556: and paa.assignment_id = pee.assignment_id
1557: and ppa.date_earned between pee.effective_start_date and pee.effective_end_date