APPS.PER_DB_PER_ADDITIONAL dependencies on PER_JOBS_V

Line 80: 115.5 26-JUN-00 CCarter Changed per_jobs to per_jobs_v for

76: for release 11.5 compliancy.
77: 115.3 22-APR-99 ALogue Canonical number support for
78: normal_hours in insert_assignment.
79: 115.4 24-AUG-99 JPBard Remove work_telephone from insert list
80: 115.5 26-JUN-00 CCarter Changed per_jobs to per_jobs_v for
81: Job Groups.
82: 115.11 15-SEP-00 GPERRY Leapfrog of 115.9 with fix for
83: WWBUG 1390173.
84: 115.12 19-OCT-00 GPERRY Fixed WWBUG 1408379.

Line 1025: FROM per_jobs_v

1021: if p_job IS NULL then null;
1022: else hr_utility.set_location('per_db_per_additional.create_applicant',20);
1023: SELECT job_id
1024: INTO l_job_id
1025: FROM per_jobs_v
1026: WHERE name = p_job
1027: AND business_group_id + 0 = l_business_group_id
1028: AND l_effective_start_date BETWEEN date_from
1029: AND nvl(date_to,to_date('4712/12/31',

Line 1423: FROM per_jobs_v

1419: if p_job IS NULL then null;
1420: else hr_utility.set_location('per_db_per_additional.create_employee',24);
1421: SELECT job_id
1422: INTO l_job_id
1423: FROM per_jobs_v
1424: WHERE name = p_job
1425: AND business_group_id + 0 = l_business_group_id
1426: AND l_effective_start_date BETWEEN date_from
1427: AND nvl(date_to,to_date('4712/12/31',

Line 1847: FROM per_jobs_v

1843: else
1844: hr_utility.set_location('per_db_per_additional.create_secondary_assign',19);
1845: SELECT job_id
1846: INTO l_job_id
1847: FROM per_jobs_v
1848: WHERE name = p_job
1849: AND business_group_id + 0 = l_business_group_id
1850: AND l_effective_start_date BETWEEN date_from
1851: AND nvl(date_to,to_date('4712/12/31',

Line 1988: FROM per_jobs_v

1984: else
1985: hr_utility.set_location('per_db_per_additional.create_secondary_assign',48);
1986: SELECT job_id
1987: INTO l_job_id
1988: FROM per_jobs_v
1989: WHERE name = p_job
1990: AND business_group_id + 0 = l_business_group_id
1991: AND l_effective_start_date BETWEEN date_from
1992: AND nvl(date_to,to_date('4712/12/31',