APPS.IRC_PARTY_PERSON_UTL dependencies on PER_PREVIOUS_EMPLOYERS

Line 53: from per_previous_employers

49: where party_id is not null
50: and parent_id is null
51: union
52: select party_id,person_id
53: from per_previous_employers
54: where party_id is not null
55: and person_id is null
56: union
57: select party_id,person_id

Line 492: update per_previous_employers

488: --
489: -- update the previous employers records directly for performance
490: --
491:
492: update per_previous_employers
493: set person_id=l_person_ids(i)
494: ,business_group_id=l_business_group_id
495: where party_id=l_party_ids(i)
496: and person_id is null;