APPS.IRC_MDS_MIGRATION dependencies on PER_ADDRESSES
Line 78: per_addresses pad
74: select inp.PERSON_ID inp_person_id,
75: pad.town_or_city city,
76: pad.address_type addtype
77: from irc_notification_preferences inp, 78: per_addresses pad 79: where
80: inp.person_id = pad.person_id(+)
81: and pad.ADDRESS_TYPE(+) ='REC'
82: and inp.person_id between p_start_pkid