DBA Data[Home] [Help]

APPS.PAY_SE_RULES dependencies on PAY_ASSIGNMENT_ACTIONS

Line 70: ,pay_assignment_actions paa

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

Line 80: FROM pay_assignment_actions paa1

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