APPS.PER_VACANCIES_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 78: per_all_assignments_f in per_vacancies_pkg.update_row

74: for bug 6497289
75: 24-Feb-09 lbodired 115.19 Modified the procedure UPDATE_ROW
76: for the bug 7592739
77: 01-Jun-09 sidsaxen 115.23 bug 8518955, handled NULL while updating
78: per_all_assignments_f in per_vacancies_pkg.update_row
79: 08-APR-10 karthmoh 120.3.12010000.9 Modified/Added Procedures for ER#8530112
80: ============================================================================*/
81: ----------------------------------------------------------------------------
82: --

Line 96: PER_ALL_ASSIGNMENTS_F PAF

92: PROCEDURE Check_References(P_vacancy_id NUMBER ) is
93: CURSOR c_check_references1 IS
94: SELECT distinct(PV.NAME)
95: FROM PER_VACANCIES PV,
96: PER_ALL_ASSIGNMENTS_F PAF
97: WHERE PAF.VACANCY_ID = P_vacancy_id
98: AND PV.VACANCY_ID = P_vacancy_id
99: AND PAF.VACANCY_ID = PV.VACANCY_ID;
100:

Line 253: from per_all_assignments_f

249: is
250: cursor csr_appl_exists
251: is
252: select '1'
253: from per_all_assignments_f
254: where vacancy_id =P_vacancy_id
255: and effective_start_date < P_vac_date_from
256: and assignment_type = 'A';
257:

Line 1344: update per_all_assignments_f asg

1340: -- organization and job have changed regardless of whether it is null.
1341: --
1342:
1343: -- Start changes for bug 8518955
1344: update per_all_assignments_f asg
1345: set asg.organization_id = nvl(x_organization_id, asg.organization_id)
1346: ,asg.job_id = x_job_id
1347: ,asg.grade_id = x_grade_id
1348: ,asg.people_group_id = x_people_group_id

Line 1364: from per_all_assignments_f f2

1360: nvl(x_position_id, asg.position_id),
1361: x_position_id)*/
1362: where asg.assignment_type = 'A'
1363: and exists ( select 1
1364: from per_all_assignments_f f2
1365: where asg.assignment_id = f2.assignment_id
1366: and f2.effective_end_date = l_end_of_time )
1367: and not exists ( select 1
1368: from per_all_assignments_f f2

Line 1368: from per_all_assignments_f f2

1364: from per_all_assignments_f f2
1365: where asg.assignment_id = f2.assignment_id
1366: and f2.effective_end_date = l_end_of_time )
1367: and not exists ( select 1
1368: from per_all_assignments_f f2
1369: where asg.assignment_id = f2.assignment_id
1370: and f2.assignment_status_type_id in ( select assignment_status_type_id
1371: from per_assignment_status_types
1372: where per_system_status in ('ACCEPTED')))

Line 1667: from per_assignment_budget_values_f abv, per_all_assignments_f asn,

1663: p_effective_date in date) return number is
1664: l_assignment_hc number;
1665: CURSOR c_budgeted_hc(p_position_id number) is
1666: select sum(nvl(value,1))
1667: from per_assignment_budget_values_f abv, per_all_assignments_f asn,
1668: per_assignment_status_types ast
1669: where abv.assignment_id(+) = asn.assignment_id
1670: and p_effective_date between asn.effective_start_date and asn.effective_end_date
1671: and p_effective_date between abv.effective_start_date and abv.effective_end_date