APPS.PAY_DK_ARCHIVE_EIN dependencies on DUAL

Line 298: SELECT to_char(sysdate,'yyyymmdd') INTO l_date FROM dual;

294: l_le_name := rg_Legal_Emp_Details.name ;
295: l_business_id := rg_Legal_Emp_Details.ORG_INFORMATION1 ; */
296:
297: -- date and time
298: SELECT to_char(sysdate,'yyyymmdd') INTO l_date FROM dual;
299: SELECT to_char(sysdate,'hhmiss') INTO l_time FROM dual;
300:
301: if(g_test_submission='Y') then
302: l_test_submission:='T';

Line 299: SELECT to_char(sysdate,'hhmiss') INTO l_time FROM dual;

295: l_business_id := rg_Legal_Emp_Details.ORG_INFORMATION1 ; */
296:
297: -- date and time
298: SELECT to_char(sysdate,'yyyymmdd') INTO l_date FROM dual;
299: SELECT to_char(sysdate,'hhmiss') INTO l_time FROM dual;
300:
301: if(g_test_submission='Y') then
302: l_test_submission:='T';
303: else

Line 683: FROM dual;

679: AND l_prev_person_id <> rec_prepaid_assignments.person_id THEN
680:
681: SELECT pay_assignment_actions_s.NEXTVAL
682: INTO l_actid
683: FROM dual;
684:
685: -- Create the archive assignment action
686: hr_nonrun_asact.insact(l_actid
687: ,rec_prepaid_assignments.assignment_id