DBA Data[Home] [Help]

APPS.PAY_FI_RULES dependencies on PAY_ASSIGNMENT_ACTIONS

Line 73: ,pay_assignment_actions paa

69: pai.action_information29 a29, pai1.action_information29 aa29,
70: pai.action_information30 a30, pai1.action_information30 aa30
71: FROM pay_action_information pai
72: ,pay_action_information pai1
73: ,pay_assignment_actions paa
74: WHERE pai.action_context_type = 'PA'
75: AND pai.action_information_category = p_pa_category
76: AND pai1.action_context_type = 'AAP'
77: AND pai1.action_information_category = p_aap_category

Line 83: FROM pay_assignment_actions paa1

79: AND pai.action_context_id = paa.payroll_action_id
80: AND pai1.action_context_id = paa.assignment_action_id
81: AND paa.assignment_action_id in
82: (SELECT paa1.assignment_action_id
83: FROM pay_assignment_actions paa1
84: WHERE paa1.source_action_id = p_action_context_id
85: AND paa1.action_status = 'C'
86: UNION
87: SELECT p_action_context_id