APPS.IRC_PARTY_PERSON_UTL dependencies on IRC_VACANCY_CONSIDERATIONS
Line 87: from irc_vacancy_considerations
83: from irc_search_criteria
84: where object_type='WORK'
85: union
86: select party_id,person_id 87: from irc_vacancy_considerations 88: where party_id is not null
89: and person_id is null;
90:
91: cursor get_party_rec(p_party_id number) is
Line 607: update irc_vacancy_considerations
603: --
604: -- update the vacancy consideration records
605: --
606: 607: update irc_vacancy_considerations 608: set person_id=l_person_ids(i)
609: where party_id=l_party_ids(i)
610: and person_id is null;
611: