APPS.PAY_NO_EOY_ARCHIVE dependencies on DUAL

Line 1600: FROM DUAL;

1596: l_ni_zone_arc := NULL;
1597: --
1598: SELECT DECODE(l_rec2.ni_zone,6,'1a',7,'1a',l_rec2.ni_zone)
1599: INTO l_ni_zone_arc
1600: FROM DUAL;
1601: --
1602: --
1603: -- Archive: EMEA REPORT INFORMATION | LE_SI_LU_TM_INFO
1604: --

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

1990: --
1991: --
1992: -- Create assignment action for archive process.
1993: --
1994: SELECT pay_assignment_actions_s.nextval INTO l_assact_id FROM dual;
1995: hr_nonrun_asact.insact
1996: (l_assact_id
1997: ,l_asg_rec.assignment_id
1998: ,p_payroll_action_id

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

2525: FETCH csr_seaman_bal_status INTO l_seaman_status;
2526: CLOSE csr_seaman_bal_status;
2527: --
2528: -- Check if the code 549 is processed through the payroll, then it should be
2529: -- archived individually. i.e. should appear once for each concerned element is processed.
2530: --
2531: IF l_bal_rec.reporting_code = '549' THEN --IN ('118-A', '549') THEN
2532: --
2533: -- IF l_bal_rec.reporting_code = '118-A' THEN

Line 3206: CURSOR csr_INDIVIDUAL_CODES

3202: AND asg_act.action_context_type = 'AAP'
3203: AND asg_act.action_context_id = paa.assignment_action_id
3204: AND paa.payroll_action_id = p_payroll_action_id;
3205: --
3206: CURSOR csr_INDIVIDUAL_CODES
3207: (p_payroll_action_id IN NUMBER) IS
3208: SELECT asg_act.action_information2 legal_employer_id
3209: ,asg_act.action_information5 person_id
3210: ,asg_act.action_information6 tax_municipality

Line 3253: AND cde_dtl.action_information9 = 'INDIVIDUAL'

3249: AND cde_dtl.action_information_category = 'EMEA REPORT INFORMATION'
3250: AND cde_dtl.action_information1 = 'REP_CODE_DTLS'
3251: AND cde_dtl.action_information2 = asg_act.action_information2
3252: AND cde_dtl.action_information3 = rep_cde.action_information2
3253: AND cde_dtl.action_information9 = 'INDIVIDUAL'
3254: AND rep_cde.action_information2 <> '113-A'; -- added bug 16084022
3255: /* bug 16084022 start */
3256: CURSOR csr_113_continous
3257: (p_payroll_action_id IN NUMBER) IS

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

3495: END LOOP;
3496: END LOOP;
3497: --
3498: --
3499: -- Loop for all reporting codes that are kept as INDIVIDUAL records.
3500: --
3501: FOR l_cde_rec IN csr_INDIVIDUAL_CODES
3502: (p_payroll_action_id)
3503: LOOP

Line 3501: FOR l_cde_rec IN csr_INDIVIDUAL_CODES

3497: --
3498: --
3499: -- Loop for all reporting codes that are kept as INDIVIDUAL records.
3500: --
3501: FOR l_cde_rec IN csr_INDIVIDUAL_CODES
3502: (p_payroll_action_id)
3503: LOOP
3504: --
3505: --