APPS.HZ_IMP_LOAD_PARTY_SITE_USE_PKG dependencies on HZ_IMP_ADDRESSUSES_SG

Line 115: from hz_imp_addressuses_int int,hz_imp_addressuses_sg p_sg

111: P_DML_RECORD.SYSDATE,
112: 'Y','Y','Y','Y','Y', 'Y',
113: dup_val_exp_val,
114: other_exp_val
115: from hz_imp_addressuses_int int,hz_imp_addressuses_sg p_sg
116: where int.rowid = p_sg.int_row_id
117: and p_sg.action_flag = 'I'
118: and p_sg.batch_id = P_DML_RECORD.BATCH_ID
119: and int.party_orig_system = P_DML_RECORD.OS

Line 282: hz_imp_addressuses_sg pss,

278: pss.primary_flag,
279: nvl2(nullif(psi.created_by_module,:p_gmiss_char),nvl2(createdby_l.lookup_code,''Y'',null),''Y'') createdby_error
280:
281: from hz_imp_addressuses_int psi,
282: hz_imp_addressuses_sg pss,
283: fnd_lookup_values site_use_type_l,
284: hz_orig_sys_references mosr,
285: hz_orig_sys_references mosr_party,
286: hz_party_site_uses psu,