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.PER_PERUSEO1_XMLP_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 481: PER_ALL_ASSIGNMENTS_F ASS,

477: BEGIN
478: SELECT COUNT(PEO.PERSON_ID)
479: INTO L_COUNT_EMPS
480: FROM PER_ALL_PEOPLE_F PEO,
481: PER_ALL_ASSIGNMENTS_F ASS,
482: --PER_JOBS_VL JOB - Replaced PER_JOBS_VL with PER_JOBS - bug#11736960
483: PER_JOBS JOB
484: WHERE PEO.PERSON_ID = ASS.PERSON_ID
485: --

Line 509: PER_ALL_ASSIGNMENTS_F ASS1,

505: AND ASS.EFFECTIVE_START_DATE = (
506: SELECT
507: MAX(ASS1.EFFECTIVE_START_DATE)
508: FROM
509: PER_ALL_ASSIGNMENTS_F ASS1,
510: PER_ASSIGNMENT_STATUS_TYPES AST --Added for bug#12594720
511: WHERE P_PAYROLL_PERIOD_DATE_START_T <= ASS1.EFFECTIVE_END_DATE
512: AND P_PAYROLL_PERIOD_DATE_END_T >= ASS1.EFFECTIVE_START_DATE
513: AND ASS.PERSON_ID = ASS1.PERSON_ID

Line 741: PER_ALL_ASSIGNMENTS_F ASS,

737: ,NULL))
738: INTO CP_HW_CAT,CP_HW_MALE,CP_HW_FEMALE
739: FROM
740: PER_ALL_PEOPLE_F PEO,
741: PER_ALL_ASSIGNMENTS_F ASS,
742: --PER_JOBS_VL JOB - Replaced PER_JOBS_VL with PER_JOBS - bug#11736960
743: PER_JOBS JOB
744: WHERE PEO.PERSON_ID = ASS.PERSON_ID
745: --

Line 772: PER_ALL_ASSIGNMENTS_F ASS1,

768: AND ASS.EFFECTIVE_START_DATE = (
769: SELECT
770: MAX(ASS1.EFFECTIVE_START_DATE)
771: FROM
772: PER_ALL_ASSIGNMENTS_F ASS1,
773: PER_ASSIGNMENT_STATUS_TYPES AST --Added for bug#12594720
774: WHERE P_PAYROLL_PERIOD_DATE_START_T <= ASS1.EFFECTIVE_END_DATE
775: AND P_PAYROLL_PERIOD_DATE_END_T >= ASS1.EFFECTIVE_START_DATE
776: AND ASS.PERSON_ID = ASS1.PERSON_ID

Line 917: PER_ALL_ASSIGNMENTS_F ASS,

913: SELECT
914: COUNT('X')
915: INTO L_COUNT_EMPS
916: FROM
917: PER_ALL_ASSIGNMENTS_F ASS,
918: PER_ALL_PEOPLE_F PEO,
919: --PER_JOBS_VL JOB - Replaced PER_JOBS_VL wth PER_JOBS - bug#11736960
920: PER_JOBS JOB
921: WHERE PEO.PERSON_ID = ASS.PERSON_ID

Line 956: PER_ALL_ASSIGNMENTS_F ASS1,

952: AND ASS.EFFECTIVE_START_DATE = (
953: SELECT
954: MAX(ASS1.EFFECTIVE_START_DATE)
955: FROM
956: PER_ALL_ASSIGNMENTS_F ASS1,
957: PER_ASSIGNMENT_STATUS_TYPES AST --Added for bug#12594720
958: WHERE P_PAYROLL_PERIOD_DATE_START_T <= ASS1.EFFECTIVE_END_DATE
959: AND P_PAYROLL_PERIOD_DATE_END_T >= ASS1.EFFECTIVE_START_DATE
960: AND ASS.PERSON_ID = ASS1.PERSON_ID

Line 1241: PER_ALL_ASSIGNMENTS_F ASS,

1237: JOB.NAME JOB_NAME,
1238: ASS.JOB_ID
1239: FROM
1240: PER_ALL_PEOPLE_F PEO,
1241: PER_ALL_ASSIGNMENTS_F ASS,
1242: --PER_JOBS_VL JOB, - Replaced PER_JOBS_VL with PER_JOBS -bug#11736960
1243: PER_JOBS JOB,
1244: HR_LOCATIONS_ALL HL
1245: WHERE PEO.PERSON_ID = ASS.PERSON_ID

Line 1272: --PER_ASSIGNMENTS_F ASS1 - Replaced PER_ASSIGNMENTS_F with PER_ALL_ASSIGNMENTS_F

1268: AND ASS.EFFECTIVE_START_DATE = (
1269: SELECT
1270: MAX(ASS1.EFFECTIVE_START_DATE)
1271: FROM
1272: --PER_ASSIGNMENTS_F ASS1 - Replaced PER_ASSIGNMENTS_F with PER_ALL_ASSIGNMENTS_F
1273: PER_ALL_ASSIGNMENTS_F ASS1,
1274: PER_ASSIGNMENT_STATUS_TYPES AST --Added for bug#12594720
1275: WHERE P_PAYROLL_PERIOD_DATE_START_T <= ASS1.EFFECTIVE_END_DATE
1276: AND P_PAYROLL_PERIOD_DATE_END_T >= ASS1.EFFECTIVE_START_DATE

Line 1273: PER_ALL_ASSIGNMENTS_F ASS1,

1269: SELECT
1270: MAX(ASS1.EFFECTIVE_START_DATE)
1271: FROM
1272: --PER_ASSIGNMENTS_F ASS1 - Replaced PER_ASSIGNMENTS_F with PER_ALL_ASSIGNMENTS_F
1273: PER_ALL_ASSIGNMENTS_F ASS1,
1274: PER_ASSIGNMENT_STATUS_TYPES AST --Added for bug#12594720
1275: WHERE P_PAYROLL_PERIOD_DATE_START_T <= ASS1.EFFECTIVE_END_DATE
1276: AND P_PAYROLL_PERIOD_DATE_END_T >= ASS1.EFFECTIVE_START_DATE
1277: AND ASS.PERSON_ID = ASS1.PERSON_ID