APPS.PAY_NO_EOY_ARCHIVE dependencies on DUAL

Line 1422: FROM DUAL;

1418: l_ni_zone_arc := NULL;
1419: --
1420: SELECT DECODE(l_rec2.ni_zone,6,'1a',7,'1a',l_rec2.ni_zone)
1421: INTO l_ni_zone_arc
1422: FROM DUAL;
1423: --
1424: --
1425: -- Archive: EMEA REPORT INFORMATION | LE_SI_LU_TM_INFO
1426: --

Line 1812: SELECT pay_assignment_actions_s.nextval INTO l_assact_id FROM dual;

1808: --
1809: --
1810: -- Create assignment action for archive process.
1811: --
1812: SELECT pay_assignment_actions_s.nextval INTO l_assact_id FROM dual;
1813: hr_nonrun_asact.insact
1814: (l_assact_id
1815: ,l_asg_rec.assignment_id
1816: ,p_payroll_action_id

Line 2251: -- archived individually. i.e. should appear once for each concerned element is processed.

2247: FETCH csr_seaman_bal_status INTO l_seaman_status;
2248: CLOSE csr_seaman_bal_status;
2249: --
2250: -- Check if the code 549 is processed through the payroll, then it should be
2251: -- archived individually. i.e. should appear once for each concerned element is processed.
2252: --
2253: IF l_bal_rec.reporting_code = '549' THEN --IN ('118-A', '549') THEN
2254: --
2255: -- IF l_bal_rec.reporting_code = '118-A' THEN

Line 2798: CURSOR csr_INDIVIDUAL_CODES

2794: AND asg_act.action_context_type = 'AAP'
2795: AND asg_act.action_context_id = paa.assignment_action_id
2796: AND paa.payroll_action_id = p_payroll_action_id;
2797: --
2798: CURSOR csr_INDIVIDUAL_CODES
2799: (p_payroll_action_id IN NUMBER) IS
2800: SELECT asg_act.action_information2 legal_employer_id
2801: ,asg_act.action_information5 person_id
2802: ,asg_act.action_information6 tax_municipality

Line 2837: AND cde_dtl.action_information9 = 'INDIVIDUAL';

2833: AND cde_dtl.action_information_category = 'EMEA REPORT INFORMATION'
2834: AND cde_dtl.action_information1 = 'REP_CODE_DTLS'
2835: AND cde_dtl.action_information2 = asg_act.action_information2
2836: AND cde_dtl.action_information3 = rep_cde.action_information2
2837: AND cde_dtl.action_information9 = 'INDIVIDUAL';
2838: --
2839: CURSOR csr_SUM_CODES
2840: (p_payroll_action_id IN NUMBER) IS
2841: SELECT asg_act.action_information2 legal_employer_id

Line 2973: -- Loop for all reporting codes that are kept as INDIVIDUAL records.

2969: END LOOP;
2970: END LOOP;
2971: --
2972: --
2973: -- Loop for all reporting codes that are kept as INDIVIDUAL records.
2974: --
2975: FOR l_cde_rec IN csr_INDIVIDUAL_CODES
2976: (p_payroll_action_id)
2977: LOOP

Line 2975: FOR l_cde_rec IN csr_INDIVIDUAL_CODES

2971: --
2972: --
2973: -- Loop for all reporting codes that are kept as INDIVIDUAL records.
2974: --
2975: FOR l_cde_rec IN csr_INDIVIDUAL_CODES
2976: (p_payroll_action_id)
2977: LOOP
2978: --
2979: --