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.OTA_MANDATORY_ENROLL_UTIL dependencies on PER_ALL_POSITIONS

Line 818: position_id per_all_positions.position_id%type,

814:
815: TYPE learner_rec IS RECORD(
816: person_id per_all_people_f.person_id%type,
817: job_id per_jobs_tl.job_id%type,
818: position_id per_all_positions.position_id%type,
819: completed_crs_prereq varchar2(1),
820: completed_comp_prereq varchar2(1),
821: organization_id per_all_assignments_f.organization_id%type,
822: assignment_id per_all_assignments_f.assignment_id%type

Line 900: ,per_all_positions pps

896: , paf.assignment_id
897: FROM per_all_people_f ppf
898: ,per_all_assignments_f paf
899: ,per_jobs_tl pjt
900: ,per_all_positions pps
901: ,per_person_type_usages_f ptu
902: ,per_person_types pts
903: ,hr_all_organization_units_tl orgTl
904: ,per_business_groups pbg

Line 1023: ,per_all_positions pps

1019: , paf.assignment_id assignment_id
1020: FROM per_all_people_f ppf
1021: ,per_all_assignments_f paf
1022: ,per_jobs_tl pjt
1023: ,per_all_positions pps
1024: ,per_person_type_usages_f ptu
1025: ,per_person_types pts
1026: ,per_person_types_tl ptt
1027: ,hr_all_organization_units_tl orgTl

Line 1201: position_id per_all_positions.position_id%type,

1197:
1198: TYPE learner_rec IS RECORD(
1199: person_id per_all_people_f.person_id%type,
1200: job_id per_jobs_tl.job_id%type,
1201: position_id per_all_positions.position_id%type,
1202: completed_crs_prereq varchar2(1),
1203: completed_comp_prereq varchar2(1),
1204: organization_id per_all_assignments_f.organization_id%type,
1205: assignment_id per_all_assignments_f.assignment_id%type

Line 1283: ,per_all_positions pps

1279: , paf.assignment_id
1280: FROM per_all_people_f ppf
1281: ,per_all_assignments_f paf
1282: ,per_jobs_tl pjt
1283: ,per_all_positions pps
1284: ,per_person_type_usages_f ptu
1285: ,per_person_types pts
1286: ,hr_all_organization_units_tl orgTl
1287: ,per_business_groups pbg

Line 1478: ,per_all_positions pps

1474: , paf.assignment_id assignment_id
1475: FROM per_all_people_f ppf
1476: ,per_all_assignments_f paf
1477: ,per_jobs_tl pjt
1478: ,per_all_positions pps
1479: ,per_person_type_usages_f ptu
1480: ,per_person_types pts
1481: ,per_person_types_tl ptt
1482: ,hr_all_organization_units_tl orgTl

Line 2401: position_id per_all_positions.position_id%type,

2397:
2398: TYPE learner_rec IS RECORD(
2399: person_id per_all_people_f.person_id%type,
2400: job_id per_jobs_tl.job_id%type,
2401: position_id per_all_positions.position_id%type,
2402: organization_id per_all_assignments_f.organization_id%type,
2403: assignment_id per_all_assignments_f.assignment_id%type
2404: );
2405: lrnr_rec learner_rec;

Line 2461: ,per_all_positions pps

2457: , paf.assignment_id
2458: FROM per_all_people_f ppf
2459: ,per_all_assignments_f paf
2460: ,per_jobs_tl pjt
2461: ,per_all_positions pps
2462: ,per_person_type_usages_f ptu
2463: ,per_person_types pts
2464: ,hr_all_organization_units_tl orgTl
2465: ,per_business_groups pbg

Line 2685: ,per_all_positions pps

2681: , paf.assignment_id assignment_id
2682: FROM per_all_people_f ppf
2683: ,per_all_assignments_f paf
2684: ,per_jobs_tl pjt
2685: ,per_all_positions pps
2686: ,per_person_type_usages_f ptu
2687: ,per_person_types pts
2688: ,per_person_types_tl ptt
2689: ,hr_all_organization_units_tl orgTl