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 519: from hz_imp_addresses_int ps_int,

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