DBA Data[Home] [Help]

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: