DBA Data[Home] [Help]

APPS.OTA_MANDATORY_ENROLL_UTIL dependencies on PER_JOBS_TL

Line 375: job_id per_jobs_tl.job_id%type,

371: csr_get_lrnr_in_ug learners_in_usergroup;
372:
373: TYPE learner_rec IS RECORD(
374: person_id per_all_people_f.person_id%type,
375: job_id per_jobs_tl.job_id%type,
376: position_id per_all_positions.position_id%type,
377: completed_crs_prereq varchar2(1),
378: completed_comp_prereq varchar2(1),
379: organization_id per_all_assignments_f.organization_id%type,

Line 403: ,per_jobs_tl pjt

399: , paf.organization_id
400: , paf.assignment_id
401: FROM per_all_people_f ppf
402: ,per_all_assignments_f paf
403: ,per_jobs_tl pjt
404: ,per_all_positions pps
405: ,per_person_type_usages_f ptu
406: ,per_person_types pts
407: ,per_person_types_tl ptt

Line 491: ,per_jobs_tl pjt

487: , paf.organization_id organization_id
488: , paf.assignment_id assignment_id
489: FROM per_all_people_f ppf
490: ,per_all_assignments_f paf
491: ,per_jobs_tl pjt
492: ,per_all_positions pps
493: ,per_person_type_usages_f ptu
494: ,per_person_types pts
495: ,per_person_types_tl ptt