APPS.HR_MEE_VIEWS_GEN dependencies on PER_JOB_DEFINITIONS

Line 1390: per_job_definitions pjd

1386: pjd.segment28,
1387: pjd.segment29,
1388: pjd.segment30
1389: FROM per_jobs_vl pj,
1390: per_job_definitions pjd
1391: WHERE pj.job_definition_id = pjd.job_definition_id
1392: AND pj.job_id = p_job_id;
1393:
1394: lv_segment_name1 VARCHAR2(30) DEFAULT NULL;

Line 1405: --from per_job_definitions.

1401:
1402: BEGIN
1403:
1404: --First Get the name from per_jobs and all the segments
1405: --from per_job_definitions.
1406: --The name will be returned if no profiles are used.
1407: FOR segment_rec IN lc_get_job_details(p_job_id => p_job_id)
1408: LOOP
1409: ltt_segment(0).value := segment_rec.name;