APPS.PER_VACANCIES_PKG dependencies on PER_ALL_ASSIGNMENTS

Line 88: PER_ALL_ASSIGNMENTS_F PAF

84: PROCEDURE Check_References(P_vacancy_id NUMBER ) is
85: CURSOR c_check_references1 IS
86: SELECT distinct(PV.NAME)
87: FROM PER_VACANCIES PV,
88: PER_ALL_ASSIGNMENTS_F PAF
89: WHERE PAF.VACANCY_ID = P_vacancy_id
90: AND PV.VACANCY_ID = P_vacancy_id
91: AND PAF.VACANCY_ID = PV.VACANCY_ID;
92:

Line 141: FROM PER_ALL_ASSIGNMENTS ASS,

137: P_vac_type VARCHAR2) return NUMBER IS
138:
139: CURSOR csr_counter IS
140: SELECT COUNT(distinct ass.assignment_id)
141: FROM PER_ALL_ASSIGNMENTS ASS,
142: PER_ASSIGNMENT_STATUS_TYPES a
143: where nvl(A.BUSINESS_GROUP_ID,P_Business_group_id) =
144: P_Business_group_id
145: and ass.business_group_id + 0 = P_Business_group_id

Line 177: FROM PER_ALL_ASSIGNMENTS A

173: ) return NUMBER IS
174:
175: CURSOR csr_hires IS
176: SELECT COUNT(*)
177: FROM PER_ALL_ASSIGNMENTS A
178: WHERE A.business_group_id + 0 = P_Business_group_id
179: AND A.VACANCY_ID = P_vacancy_id
180: AND A.ASSIGNMENT_TYPE = 'E';
181:

Line 208: FROM PER_ALL_ASSIGNMENTS A

204: ) return NUMBER IS
205:
206: CURSOR csr_current IS
207: SELECT COUNT(DISTINCT A.ASSIGNMENT_ID)
208: FROM PER_ALL_ASSIGNMENTS A
209: WHERE A.VACANCY_ID = P_vacancy_id
210: AND A.business_group_id + 0 = P_Business_group_id
211: AND A.ASSIGNMENT_TYPE = 'E'
212: AND A.EFFECTIVE_START_DATE <= P_session_date ;

Line 245: from per_all_assignments_f

241: is
242: cursor csr_appl_exists
243: is
244: select '1'
245: from per_all_assignments_f
246: where vacancy_id =P_vacancy_id
247: and effective_start_date < P_vac_date_from
248: and assignment_type = 'A';
249:

Line 1326: update per_all_assignments_f asg

1322: -- Details are only cascaded to the applicant assignments when the value
1323: -- is not null, except for position, which updates the value if the
1324: -- organization and job have changed regardless of whether it is null.
1325: --
1326: update per_all_assignments_f asg
1327: set asg.organization_id = nvl(x_organization_id, asg.organization_id)
1328: ,asg.job_id = nvl(x_job_id, asg.job_id)
1329: ,asg.grade_id = nvl(x_grade_id, asg.grade_id)
1330: ,asg.people_group_id = nvl(x_people_group_id, asg.people_group_id)