APPS.PAY_AE_RULES dependencies on PAY_ASSIGNMENT_ACTIONS

Line 55: FROM pay_assignment_actions paa_xfr,

51: AND application_column_name = UPPER (p_node);
52:
53: CURSOR csr_get_chk_no IS
54: SELECT paa_chk.serial_number
55: FROM pay_assignment_actions paa_xfr,
56: pay_action_interlocks pai_xfr,
57: pay_action_interlocks pai_chk,
58: pay_assignment_actions paa_chk,
59: pay_payroll_actions ppa_chk

Line 58: pay_assignment_actions paa_chk,

54: SELECT paa_chk.serial_number
55: FROM pay_assignment_actions paa_xfr,
56: pay_action_interlocks pai_xfr,
57: pay_action_interlocks pai_chk,
58: pay_assignment_actions paa_chk,
59: pay_payroll_actions ppa_chk
60: WHERE paa_xfr.assignment_action_id = pai_xfr.locking_action_id
61: AND pai_xfr.locked_action_id = pai_chk.locked_action_id
62: AND pai_chk.locking_action_id = paa_chk.assignment_action_id

Line 68: l_chk_no pay_assignment_actions.serial_number%type;

64: AND ppa_chk.action_type = 'H'
65: AND paa_xfr.assignment_action_id = g_action_ctx_id;
66:
67: l_tag_name varchar2(500);
68: l_chk_no pay_assignment_actions.serial_number%type;
69: l_data pay_action_information.action_information1%type;
70:
71: PROCEDURE LOAD_XML_INTERNAL (
72: P_NODE_TYPE varchar2,

Line 158: FROM pay_assignment_actions paa

154: AND pai.action_context_type = 'AAP'
155: AND pai.action_information_category = 'EMPLOYEE DETAILS'
156: AND (pai.action_context_id = p_action_context_id
157: OR pai.action_context_id = ( SELECT paa.source_action_id
158: FROM pay_assignment_actions paa
159: WHERE paa.assignment_action_id = p_action_context_id
160: -- AND paa.assignment_id = pai.assignment_id
161: ));
162:

Line 174: ,pay_assignment_actions paa

170: ,pai.action_information6 uom
171: ,sum(pai1.action_information4) value
172: FROM pay_action_information pai
173: ,pay_action_information pai1
174: ,pay_assignment_actions paa
175: WHERE pai.action_context_type = 'PA'
176: AND pai.action_information_category = 'EMEA ELEMENT DEFINITION'
177: AND pai1.action_context_type = 'AAP'
178: AND pai.action_information5 <> 'F'

Line 181: FROM pay_assignment_actions paa

177: AND pai1.action_context_type = 'AAP'
178: AND pai.action_information5 <> 'F'
179: AND pai1.action_information3 <> 'F'
180: /*AND ( pai1.action_context_id IN ( SELECT paa.assignment_action_id
181: FROM pay_assignment_actions paa
182: WHERE paa.source_action_id = p_action_context_id
183: AND paa.assignment_id = pai1.assignment_id)
184: OR pai1.action_context_id = p_action_context_id)*/
185: and pai1.action_information_category = 'EMEA ELEMENT INFO'

Line 210: ,pay_assignment_actions paa

206: ,pai.action_information6 uom
207: ,pai1.action_information4 value
208: FROM pay_action_information pai
209: ,pay_action_information pai1
210: ,pay_assignment_actions paa
211: WHERE pai.action_context_type = 'PA'
212: AND pai.action_information_category = 'EMEA ELEMENT DEFINITION'
213: AND pai1.action_context_type = 'AAP'
214: AND pai.action_information5 = 'F'

Line 217: FROM pay_assignment_actions paa

213: AND pai1.action_context_type = 'AAP'
214: AND pai.action_information5 = 'F'
215: AND pai1.action_information3 = 'F'
216: /*AND ( pai1.action_context_id IN ( SELECT paa.assignment_action_id
217: FROM pay_assignment_actions paa
218: WHERE paa.source_action_id = p_action_context_id
219: AND paa.assignment_id = pai1.assignment_id)
220: OR pai1.action_context_id = p_action_context_id)*/
221: AND pai1.action_information_category = 'EMEA ELEMENT INFO'

Line 252: ,pay_assignment_actions paa

248: ,pai1.action_information4 value
249: ,pai1.action_information6 uom
250: FROM pay_action_information pai
251: ,pay_action_information pai1
252: ,pay_assignment_actions paa
253: WHERE pai.action_context_type = 'PA'
254: AND pai.action_information_category = 'EMEA BALANCE DEFINITION'
255: AND pai1.action_context_type = 'AAP'
256: AND pai1.action_information_category = 'EMEA BALANCES'

Line 264: FROM pay_assignment_actions paa1

260: AND pai.action_context_id = paa.payroll_action_id
261: AND pai1.action_context_id = paa.assignment_action_id
262: AND paa.assignment_action_id in
263: (SELECT paa1.assignment_action_id
264: FROM pay_assignment_actions paa1
265: WHERE paa1.source_action_id = p_action_context_id
266: AND paa1.action_status = 'C'
267: UNION
268: SELECT p_action_context_id