APPS.PAY_FI_ARCHIVE_DPSA dependencies on DUAL

Line 632: FROM dual;

628: AND l_prev_person_id <> rec_prepaid_assignments.person_id THEN
629:
630: SELECT pay_assignment_actions_s.NEXTVAL
631: INTO l_actid
632: FROM dual;
633:
634: -- Create the archive assignment action
635:
636: hr_nonrun_asact.insact(l_actid

Line 665: FROM dual;

661: AND l_prev_person_id <> rec_prepaid_assignments.person_id THEN
662:
663: SELECT pay_assignment_actions_s.NEXTVAL
664: INTO l_actid
665: FROM dual;
666:
667: -- Create the archive assignment action
668: hr_nonrun_asact.insact(l_actid
669: ,rec_prepaid_assignments.assignment_id

Line 2567: FROM DUAL;

2563: LOOP
2564:
2565: SELECT LAST_DAY(TO_DATE('01'||LPAD(i,2,'0')||g_year,'DDMMYYYY')) , LPAD(i,2,'0')
2566: INTO l_bal_date, l_month
2567: FROM DUAL;
2568:
2569: IF TO_NUMBER(TO_CHAR(l_bal_date,'MM')) <= TO_NUMBER(TO_CHAR(rg_csr_asg_effective_date.EFFECTIVE_END_DATE,'MM')) THEN
2570:
2571:

Line 2993: FROM DUAL;

2989: FOR i IN 1..12
2990: LOOP
2991: SELECT LAST_DAY(TO_DATE('01'||LPAD(i,2,'0')||g_year,'DDMMYYYY')),LPAD(i,2,'0')
2992: INTO l_bal_date,l_month
2993: FROM DUAL;
2994:
2995: IF TO_NUMBER(TO_CHAR(l_bal_date,'MM')) <= TO_NUMBER(TO_CHAR(rg_csr_asg_effective_date.EFFECTIVE_END_DATE,'MM')) THEN
2996:
2997: CODE_014:= 0;