APPS.PSP_PREGEN dependencies on DUAL

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

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

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

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

Line 1728: FROM dual;

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