DBA Data[Home] [Help]

APPS.PAY_PQH_RBC dependencies on PAY_ASSIGNMENT_ACTIONS

Line 46: pay_assignment_actions paa

42: cursor get_pact_de is
43: select ppa.date_earned
44: from pay_payroll_actions ppa,
45: pay_element_entries_f pee,
46: pay_assignment_actions paa
47: where paa.assignment_id=pay_interpreter_pkg.g_asg_id
48: and paa.payroll_action_id=ppa.payroll_action_id
49: and ppa.action_type in ('R','Q')
50: and ppa.date_earned >=pay_interpreter_pkg.g_effective_date