APPS.HR_MEE_VIEWS_GEN dependencies on PER_JOB_DEFINITIONS

Line 1433: per_job_definitions pjd

1429: pjd.segment28,
1430: pjd.segment29,
1431: pjd.segment30
1432: FROM per_jobs_vl pj,
1433: per_job_definitions pjd
1434: WHERE pj.job_definition_id = pjd.job_definition_id
1435: AND pj.job_id = p_job_id;
1436:
1437: lv_segment_name1 VARCHAR2(30) DEFAULT NULL;

Line 1448: --from per_job_definitions.

1444:
1445: BEGIN
1446:
1447: --First Get the name from per_jobs and all the segments
1448: --from per_job_definitions.
1449: --The name will be returned if no profiles are used.
1450: FOR segment_rec IN lc_get_job_details(p_job_id => p_job_id)
1451: LOOP
1452: ltt_segment(0).value := segment_rec.name;