DBA Data[Home] [Help]

APPS.PER_VACANCIES_PKG dependencies on PER_JOBS_V

Line 60: 26-Jun-00 C.Carter 115.6 Changed PER_JOBS to PER_JOBS_V.

56: message 6125.
57: 05-Oct-99 SCNair 115.4 Date Track position related changes
58: 12-Jun-00 hsajja 115.5 Changed HR_POSITIONS to HR_POSITIONS_F
59: and corresponding effective_date changes
60: 26-Jun-00 C.Carter 115.6 Changed PER_JOBS to PER_JOBS_V.
61: 07-SEP-01 A.Cowan 115.7-10 Cascade vacancy enhancement
62: bug # 1923803
63: 26-Jun-03 vanantha 115.12 Added a procedure D_to_updt_org_chk
64: to validate end date for Vacancy

Line 665: FROM PER_JOBS_V PJ

661: P_job_id NUMBER) IS
662:
663: CURSOR c_job_chk IS
664: SELECT 1
665: FROM PER_JOBS_V PJ
666: WHERE PJ.JOB_ID = P_job_id
667: AND PJ.business_group_id + 0 = P_business_group_id
668: AND P_vac_date_from < PJ.DATE_FROM;
669: