eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_DK_ARCHIVE_EHOL dependencies on DUAL

Line 542: SELECT to_char(sysdate,'yyyy-mm-dd') INTO l_date FROM dual;

538: l_le_name := rg_Legal_Emp_Details.name ;
539: l_business_id := rg_Legal_Emp_Details.ORG_INFORMATION1 ; */
540:
541: -- date and time
542: SELECT to_char(sysdate,'yyyy-mm-dd') INTO l_date FROM dual;
543: SELECT to_char(sysdate,'hh:mi:ss') INTO l_time FROM dual;
544:
545: SELECT to_char(sysdate,'yyyymmdd') INTO l_date_id FROM dual;
546: SELECT to_char(sysdate,'hhmiss') INTO l_time_id FROM dual;

Line 543: SELECT to_char(sysdate,'hh:mi:ss') INTO l_time FROM dual;

539: l_business_id := rg_Legal_Emp_Details.ORG_INFORMATION1 ; */
540:
541: -- date and time
542: SELECT to_char(sysdate,'yyyy-mm-dd') INTO l_date FROM dual;
543: SELECT to_char(sysdate,'hh:mi:ss') INTO l_time FROM dual;
544:
545: SELECT to_char(sysdate,'yyyymmdd') INTO l_date_id FROM dual;
546: SELECT to_char(sysdate,'hhmiss') INTO l_time_id FROM dual;
547:

Line 545: SELECT to_char(sysdate,'yyyymmdd') INTO l_date_id FROM dual;

541: -- date and time
542: SELECT to_char(sysdate,'yyyy-mm-dd') INTO l_date FROM dual;
543: SELECT to_char(sysdate,'hh:mi:ss') INTO l_time FROM dual;
544:
545: SELECT to_char(sysdate,'yyyymmdd') INTO l_date_id FROM dual;
546: SELECT to_char(sysdate,'hhmiss') INTO l_time_id FROM dual;
547:
548: if(g_test_submission='Y') then
549: l_test_submission:='T';

Line 546: SELECT to_char(sysdate,'hhmiss') INTO l_time_id FROM dual;

542: SELECT to_char(sysdate,'yyyy-mm-dd') INTO l_date FROM dual;
543: SELECT to_char(sysdate,'hh:mi:ss') INTO l_time FROM dual;
544:
545: SELECT to_char(sysdate,'yyyymmdd') INTO l_date_id FROM dual;
546: SELECT to_char(sysdate,'hhmiss') INTO l_time_id FROM dual;
547:
548: if(g_test_submission='Y') then
549: l_test_submission:='T';
550: else

Line 874: FROM dual;

870: OR (l_report_type = 'PYDKEHOLCA_ANN' and l_hourly_salaried ='H' and l_term_date > l_canonical_end_date)
871: THEN
872: SELECT pay_assignment_actions_s.NEXTVAL
873: INTO l_actid
874: FROM dual;
875:
876: -- Create the archive assignment action
877: hr_nonrun_asact.insact(l_actid
878: ,rec_prepaid_assignments.assignment_id

Line 903: FROM dual;

899: AND l_prev_assg_id <> rec_prepaid_assignments.assignment_id
900: THEN
901: SELECT pay_assignment_actions_s.NEXTVAL
902: INTO l_actid
903: FROM dual;
904:
905: -- Create the archive assignment action
906: hr_nonrun_asact.insact(l_actid
907: ,rec_prepaid_assignments.assignment_id