APPS.HZ_IMP_LOAD_SSM_MATCHING_PKG dependencies on HZ_ORG_CONTACT_ROLES

Line 2474: nvl(hz_conr.org_contact_role_id, hz_org_contact_roles_S.NextVal) conr_id,

2470: (
2471: select /*+ leading(conr_w_cid) use_nl(hz_conr) */
2472: sos, sosr,
2473: conr_w_cid.contact_id contact_id,
2474: nvl(hz_conr.org_contact_role_id, hz_org_contact_roles_S.NextVal) conr_id,
2475: conr_w_cid.int_row_id int_row_id,
2476: nvl2(hz_conr.org_contact_role_id, 'U', 'I') action_flag,
2477: decode(conr_w_cid.cont_action_flag,
2478: 'I', decode(conr_w_cid.sub_id, conr_w_cid.cont_sub_id, null, 2),

Line 2481: from hz_org_contact_roles hz_conr,

2477: decode(conr_w_cid.cont_action_flag,
2478: 'I', decode(conr_w_cid.sub_id, conr_w_cid.cont_sub_id, null, 2),
2479: null) error_flag,
2480: P_BATCH_MODE_FLAG, P_BATCH_ID
2481: from hz_org_contact_roles hz_conr,
2482: (
2483: select /*+ no_merge leading(conrole_int) index_asc(conrole_int)
2484: use_nl(cont_sg,con_mosr,party_mosr) use_hash(party_sg) */
2485: conrole_int.sub_orig_system sos,

Line 2543: nvl(hz_conr.org_contact_role_id, hz_org_contact_roles_S.NextVal) conr_id,

2539: (
2540: select /*+ leading(conr_w_cid) use_nl(hz_conr) */
2541: sos, sosr,
2542: conr_w_cid.contact_id contact_id,
2543: nvl(hz_conr.org_contact_role_id, hz_org_contact_roles_S.NextVal) conr_id,
2544: conr_w_cid.int_row_id int_row_id,
2545: nvl2(hz_conr.org_contact_role_id, 'U', 'I') action_flag,
2546: decode(conr_w_cid.cont_action_flag,
2547: 'I', decode(conr_w_cid.sub_id, conr_w_cid.cont_sub_id, null, 2),

Line 2550: from hz_org_contact_roles hz_conr,

2546: decode(conr_w_cid.cont_action_flag,
2547: 'I', decode(conr_w_cid.sub_id, conr_w_cid.cont_sub_id, null, 2),
2548: null) error_flag,
2549: P_BATCH_MODE_FLAG, P_BATCH_ID
2550: from hz_org_contact_roles hz_conr,
2551: (
2552: select /*+ no_merge leading(conrole_int) index_asc(conrole_int)
2553: use_nl(cont_sg,con_mosr,party_mosr) use_hash(party_sg) */
2554: conrole_int.sub_orig_system sos,