DBA Data[Home] [Help]

APPS.IRC_PARTY_PERSON_UTL dependencies on PER_ADDRESSES

Line 43: from per_addresses

39: select party_id,person_id
40: from irc_notification_preferences
41: union
42: select party_id,person_id
43: from per_addresses
44: where party_id is not null
45: and person_id is null
46: union
47: select party_id,parent_id person_id

Line 482: update per_addresses

478: --
479: -- update the address records directly for performance
480: --
481:
482: update per_addresses
483: set person_id=l_person_ids(i)
484: ,business_group_id=l_business_group_id
485: where party_id=l_party_ids(i)
486: and person_id is null