DBA Data[Home] [Help]

APPS.HZ_IMP_LOAD_CONTACT_ROLE_PKG dependencies on HZ_IMP_CONTACTROLES_SG

Line 122: from hz_imp_contactroles_int int,hz_imp_contactroles_sg p_sg

118: 'Y',
119: 'Y',
120: dup_val_exp_val,
121: other_exp_val
122: from hz_imp_contactroles_int int,hz_imp_contactroles_sg p_sg
123: where int.rowid = p_sg.int_row_id
124: and p_sg.action_flag = 'I'
125: and p_sg.batch_id = P_DML_RECORD.BATCH_ID
126: and int.sub_orig_system = P_DML_RECORD.OS

Line 292: hz_imp_contactroles_sg crs,

288: nvl2(nullif(mosr.orig_system_reference,cri.contact_orig_system_reference),null,''Y'') controle_osr_mismatch_err,
289: nvl2(nullif(cri.created_by_module,:p_gmiss_char),createdby_l.lookup_code,''Y'') createdby_error
290:
291: from hz_imp_contactroles_int cri,
292: hz_imp_contactroles_sg crs,
293: hz_orig_sys_references mosr,
294: --hz_orig_sys_references mosr_party,
295: hz_org_contacts org_cont,
296: --hz_relationships rel,