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
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
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,
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:
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'
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'
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'
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'
247: ,pai1.action_information4 value
248: ,pai1.action_information6 uom
249: FROM pay_action_information pai
250: ,pay_action_information pai1
251: ,pay_assignment_actions paa
252: WHERE pai.action_context_type = 'PA'
253: AND pai.action_information_category = 'EMEA BALANCE DEFINITION'
254: AND pai1.action_context_type = 'AAP'
255: AND pai1.action_information_category = 'EMEA BALANCES'
259: AND pai.action_context_id = paa.payroll_action_id
260: AND pai1.action_context_id = paa.assignment_action_id
261: AND paa.assignment_action_id in
262: (SELECT paa1.assignment_action_id
263: FROM pay_assignment_actions paa1
264: WHERE paa1.source_action_id = p_action_context_id
265: AND paa1.action_status = 'C'
266: UNION
267: SELECT p_action_context_id