APPS.PAY_DK_RULES dependencies on PAY_ASSIGNMENT_ACTIONS

Line 47: ,pay_assignment_actions paa

43: pai.action_information29 a29, pai1.action_information29 aa29,
44: pai.action_information30 a30, pai1.action_information30 aa30
45: FROM pay_action_information pai
46: ,pay_action_information pai1
47: ,pay_assignment_actions paa
48: WHERE pai.action_context_type = 'PA'
49: AND pai.action_information_category = p_pa_category
50: AND pai1.action_context_type = 'AAP'
51: AND ((pai1.action_context_id = p_action_context_id)

Line 54: -- FROM pay_assignment_actions paa

50: AND pai1.action_context_type = 'AAP'
51: AND ((pai1.action_context_id = p_action_context_id)
52: -- OR
53: -- pai1.action_context_id in ( SELECT paa.assignment_action_id
54: -- FROM pay_assignment_actions paa
55: -- WHERE paa.source_action_id = p_action_context_id
56: -- AND paa.assignment_id = pai1.assignment_id
57: -- )
58: )

Line 70: FROM pay_assignment_actions

66: -------------------- cursor to get all the assignment_action_id if run types is enabled -----------------
67:
68: CURSOR csr_run_types(p_action_context_id NUMBER ) IS
69: SELECT assignment_action_id
70: FROM pay_assignment_actions
71: WHERE source_action_id = p_action_context_id
72: AND action_status = 'C'
73: UNION
74: SELECT p_action_context_id assignment_action_id

Line 118: ,pay_assignment_actions paa

114: pai.action_information29 a29, pai1.action_information29 aa29,
115: pai.action_information30 a30, pai1.action_information30 aa30
116: FROM pay_action_information pai
117: ,pay_action_information pai1
118: ,pay_assignment_actions paa
119: WHERE pai.action_context_type = 'PA'
120: AND pai.action_information_category = p_pa_category
121: AND pai1.action_context_type = 'AAP'
122: AND pai1.action_information_category = p_aap_category