APPS.IRC_IOF_BUS dependencies on PER_ALL_ASSIGNMENTS_F

Line 465: from per_all_assignments_f

461: l_applicant_assignment_id number;
462: --
463: cursor csr_applicant_assignment_id is
464: select 1
465: from per_all_assignments_f
466: where assignment_id = p_applicant_assignment_id
467: and assignment_type = 'A'
468: and p_effective_date
469: between effective_start_date

Line 544: from per_all_assignments_f

540: l_offer_assignment_exists number;
541: --
542: cursor csr_offer_assignment_id is
543: select 1
544: from per_all_assignments_f
545: where assignment_id = p_offer_assignment_id
546: and assignment_type = 'O';
547: --
548: cursor csr_offer_assigment_exists is

Line 644: from per_all_assignments_f paaf

640: l_vacancy_id irc_offers.vacancy_id%TYPE;
641: --
642: cursor csr_appl_vac_id is
643: select paaf.vacancy_id
644: from per_all_assignments_f paaf
645: where paaf.assignment_id = p_applicant_assignment_id
646: and p_effective_date
647: between effective_start_date
648: and effective_end_date;

Line 1180: ,per_all_assignments_f asg

1176: --
1177: cursor csr_rec_address_id is
1178: select adr.address_id
1179: from per_addresses adr
1180: ,per_all_assignments_f asg
1181: where asg.assignment_id = p_applicant_assignment_id
1182: and adr.person_id = irc_utilities_pkg.get_recruitment_person_id(asg.person_id,trunc(sysdate))
1183: and adr.address_type = 'REC'
1184: and p_effective_date

Line 1379: ,per_all_assignments_f ppaf

1375: --
1376: cursor csr_default_template_job is
1377: select ita.template_id
1378: from irc_template_associations ita
1379: ,per_all_assignments_f ppaf
1380: ,irc_offers iof
1381: where ita.default_association = 'Y'
1382: and iof.offer_id = p_offer_id
1383: and iof.offer_assignment_id = ppaf.assignment_id

Line 1389: ,per_all_assignments_f ppaf

1385: --
1386: cursor csr_default_template_pos is
1387: select ita.template_id
1388: from irc_template_associations ita
1389: ,per_all_assignments_f ppaf
1390: ,irc_offers iof
1391: where ita.default_association = 'Y'
1392: and iof.offer_id = p_offer_id
1393: and iof.offer_assignment_id = ppaf.assignment_id

Line 1399: ,per_all_assignments_f ppaf

1395: --
1396: cursor csr_default_template_org is
1397: select ita.template_id
1398: from irc_template_associations ita
1399: ,per_all_assignments_f ppaf
1400: ,irc_offers iof
1401: where ita.default_association = 'Y'
1402: and iof.offer_id = p_offer_id
1403: and iof.offer_assignment_id = ppaf.assignment_id