DBA Data[Home] [Help]

APPS.PAY_NO_RULES dependencies on PAY_ASSIGNMENT_ACTIONS

Line 9: FROM pay_assignment_actions

5: -------------------- cursor to get all the assignment_action_id if run types is enabled -----------------
6:
7: CURSOR csr_run_types(p_action_context_id NUMBER ) IS
8: SELECT assignment_action_id
9: FROM pay_assignment_actions
10: WHERE source_action_id = p_action_context_id
11: AND action_status = 'C'
12: UNION
13: SELECT p_action_context_id assignment_action_id

Line 57: ,pay_assignment_actions paa

53: pai.action_information29 a29, pai1.action_information29 aa29,
54: pai.action_information30 a30, pai1.action_information30 aa30
55: FROM pay_action_information pai
56: ,pay_action_information pai1
57: ,pay_assignment_actions paa
58: WHERE pai.action_context_type = 'PA'
59: AND pai.action_information_category = p_pa_category
60: AND pai1.action_context_type = 'AAP'
61: AND pai1.action_information_category = p_aap_category