APPS.IRC_APPROVALS dependencies on PER_ALL_ASSIGNMENTS_F

Line 1276: from per_all_assignments_f

1272: c_top_approver_id per_all_people_f.person_id%type default null;
1273:
1274: cursor csr_app(c_person_id per_people_f.person_id%TYPE) is
1275: select supervisor_id
1276: from per_all_assignments_f
1277: where person_id = c_person_id
1278: and primary_flag = 'Y'
1279: and trunc(sysdate)
1280: between effective_start_date

Line 1605: from per_all_assignments_f

1601: is
1602: vac_id per_all_vacancies.vacancy_id%type;
1603: cursor vac_id_from_assn_id (assn_id number) is
1604: select vacancy_id
1605: from per_all_assignments_f
1606: where assignment_id=assn_id;
1607: begin
1608:
1609: open vac_id_from_assn_id(assignment_id);