APPS.HZ_IMP_LOAD_SSM_MATCHING_PKG dependencies on HZ_ORG_CONTACT_ROLES

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

2500: (
2501: select /*+ leading(conr_w_cid) use_nl(hz_conr) */
2502: sos, sosr,
2503: conr_w_cid.contact_id contact_id,
2504: nvl(hz_conr.org_contact_role_id, hz_org_contact_roles_S.NextVal) conr_id,
2505: conr_w_cid.int_row_id int_row_id,
2506: nvl2(hz_conr.org_contact_role_id, 'U', 'I') action_flag,
2507: decode(conr_w_cid.cont_action_flag,
2508: 'I', decode(conr_w_cid.sub_id, conr_w_cid.cont_sub_id, null, 2),

Line 2511: from hz_org_contact_roles hz_conr,

2507: decode(conr_w_cid.cont_action_flag,
2508: 'I', decode(conr_w_cid.sub_id, conr_w_cid.cont_sub_id, null, 2),
2509: null) error_flag,
2510: P_BATCH_MODE_FLAG, P_BATCH_ID
2511: from hz_org_contact_roles hz_conr,
2512: (
2513: select /*+ no_merge leading(conrole_int) index_asc(conrole_int)
2514: use_nl(cont_sg,con_mosr,party_mosr) use_hash(party_sg) */
2515: conrole_int.sub_orig_system sos,

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

2569: (
2570: select /*+ leading(conr_w_cid) use_nl(hz_conr) */
2571: sos, sosr,
2572: conr_w_cid.contact_id contact_id,
2573: nvl(hz_conr.org_contact_role_id, hz_org_contact_roles_S.NextVal) conr_id,
2574: conr_w_cid.int_row_id int_row_id,
2575: nvl2(hz_conr.org_contact_role_id, 'U', 'I') action_flag,
2576: decode(conr_w_cid.cont_action_flag,
2577: 'I', decode(conr_w_cid.sub_id, conr_w_cid.cont_sub_id, null, 2),

Line 2580: from hz_org_contact_roles hz_conr,

2576: decode(conr_w_cid.cont_action_flag,
2577: 'I', decode(conr_w_cid.sub_id, conr_w_cid.cont_sub_id, null, 2),
2578: null) error_flag,
2579: P_BATCH_MODE_FLAG, P_BATCH_ID
2580: from hz_org_contact_roles hz_conr,
2581: (
2582: select /*+ no_merge leading(conrole_int) index_asc(conrole_int)
2583: use_nl(cont_sg,con_mosr,party_mosr) use_hash(party_sg) */
2584: conrole_int.sub_orig_system sos,