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.HR_NO_VALIDATE_PKG dependencies on DUAL

Line 387: SELECT fnd_date.canonical_to_date(p_org_information2) INTO l_curr_start_date FROM DUAL ;

383: -- Bug Fix 4463101 : check for ORG_INFORMATION_CONTEXT
384: ELSIF p_org_info_type_code = 'NO_NI_EXEMPTION_LIMIT' THEN
385:
386: -- converting ORG_INFORMATION1 and 2 into dates
387: SELECT fnd_date.canonical_to_date(p_org_information2) INTO l_curr_start_date FROM DUAL ;
388: SELECT fnd_date.canonical_to_date(p_org_information3) INTO l_curr_end_date FROM DUAL ;
389:
390:
391: -- checking if start date is greater than the end date

Line 388: SELECT fnd_date.canonical_to_date(p_org_information3) INTO l_curr_end_date FROM DUAL ;

384: ELSIF p_org_info_type_code = 'NO_NI_EXEMPTION_LIMIT' THEN
385:
386: -- converting ORG_INFORMATION1 and 2 into dates
387: SELECT fnd_date.canonical_to_date(p_org_information2) INTO l_curr_start_date FROM DUAL ;
388: SELECT fnd_date.canonical_to_date(p_org_information3) INTO l_curr_end_date FROM DUAL ;
389:
390:
391: -- checking if start date is greater than the end date
392: IF (l_curr_start_date > l_curr_end_date )

Line 405: SELECT fnd_date.canonical_to_date(csr_rec.p_org_info2) INTO l_start_date FROM DUAL ;

401: /* -- now checking with other records of exemption limits entered
402: FOR csr_rec IN csr_get_exemption_lim_details ( p_organization_id ) LOOP
403:
404: -- converting ORG_INFORMATION1 and 2 into dates
405: SELECT fnd_date.canonical_to_date(csr_rec.p_org_info2) INTO l_start_date FROM DUAL ;
406: SELECT fnd_date.canonical_to_date(csr_rec.p_org_info3) INTO l_end_date FROM DUAL ;
407:
408: IF (l_curr_start_date BETWEEN l_start_date AND l_end_date ) OR
409: (l_curr_end_date BETWEEN l_start_date AND l_end_date ) OR

Line 406: SELECT fnd_date.canonical_to_date(csr_rec.p_org_info3) INTO l_end_date FROM DUAL ;

402: FOR csr_rec IN csr_get_exemption_lim_details ( p_organization_id ) LOOP
403:
404: -- converting ORG_INFORMATION1 and 2 into dates
405: SELECT fnd_date.canonical_to_date(csr_rec.p_org_info2) INTO l_start_date FROM DUAL ;
406: SELECT fnd_date.canonical_to_date(csr_rec.p_org_info3) INTO l_end_date FROM DUAL ;
407:
408: IF (l_curr_start_date BETWEEN l_start_date AND l_end_date ) OR
409: (l_curr_end_date BETWEEN l_start_date AND l_end_date ) OR
410: (l_start_date BETWEEN l_curr_start_date AND l_curr_end_date ) OR

Line 869: SELECT fnd_date.canonical_to_date(p_org_information2) INTO l_curr_start_date FROM DUAL ;

865: -- Bug Fix 4463101 : check for ORG_INFORMATION_CONTEXT
866: ELSIF p_org_info_type_code = 'NO_NI_EXEMPTION_LIMIT' THEN
867:
868: -- converting ORG_INFORMATION1 and 2 into dates
869: SELECT fnd_date.canonical_to_date(p_org_information2) INTO l_curr_start_date FROM DUAL ;
870: SELECT fnd_date.canonical_to_date(p_org_information3) INTO l_curr_end_date FROM DUAL ;
871:
872:
873: -- checking if start date is greater than the end date

Line 870: SELECT fnd_date.canonical_to_date(p_org_information3) INTO l_curr_end_date FROM DUAL ;

866: ELSIF p_org_info_type_code = 'NO_NI_EXEMPTION_LIMIT' THEN
867:
868: -- converting ORG_INFORMATION1 and 2 into dates
869: SELECT fnd_date.canonical_to_date(p_org_information2) INTO l_curr_start_date FROM DUAL ;
870: SELECT fnd_date.canonical_to_date(p_org_information3) INTO l_curr_end_date FROM DUAL ;
871:
872:
873: -- checking if start date is greater than the end date
874: IF (l_curr_start_date > l_curr_end_date )

Line 887: SELECT fnd_date.canonical_to_date(csr_rec.p_org_info2) INTO l_start_date FROM DUAL ;

883: -- now checking with other records of exemption limits entered
884: FOR csr_rec IN csr_get_exemption_details ( l_organization_id , p_org_information_id ) LOOP
885:
886: -- converting ORG_INFORMATION1 and 2 into dates
887: SELECT fnd_date.canonical_to_date(csr_rec.p_org_info2) INTO l_start_date FROM DUAL ;
888: SELECT fnd_date.canonical_to_date(csr_rec.p_org_info3) INTO l_end_date FROM DUAL ;
889:
890: IF (l_curr_start_date BETWEEN l_start_date AND l_end_date ) OR
891: (l_curr_end_date BETWEEN l_start_date AND l_end_date ) OR

Line 888: SELECT fnd_date.canonical_to_date(csr_rec.p_org_info3) INTO l_end_date FROM DUAL ;

884: FOR csr_rec IN csr_get_exemption_details ( l_organization_id , p_org_information_id ) LOOP
885:
886: -- converting ORG_INFORMATION1 and 2 into dates
887: SELECT fnd_date.canonical_to_date(csr_rec.p_org_info2) INTO l_start_date FROM DUAL ;
888: SELECT fnd_date.canonical_to_date(csr_rec.p_org_info3) INTO l_end_date FROM DUAL ;
889:
890: IF (l_curr_start_date BETWEEN l_start_date AND l_end_date ) OR
891: (l_curr_end_date BETWEEN l_start_date AND l_end_date ) OR
892: (l_start_date BETWEEN l_curr_start_date AND l_curr_end_date ) OR