APPS.PSP_PREGEN dependencies on DUAL

Line 855: select psp_payroll_controls_s.nextval into l_control_id from dual;

851: if ( nvl(l_ft_source_code,' ') <> nvl(g_for_total_rec.source_code,' ') or
852: nvl(l_ft_time_period_id, 0) <> nvl(g_for_total_rec.time_period_id,0)) then
853: -- Insert a record in psp_payroll_controls
854: --dbms_output.PUT_LINE('...Before Insert into payroll controls ' );
855: select psp_payroll_controls_s.nextval into l_control_id from dual;
856:
857: -- Introduced for bug fix 2916848
858: OPEN period_end_date_cur(l_ft_time_period_id);
859: FETCH period_end_date_cur INTO l_period_end_date;

Line 942: select psp_payroll_controls_s.nextval into l_control_id from dual;

938: end if;
939: END LOOP;
940: -- Insert the last record into payroll_controls
941: --dbms_output.PUT_LINE('...Before Insert into payroll controls ' );
942: select psp_payroll_controls_s.nextval into l_control_id from dual;
943:
944: -- Introduced for bug fix 2916848
945: OPEN period_end_date_cur(l_ft_time_period_id);
946: FETCH period_end_date_cur INTO l_period_end_date;

Line 1731: FROM dual;

1727: -- The above code added by PVELAMUR tp fix the bug 900768
1728:
1729: SELECT least(l_payroll_end_date,l_project_end_date,l_award_end_date,l_task_end_date,l_termination_date)
1730: INTO l_effective_date
1731: FROM dual;
1732: return l_effective_date;
1733: else
1734: return l_payroll_end_date;
1735: end if;