DBA Data[Home] [Help]

APPS.PAY_MX_SS_ARCH_TRAN_DATE_UPG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 69: pay_assignment_actions paa,

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
73: AND pai.action_information_category = 'MX SS TRANSACTIONS'

Line 114: pay_assignment_actions paa,

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
118: AND pai.action_information_category = 'MX SS TRANSACTIONS'