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.PQH_PQIPED9_XMLP_PKG dependencies on FND_DATE

Line 223: AND FND_DATE.CANONICAL_TO_DATE(PPET.PEI_INFORMATION2) <= P_REPORT_DATE

219: AND PEO.CURRENT_EMPLOYEE_FLAG = 'Y'
220: AND PPET.PEI_INFORMATION_CATEGORY = 'PQH_TENURE_STATUS'
221: AND PQH_EMPLOYMENT_CATEGORY.GET_SERVICE_START_DATE(PAF.PERIOD_OF_SERVICE_ID) BETWEEN CP_HIRE_DATE
222: AND P_REPORT_DATE
223: AND FND_DATE.CANONICAL_TO_DATE(PPET.PEI_INFORMATION2) <= P_REPORT_DATE
224: AND PPET.PEI_INFORMATION1 = '01'
225: AND PPET.PEI_INFORMATION1 IS NOT NULL
226: AND PAF.PRIMARY_FLAG = 'Y'
227: AND PAF.ASSIGNMENT_TYPE = 'E'

Line 391: AND FND_DATE.CANONICAL_TO_DATE(PPET.PEI_INFORMATION2) <= P_REPORT_DATE

387: WHERE PEI3.PERSON_ID = PEI.PERSON_ID ) ) )
388: AND PPET.PEI_INFORMATION_CATEGORY = 'PQH_TENURE_STATUS'
389: AND PQH_EMPLOYMENT_CATEGORY.GET_SERVICE_START_DATE(PAF.PERIOD_OF_SERVICE_ID) BETWEEN CP_HIRE_DATE
390: AND P_REPORT_DATE
391: AND FND_DATE.CANONICAL_TO_DATE(PPET.PEI_INFORMATION2) <= P_REPORT_DATE
392: AND PPET.PEI_INFORMATION1 = '01'
393: AND PPET.PEI_INFORMATION1 IS NOT NULL
394: AND PAF.PRIMARY_FLAG = 'Y'
395: AND PAF.ASSIGNMENT_TYPE = 'E'

Line 586: AND FND_DATE.CANONICAL_TO_DATE(PPET.PEI_INFORMATION2) <= P_REPORT_DATE

582: AND PEO.CURRENT_EMPLOYEE_FLAG = 'Y'
583: AND PPET.PEI_INFORMATION_CATEGORY = 'PQH_TENURE_STATUS'
584: AND PQH_EMPLOYMENT_CATEGORY.GET_SERVICE_START_DATE(PAF.PERIOD_OF_SERVICE_ID) BETWEEN CP_HIRE_DATE
585: AND P_REPORT_DATE
586: AND FND_DATE.CANONICAL_TO_DATE(PPET.PEI_INFORMATION2) <= P_REPORT_DATE
587: AND PPET.PEI_INFORMATION1 in ( '02' , '04' )
588: AND PPET.PEI_INFORMATION1 IS NOT NULL
589: AND PAF.PRIMARY_FLAG = 'Y'
590: AND PAF.ASSIGNMENT_TYPE = 'E'

Line 754: AND FND_DATE.CANONICAL_TO_DATE(PPET.PEI_INFORMATION2) <= P_REPORT_DATE

750: WHERE PEI3.PERSON_ID = PEI.PERSON_ID ) ) )
751: AND PPET.PEI_INFORMATION_CATEGORY = 'PQH_TENURE_STATUS'
752: AND PQH_EMPLOYMENT_CATEGORY.GET_SERVICE_START_DATE(PAF.PERIOD_OF_SERVICE_ID) BETWEEN CP_HIRE_DATE
753: AND P_REPORT_DATE
754: AND FND_DATE.CANONICAL_TO_DATE(PPET.PEI_INFORMATION2) <= P_REPORT_DATE
755: AND PPET.PEI_INFORMATION1 in ( '02' , '04' )
756: AND PPET.PEI_INFORMATION1 IS NOT NULL
757: AND PAF.PRIMARY_FLAG = 'Y'
758: AND PAF.ASSIGNMENT_TYPE = 'E'

Line 952: AND FND_DATE.CANONICAL_TO_DATE(PET.PEI_INFORMATION2) <= P_REPORT_DATE )

948: PER_PEOPLE_EXTRA_INFO PET
949: WHERE PET.PERSON_ID = PEO.PERSON_ID
950: AND PET.PEI_INFORMATION_CATEGORY in ( 'PQH_TENURE_STATUS' )
951: AND PET.PEI_INFORMATION1 in ( '01' , '02' , '04' )
952: AND FND_DATE.CANONICAL_TO_DATE(PET.PEI_INFORMATION2) <= P_REPORT_DATE )
953: AND PQH_EMPLOYMENT_CATEGORY.GET_SERVICE_START_DATE(PAF.PERIOD_OF_SERVICE_ID) BETWEEN CP_HIRE_DATE
954: AND P_REPORT_DATE
955: AND PAF.PRIMARY_FLAG = 'Y'
956: AND PAF.ASSIGNMENT_TYPE = 'E'

Line 1123: AND FND_DATE.CANONICAL_TO_DATE(PET.PEI_INFORMATION2) <= P_REPORT_DATE )

1119: PER_PEOPLE_EXTRA_INFO PET
1120: WHERE PET.PERSON_ID = PEO.PERSON_ID
1121: AND PET.PEI_INFORMATION_CATEGORY in ( 'PQH_TENURE_STATUS' )
1122: AND PET.PEI_INFORMATION1 in ( '01' , '02' , '04' )
1123: AND FND_DATE.CANONICAL_TO_DATE(PET.PEI_INFORMATION2) <= P_REPORT_DATE )
1124: AND PQH_EMPLOYMENT_CATEGORY.GET_SERVICE_START_DATE(PAF.PERIOD_OF_SERVICE_ID) BETWEEN CP_HIRE_DATE
1125: AND P_REPORT_DATE
1126: AND PAF.PRIMARY_FLAG = 'Y'
1127: AND PAF.ASSIGNMENT_TYPE = 'E'