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 416: AND FND_DATE.CANONICAL_TO_DATE(PPET.PEI_INFORMATION2) <= P_REPORT_DATE

412: AND PEO.CURRENT_EMPLOYEE_FLAG = 'Y'
413: AND PPET.PEI_INFORMATION_CATEGORY = 'PQH_TENURE_STATUS'
414: AND PQH_EMPLOYMENT_CATEGORY.GET_SERVICE_START_DATE(PAF.PERIOD_OF_SERVICE_ID) BETWEEN CP_HIRE_DATE
415: AND P_REPORT_DATE
416: AND FND_DATE.CANONICAL_TO_DATE(PPET.PEI_INFORMATION2) <= P_REPORT_DATE
417: AND PPET.PEI_INFORMATION1 = '01'
418: AND PPET.PEI_INFORMATION1 IS NOT NULL
419: AND PAF.PRIMARY_FLAG = 'Y'
420: AND PAF.ASSIGNMENT_TYPE = 'E'

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

581: WHERE PEI3.PERSON_ID = PEI.PERSON_ID ) ) )
582: AND PPET.PEI_INFORMATION_CATEGORY = 'PQH_TENURE_STATUS'
583: AND PQH_EMPLOYMENT_CATEGORY.GET_SERVICE_START_DATE(PAF.PERIOD_OF_SERVICE_ID) BETWEEN CP_HIRE_DATE
584: AND P_REPORT_DATE
585: AND FND_DATE.CANONICAL_TO_DATE(PPET.PEI_INFORMATION2) <= P_REPORT_DATE
586: AND PPET.PEI_INFORMATION1 = '01'
587: AND PPET.PEI_INFORMATION1 IS NOT NULL
588: AND PAF.PRIMARY_FLAG = 'Y'
589: AND PAF.ASSIGNMENT_TYPE = 'E'

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

965: AND PEO.CURRENT_EMPLOYEE_FLAG = 'Y'
966: AND PPET.PEI_INFORMATION_CATEGORY = 'PQH_TENURE_STATUS'
967: AND PQH_EMPLOYMENT_CATEGORY.GET_SERVICE_START_DATE(PAF.PERIOD_OF_SERVICE_ID) BETWEEN CP_HIRE_DATE
968: AND P_REPORT_DATE
969: AND FND_DATE.CANONICAL_TO_DATE(PPET.PEI_INFORMATION2) <= P_REPORT_DATE
970: AND PPET.PEI_INFORMATION1 in ( '02' , '04' )
971: AND PPET.PEI_INFORMATION1 IS NOT NULL
972: AND PAF.PRIMARY_FLAG = 'Y'
973: AND PAF.ASSIGNMENT_TYPE = 'E'

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

1134: WHERE PEI3.PERSON_ID = PEI.PERSON_ID ) ) )
1135: AND PPET.PEI_INFORMATION_CATEGORY = 'PQH_TENURE_STATUS'
1136: AND PQH_EMPLOYMENT_CATEGORY.GET_SERVICE_START_DATE(PAF.PERIOD_OF_SERVICE_ID) BETWEEN CP_HIRE_DATE
1137: AND P_REPORT_DATE
1138: AND FND_DATE.CANONICAL_TO_DATE(PPET.PEI_INFORMATION2) <= P_REPORT_DATE
1139: AND PPET.PEI_INFORMATION1 in ( '02' , '04' )
1140: AND PPET.PEI_INFORMATION1 IS NOT NULL
1141: AND PAF.PRIMARY_FLAG = 'Y'
1142: AND PAF.ASSIGNMENT_TYPE = 'E'

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

1521: PER_PEOPLE_EXTRA_INFO PET
1522: WHERE PET.PERSON_ID = PEO.PERSON_ID
1523: AND PET.PEI_INFORMATION_CATEGORY in ( 'PQH_TENURE_STATUS' )
1524: AND PET.PEI_INFORMATION1 in ( '01' , '02' , '04' )
1525: AND FND_DATE.CANONICAL_TO_DATE(PET.PEI_INFORMATION2) <= P_REPORT_DATE )
1526: AND PQH_EMPLOYMENT_CATEGORY.GET_SERVICE_START_DATE(PAF.PERIOD_OF_SERVICE_ID) BETWEEN CP_HIRE_DATE
1527: AND P_REPORT_DATE
1528: AND PAF.PRIMARY_FLAG = 'Y'
1529: AND PAF.ASSIGNMENT_TYPE = 'E'

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

1693: PER_PEOPLE_EXTRA_INFO PET
1694: WHERE PET.PERSON_ID = PEO.PERSON_ID
1695: AND PET.PEI_INFORMATION_CATEGORY in ( 'PQH_TENURE_STATUS' )
1696: AND PET.PEI_INFORMATION1 in ( '01' , '02' , '04' )
1697: AND FND_DATE.CANONICAL_TO_DATE(PET.PEI_INFORMATION2) <= P_REPORT_DATE )
1698: AND PQH_EMPLOYMENT_CATEGORY.GET_SERVICE_START_DATE(PAF.PERIOD_OF_SERVICE_ID) BETWEEN CP_HIRE_DATE
1699: AND P_REPORT_DATE
1700: AND PAF.PRIMARY_FLAG = 'Y'
1701: AND PAF.ASSIGNMENT_TYPE = 'E'