APPS.PAY_PAYROLL_XML_EXTRACT_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 235: FROM pay_assignment_actions paa_xfr,

231: AND application_id = 801; /* Bug 6522667 */
232:
233: CURSOR csr_get_chk_no IS
234: SELECT paa_chk.serial_number
235: FROM pay_assignment_actions paa_xfr,
236: pay_action_interlocks pai_xfr,
237: pay_action_interlocks pai_chk,
238: pay_assignment_actions paa_chk,
239: pay_payroll_actions ppa_chk

Line 238: pay_assignment_actions paa_chk,

234: SELECT paa_chk.serial_number
235: FROM pay_assignment_actions paa_xfr,
236: pay_action_interlocks pai_xfr,
237: pay_action_interlocks pai_chk,
238: pay_assignment_actions paa_chk,
239: pay_payroll_actions ppa_chk
240: WHERE paa_xfr.assignment_action_id = pai_xfr.locking_action_id
241: AND pai_xfr.locked_action_id = pai_chk.locked_action_id
242: AND pai_chk.locking_action_id = paa_chk.assignment_action_id

Line 250: l_chk_no pay_assignment_actions.serial_number%type;

246:
247: l_proc_name varchar2(100);
248: l_tag_name varchar2(500);
249: l_segment_name varchar2(500);
250: l_chk_no pay_assignment_actions.serial_number%type;
251: l_data pay_action_information.action_information1%type;
252: l_data_tag varchar2(500);
253:
254: BEGIN

Line 538: FROM pay_assignment_actions paa,

534: ) AS
535:
536: CURSOR get_leg_code IS
537: SELECT hoi2.org_information9
538: FROM pay_assignment_actions paa,
539: pay_payroll_actions ppa,
540: hr_organization_units hou,
541: hr_organization_information hoi1,
542: hr_organization_information hoi2

Line 568: FROM pay_assignment_actions

564: AND action_context_id = p_action_context_id)
565: OR (action_context_type = 'PA'
566: AND action_context_id =
567: (SELECT payroll_action_id
568: FROM pay_assignment_actions
569: WHERE assignment_action_id = p_action_context_id)))
570: OR (action_information_id = p_action_information_id
571: AND p_action_information_id IS NOT NULL)
572: ORDER BY decode (action_information_category,'EMPLOYEE DETAILS', 1, 2);

Line 583: pay_assignment_actions paa

579: /*14105250 -- Start*/
580: CURSOR c_bgid (cp_assgn_action_id in number) is
581: SELECT business_group_id
582: FROM pay_payroll_actions ppa,
583: pay_assignment_actions paa
584: WHERE
585: paa.payroll_action_id = ppa.payroll_action_id
586: AND paa.assignment_action_id=cp_assgn_action_id;
587: lt_per_bgId_value number;

Line 1293: FROM pay_assignment_actions paa,

1289: ) AS
1290:
1291: CURSOR get_leg_code IS
1292: SELECT hoi2.org_information9
1293: FROM pay_assignment_actions paa,
1294: pay_payroll_actions ppa,
1295: hr_organization_units hou,
1296: hr_organization_information hoi1,
1297: hr_organization_information hoi2

Line 1323: FROM pay_assignment_actions

1319: AND action_context_id = p_action_context_id)
1320: OR (action_context_type = 'PA'
1321: AND action_context_id =
1322: (SELECT payroll_action_id
1323: FROM pay_assignment_actions
1324: WHERE assignment_action_id = p_action_context_id)))
1325: OR (action_information_id = p_action_information_id
1326: AND p_action_information_id IS NOT NULL)
1327: ORDER BY decode (action_information_category,'EMPLOYEE DETAILS', 1, 2);