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 391: SELECT fnd_date.canonical_to_date(p_org_information2) INTO l_curr_start_date FROM DUAL ;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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