APPS.HZ_IMP_LOAD_SSM_MATCHING_PKG dependencies on HZ_IMP_CONTACTPTS_INT

Line 631: from hz_imp_contactpts_int cp_int,

627: nvl2(cp_int.party_id,'U',nvl(psg.action_flag, 'U')) party_action_flag,
628: party_osr_ch_tbl.new_osr_exists_flag, cp_int.primary_flag,
629: cp_int.batch_id, cp_int.contact_point_type,
630: nvl2(nullif(cp_int.party_id,mosr.owner_table_id),'Y',null) owning_pty_chg_flag
631: from hz_imp_contactpts_int cp_int,
632: hz_imp_parties_sg psg,
633: hz_orig_sys_references mosr,
634: hz_imp_osr_change party_osr_ch_tbl
635: where cp_int.interface_status = 'C'

Line 742: from hz_imp_contactpts_int cp_int,

738: nvl2(cp_int.party_id,'U',nvl(psg.action_flag, 'U')) party_action_flag,
739: party_osr_ch_tbl.new_osr_exists_flag, cp_int.primary_flag,
740: cp_int.batch_id, cp_int.contact_point_type,
741: nvl2(nullif(cp_int.party_id,mosr.owner_table_id),'Y',null) owning_pty_chg_flag
742: from hz_imp_contactpts_int cp_int,
743: hz_imp_parties_sg psg,
744: hz_orig_sys_references mosr,
745: hz_imp_osr_change party_osr_ch_tbl
746: where cp_int.interface_status is null