eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_REQUISITIONS_PKG dependencies on PER_VACANCIES

Line 79: FROM PER_VACANCIES PV

75: P_Requisition_id NUMBER) IS
76:
77: CURSOR C_chk_date_from IS
78: SELECT 1
79: FROM PER_VACANCIES PV
80: WHERE P_Requisition_id = PV.REQUISITION_ID
81: AND PV.business_group_id + 0 = P_Business_group_id
82: AND P_Date_from > PV.DATE_FROM;
83:

Line 158: FROM PER_VACANCIES PV

154: P_Date_to DATE) IS
155:
156: CURSOR C_date_to_val IS
157: SELECT 1
158: FROM PER_VACANCIES PV
159: WHERE P_Requisition_id = PV.REQUISITION_ID
160: AND P_business_group_id + 0 = PV.BUSINESS_GROUP_ID
161: AND PV.DATE_TO IS NOT NULL
162: AND P_Date_to < PV.DATE_TO;

Line 192: FROM PER_VACANCIES PV,

188:
189:
190: CURSOR C_check_references IS
191: SELECT PR.NAME
192: FROM PER_VACANCIES PV,
193: PER_REQUISITIONS PR
194: WHERE PV.REQUISITION_ID = P_requisition_id
195: AND PR.REQUISITION_ID = P_requisition_id
196: AND PR.business_group_id + 0 = P_Business_group_id