APPS.PAY_DK_ARCHIVE_EIN dependencies on DUAL

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

394: l_le_name := rg_Legal_Emp_Details.name ;
395: l_business_id := rg_Legal_Emp_Details.ORG_INFORMATION1 ; */
396:
397: -- date and time
398: SELECT to_char(sysdate,'yyyymmdd') INTO l_date FROM dual;
399: SELECT to_char(sysdate,'hhmiss') INTO l_time FROM dual;
400:
401: if(g_test_submission='Y') then
402: l_test_submission:='T';

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

395: l_business_id := rg_Legal_Emp_Details.ORG_INFORMATION1 ; */
396:
397: -- date and time
398: SELECT to_char(sysdate,'yyyymmdd') INTO l_date FROM dual;
399: SELECT to_char(sysdate,'hhmiss') INTO l_time FROM dual;
400:
401: if(g_test_submission='Y') then
402: l_test_submission:='T';
403: else

Line 809: FROM dual;

805: AND l_prev_assg_id <> rec_prepaid_assignments.assignment_id THEN
806:
807: SELECT pay_assignment_actions_s.NEXTVAL
808: INTO l_actid
809: FROM dual;
810:
811: -- Create the archive assignment action
812: hr_nonrun_asact.insact(l_actid
813: ,rec_prepaid_assignments.assignment_id

Line 2779: select DECODE(l_sex,'M','1','F','2','3') into l_sex from dual;

2775: elsif(l_style = 'DK_GLB') then
2776: l_town_or_city := rg_csr_get_territory.town_or_city;
2777: end if;
2778:
2779: select DECODE(l_sex,'M','1','F','2','3') into l_sex from dual;
2780:
2781: pay_action_information_api.create_action_information (
2782: p_action_information_id => l_action_info_id
2783: ,p_action_context_id => p_assignment_action_id