APPS.OTA_MANDATORY_ENROLL_UTIL dependencies on PER_JOBS_TL

Line 817: job_id per_jobs_tl.job_id%type,

813: csr_get_lrnr_in_ug learners_in_usergroup;
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,

Line 899: ,per_jobs_tl pjt

895: , paf.organization_id
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

Line 1022: ,per_jobs_tl pjt

1018: , paf.organization_id organization_id
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

Line 1200: job_id per_jobs_tl.job_id%type,

1196: csr_get_lrnr_in_ug learners_in_usergroup;
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,

Line 1282: ,per_jobs_tl pjt

1278: , paf.organization_id
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

Line 1477: ,per_jobs_tl pjt

1473: , paf.organization_id organization_id
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

Line 2400: job_id per_jobs_tl.job_id%type,

2396: csr_get_lrnr_in_ug learners_in_usergroup;
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: );

Line 2460: ,per_jobs_tl pjt

2456: , paf.organization_id
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

Line 2684: ,per_jobs_tl pjt

2680: , paf.organization_id organization_id
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