APPS.HR_SUIT_MATCH_UTILITY_WEB dependencies on PER_JOBS

Line 758: ||' FROM per_jobs_vl pj, per_job_definitions pjd'

754: ,p_where_clause => l_flex_where_clause);
755:
756: l_dynamic_sql := 'SELECT pj.job_id,'
757: ||l_flex_select_clause
758: ||' FROM per_jobs_vl pj, per_job_definitions pjd'
759: ||' WHERE pj.job_definition_id = pjd.job_definition_id'
760: ||' AND pj.job_id IN ('
761: ||p_ids
762: ||')';

Line 1026: ||' ,per_jobs_vl pj'

1022: ||','|| l_job_flex_select_clause
1023: ||' FROM per_assignments_f paf'
1024: ||' ,per_people_f ppf'
1025: ||' ,per_person_type_usages_f ptu'
1026: ||' ,per_jobs_vl pj'
1027: ||' ,per_job_definitions pjd'
1028: ||' WHERE paf.business_group_id = '
1029: ||l_business_group
1030: ||' AND paf.assignment_type = '||l_assignment_type

Line 1229: ||' FROM per_jobs_vl'

1225: END IF;
1226: END IF;
1227: ELSIF p_search_type = g_job_type THEN --job
1228: l_dynamic_sql := 'SELECT job_id, name'
1229: ||' FROM per_jobs_vl'
1230: ||' WHERE business_group_id = '
1231: ||l_business_group
1232: ||' AND TRUNC(sysdate) BETWEEN date_from AND'
1233: ||' NVL(date_to,TRUNC(sysdate))'

Line 1971: l_job_id per_jobs.job_id%TYPE;

1967: ,p_essential_count out nocopy number
1968: ,p_desirable_count out nocopy number) IS
1969:
1970: l_org_id hr_organization_units.organization_id%TYPE;
1971: l_job_id per_jobs.job_id%TYPE;
1972:
1973: l_core_competence_table g_competence_table;
1974: l_core_count number;
1975: l_core_e_count number;

Line 2807: per_jobs_vl pj

2803: CURSOR csr_deployment_by_person IS
2804: SELECT pasf.assignment_id, pasf.job_id, pasf.grade_id, pj.name
2805: FROM per_assignments_f pasf,
2806: per_assignment_status_types past,
2807: per_jobs_vl pj
2808: WHERE pasf.person_id = p_person_id
2809: AND p_effective_date BETWEEN pasf.effective_start_date
2810: AND pasf.effective_end_date
2811: AND pasf.job_id = pj.job_id