APPS.HZ_IMP_LOAD_ORG_CONTACT_PKG dependencies on HZ_IMP_CONTACTS_SG

Line 542: from hz_imp_contacts_sg cnt_sg, hz_imp_contacts_int cnt_int

538: 'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y',
539: 'Y',
540: dup_val_exp_val,
541: other_exp_val
542: from hz_imp_contacts_sg cnt_sg, hz_imp_contacts_int cnt_int
543: where cnt_sg.action_flag = 'I'
544: and cnt_int.rowid = cnt_sg.int_row_id
545: and cnt_int.batch_id = P_DML_RECORD.BATCH_ID
546: and cnt_int.sub_orig_system = P_DML_RECORD.OS

Line 1156: from hz_imp_contacts_sg ocsg,

1152: ocint.interface_status,
1153: decode(tc.a, 0, ''Y'') dup_rel_error,
1154: nvl2(nullif(ocint.created_by_module, :p_gmiss_char), nvl2(createdby_l.lookup_code, ''Y'', null), ''Y'') createdby_error
1155:
1156: from hz_imp_contacts_sg ocsg,
1157: hz_imp_contacts_int ocint,
1158: (select 0 a from dual union all select 1 a from dual) tc,
1159: hz_parties sp,
1160: hz_parties op,

Line 1559: HZ_IMP_CONTACTS_SG cs,

1555: and rownum = 1
1556: ) identical_rel
1557: */
1558: FROM HZ_IMP_CONTACTS_INT ci,
1559: HZ_IMP_CONTACTS_SG cs,
1560: HZ_RELATIONSHIPS r,
1561: HZ_ORG_CONTACTS oc,
1562: AR_LOOKUPS dept_l,
1563: AR_LOOKUPS title_l,