[Home] [Help]
15: SELECT
16: vac.VACANCY_ID,paaf.person_id,paaf.assignment_id,
17: PIL.PER_IN_LER_ID, PAAF.BUSINESS_GROUP_ID
18: FROM
19: PER_ALL_VACANCIES vac, per_all_assignments_f paaf,
20: BEN_PER_IN_LER pil, ben_ler_f ler
21: WHERE
22: vac.BUSINESS_GROUP_ID = pBGId and
23: paaf.BUSINESS_GROUP_ID = vac.BUSINESS_GROUP_ID and
45: SELECT
46: paaf.person_id, paaf.assignment_id, PIL.PER_IN_LER_ID,
47: PAAF.BUSINESS_GROUP_ID
48: FROM
49: per_all_assignments_f paaf,BEN_PER_IN_LER pil, ben_ler_f ler
50: WHERE
51: pil.BUSINESS_GROUP_ID = paaf.BUSINESS_GROUP_ID and
52: ler.BUSINESS_GROUP_ID = paaf.BUSINESS_GROUP_ID and
53: paaf.vacancy_id = pVacancyId and
192: l_decline_reason irc_offer_status_history.decline_reason%TYPE;
193: cursor csr_offer_status is
194: select * from(
195: select ofrhis.offer_status, ofrhis.change_reason, ofrhis.decline_reason
196: from irc_offer_status_history ofrhis, irc_offers ofr, per_all_assignments_f paaf
197: where paaf.assignment_id = pAssignmentId and ofr.applicant_assignment_id = paaf.assignment_id
198: and ofrhis.offer_id = ofr.offer_id and ofr.latest_offer='Y'
199: and sysdate between paaf.effective_start_date and paaf.effective_end_date order by status_change_date desc)
200: where rownum<2;
506: l_business_group_id NUMBER;
507: l_description varchar2(500);
508: cursor csr_assignment is
509: select PAAF.assignment_id,PAAF.BUSINESS_GROUP_ID,PIL.PER_IN_LER_ID
510: from per_all_assignments_f PAAF, BEN_PER_IN_LER pil, ben_ler_f ler
511: where PAAF.person_id = pPersonId and PAAF.assignment_type='E' and
512: paaf.primary_flag='Y' and
513: pil.BUSINESS_GROUP_ID = paaf.BUSINESS_GROUP_ID and
514: ler.BUSINESS_GROUP_ID = paaf.BUSINESS_GROUP_ID and