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 1207: ,per_all_assignments_f asg

1203: --
1204: cursor csr_rec_address_id is
1205: select adr.address_id
1206: from per_addresses adr
1207: ,per_all_assignments_f asg
1208: where asg.assignment_id = p_applicant_assignment_id
1209: and adr.person_id = irc_utilities_pkg.get_recruitment_person_id(asg.person_id,trunc(sysdate))
1210: and adr.address_type = 'REC'
1211: and p_effective_date

Line 1406: ,per_all_assignments_f ppaf

1402: --
1403: cursor csr_default_template_job is
1404: select ita.template_id
1405: from irc_template_associations ita
1406: ,per_all_assignments_f ppaf
1407: ,irc_offers iof
1408: where ita.default_association = 'Y'
1409: and iof.offer_id = p_offer_id
1410: and iof.offer_assignment_id = ppaf.assignment_id

Line 1416: ,per_all_assignments_f ppaf

1412: --
1413: cursor csr_default_template_pos is
1414: select ita.template_id
1415: from irc_template_associations ita
1416: ,per_all_assignments_f ppaf
1417: ,irc_offers iof
1418: where ita.default_association = 'Y'
1419: and iof.offer_id = p_offer_id
1420: and iof.offer_assignment_id = ppaf.assignment_id

Line 1426: ,per_all_assignments_f ppaf

1422: --
1423: cursor csr_default_template_org is
1424: select ita.template_id
1425: from irc_template_associations ita
1426: ,per_all_assignments_f ppaf
1427: ,irc_offers iof
1428: where ita.default_association = 'Y'
1429: and iof.offer_id = p_offer_id
1430: and iof.offer_assignment_id = ppaf.assignment_id