APPS.PER_IREC_ICD_ENRLL_PROCESS dependencies on PER_ALL_ASSIGNMENTS_F

Line 23: PER_VACANCIES vac, per_all_assignments_f paaf,

19: SELECT
20: vac.VACANCY_ID,paaf.person_id,paaf.assignment_id,
21: PIL.PER_IN_LER_ID, PAAF.BUSINESS_GROUP_ID
22: FROM
23: PER_VACANCIES vac, per_all_assignments_f paaf,
24: BEN_PER_IN_LER pil, ben_ler_f ler
25: WHERE
26: vac.BUSINESS_GROUP_ID = pBGId and
27: paaf.BUSINESS_GROUP_ID = vac.BUSINESS_GROUP_ID and

Line 49: per_all_assignments_f paaf,

45: SELECT
46: pav.vacancy_id,paaf.person_id,paaf.assignment_id,
47: PIL.PER_IN_LER_ID, PAAF.BUSINESS_GROUP_ID
48: FROM
49: per_all_assignments_f paaf,
50: BEN_PER_IN_LER pil, ben_ler_f ler,
51: per_all_vacancies pav,
52: per_vac_linked_assignments pvla
53: WHERE

Line 83: per_all_assignments_f paaf,BEN_PER_IN_LER pil, ben_ler_f ler

79: SELECT
80: paaf.person_id, paaf.assignment_id, PIL.PER_IN_LER_ID,
81: PAAF.BUSINESS_GROUP_ID
82: FROM
83: per_all_assignments_f paaf,BEN_PER_IN_LER pil, ben_ler_f ler
84: WHERE
85: pil.BUSINESS_GROUP_ID = paaf.BUSINESS_GROUP_ID and
86: ler.BUSINESS_GROUP_ID = paaf.BUSINESS_GROUP_ID and
87: pVacancyId = nvl(paaf.vacancy_id,

Line 120: from PER_ALL_ASSIGNMENTS_F

116: l_hire_date DATE;
117: --
118: cursor c_hire_date is
119: select min(EFFECTIVE_START_DATE)
120: from PER_ALL_ASSIGNMENTS_F
121: where ASSIGNMENT_ID = p_assignment_id
122: and ASSIGNMENT_TYPE = 'E'
123: and PRIMARY_FLAG = 'Y';
124: --

Line 240: from irc_offer_status_history ofrhis, irc_offers ofr, per_all_assignments_f paaf

236: l_decline_reason irc_offer_status_history.decline_reason%TYPE;
237: cursor csr_offer_status is
238: select * from(
239: select ofrhis.offer_status, ofrhis.change_reason, ofrhis.decline_reason
240: from irc_offer_status_history ofrhis, irc_offers ofr, per_all_assignments_f paaf
241: where paaf.assignment_id = pAssignmentId and ofr.applicant_assignment_id = paaf.assignment_id
242: and ofrhis.offer_id = ofr.offer_id and ofr.latest_offer='Y'
243: and sysdate between paaf.effective_start_date and paaf.effective_end_date order by status_change_date desc)
244: where rownum<2;

Line 557: from per_all_assignments_f PAAF, BEN_PER_IN_LER pil, ben_ler_f ler

553: l_business_group_id NUMBER;
554: l_description varchar2(500);
555: cursor csr_assignment is
556: select PAAF.assignment_id,PAAF.BUSINESS_GROUP_ID,PIL.PER_IN_LER_ID
557: from per_all_assignments_f PAAF, BEN_PER_IN_LER pil, ben_ler_f ler
558: where PAAF.person_id = pPersonId and PAAF.assignment_type='E' and
559: paaf.primary_flag='Y' and
560: pil.BUSINESS_GROUP_ID = paaf.BUSINESS_GROUP_ID and
561: ler.BUSINESS_GROUP_ID = paaf.BUSINESS_GROUP_ID and