DBA Data[Home] [Help]

APPS.OTA_MANDATORY_ENROLL_UTIL dependencies on PER_ALL_POSITIONS

Line 376: position_id per_all_positions.position_id%type,

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,
380: assignment_id per_all_assignments_f.assignment_id%type

Line 404: ,per_all_positions pps

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
408: ,hr_all_organization_units_tl orgTl

Line 492: ,per_all_positions pps

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
496: ,hr_all_organization_units_tl orgTl