APPS.HZ_IMP_LOAD_SSM_MATCHING_PKG dependencies on HZ_IMP_ADDRESSES_INT

Line 390: from hz_imp_addresses_int ps_int,

386: nvl2(ps_int.party_id,'U',nvl(psg.action_flag, 'U')) party_action_flag,
387: osr_change_tbl.new_osr_exists_flag psg_new_osr_flag,
388: ps_int.primary_flag primary_flag,
389: nvl2(nullif(ps_int.party_id,mosr.owner_table_id),'Y',null) owning_pty_chg_flag
390: from hz_imp_addresses_int ps_int,
391: hz_imp_parties_sg psg,
392: hz_orig_sys_references mosr,
393: hz_imp_osr_change osr_change_tbl
394: where mosr.owner_table_name (+) = 'HZ_PARTIES'

Line 520: from hz_imp_addresses_int ps_int,

516: nvl2(ps_int.party_id,'U',nvl(psg.action_flag, 'U')) party_action_flag,
517: osr_change_tbl.new_osr_exists_flag psg_new_osr_flag,
518: ps_int.primary_flag primary_flag,
519: nvl2(nullif(ps_int.party_id,mosr.owner_table_id),'Y',null) owning_pty_chg_flag
520: from hz_imp_addresses_int ps_int,
521: hz_imp_parties_sg psg,
522: hz_orig_sys_references mosr,
523: hz_imp_osr_change osr_change_tbl
524: where mosr.owner_table_name (+) = 'HZ_PARTIES'