DBA Data[Home] [Help]

APPS.PAY_MX_SS_ARCH_TRAN_DATE_UPG dependencies on PAY_PAYROLL_ACTIONS

Line 68: FROM pay_payroll_actions ppa,

64: ) AS
65:
66: CURSOR csr_qualified IS
67: SELECT 'Y'
68: FROM pay_payroll_actions ppa,
69: pay_assignment_actions paa,
70: pay_action_information pai
71: WHERE ppa.payroll_action_id = paa.payroll_action_id
72: AND paa.assignment_action_id = pai.action_context_id

Line 113: FROM pay_payroll_actions ppa,

109: SELECT pai.action_information2,
110: pai.action_information5,
111: pai.action_information_id,
112: pai.object_version_number
113: FROM pay_payroll_actions ppa,
114: pay_assignment_actions paa,
115: pay_action_information pai
116: WHERE ppa.payroll_action_id = paa.payroll_action_id
117: AND paa.assignment_action_id = pai.action_context_id