APPS.PAY_GB_EPS_13 dependencies on DUAL

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

953: hr_utility.set_location(' p_effective_date :' || p_effective_date,160);
954: hr_utility.set_location(' p_test_submission :' || p_test_submission,160);
955: hr_utility.set_location(' p_business_group_id :' || p_business_group_id,160);
956:
957: select to_char(to_date(substr(p_effective_date,0,10),'YYYY-MM-DD'),'DD-MON-YYYY') into l_effective_date from dual;
958:
959: open csr_reqid;
960: fetch csr_reqid into l_req_id;
961: close csr_reqid;

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

1134: hr_utility.set_location(' Entering :' || l_proc,160);
1135: hr_utility.set_location(' p_paye_ref :' || p_emp_paye_reference,160);
1136: hr_utility.set_location(' p_effective_date :' || p_effective_date,160);
1137:
1138: select to_char(to_date(substr(p_effective_date,0,10),'YYYY-MM-DD'),'DD-MON-YYYY') into l_effective_date from dual;
1139:
1140: fnd_file.put_line(fnd_file.output,rpad('PAYE Reference : ',20) || p_emp_paye_reference);
1141: fnd_file.put_line(fnd_file.output,rpad('Effective Date : ',20) || l_effective_date);
1142: fnd_file.put_line(fnd_file.output,' ');