APPS.PAY_GB_EPS dependencies on DUAL

Line 820: select to_char(to_date(substr(p_effective_date,0,10),'YYYY-MM-DD'),'DD-MON-YYYY') into l_effective_date from dual;

816: hr_utility.set_location(' p_final_submission :' || p_final_submission,160);
817: hr_utility.set_location(' p_test_submission :' || p_test_submission,160);
818: hr_utility.set_location(' p_business_group_id :' || p_business_group_id,160);
819:
820: select to_char(to_date(substr(p_effective_date,0,10),'YYYY-MM-DD'),'DD-MON-YYYY') into l_effective_date from dual;
821:
822: open csr_reqid;
823: fetch csr_reqid into l_req_id;
824: close csr_reqid;

Line 998: select to_char(to_date(substr(p_effective_date,0,10),'YYYY-MM-DD'),'DD-MON-YYYY') into l_effective_date from dual;

994: hr_utility.set_location(' Entering :' || l_proc,160);
995: hr_utility.set_location(' p_paye_ref :' || p_emp_paye_reference,160);
996: hr_utility.set_location(' p_effective_date :' || p_effective_date,160);
997:
998: select to_char(to_date(substr(p_effective_date,0,10),'YYYY-MM-DD'),'DD-MON-YYYY') into l_effective_date from dual;
999:
1000: fnd_file.put_line(fnd_file.output,rpad('PAYE Reference : ',20) || p_emp_paye_reference);
1001: fnd_file.put_line(fnd_file.output,rpad('Effective Date : ',20) || l_effective_date);
1002: fnd_file.put_line(fnd_file.output,' ');