APPS.HZ_IMP_LOAD_SSM_MATCHING_PKG dependencies on HZ_PARTY_SITE_USES_S

Line 2658: nvl(hz_psuse.party_site_use_id, hz_party_site_uses_s.nextval)

2654: )
2655: (
2656: select /*+ leading(addruse_w_id) use_nl(hz_psuse) */
2657: addruse_w_id.site_use_type, pos, posr,
2658: nvl(hz_psuse.party_site_use_id, hz_party_site_uses_s.nextval)
2659: siteusr_id, addruse_w_id.site_id, addruse_w_id.int_row_id,
2660: nvl2(hz_psuse.party_site_use_id, 'U', 'I') action_flag,
2661: decode(addruse_w_id.addr_action_flag, 'I', decode(
2662: addruse_w_id.party_id, addruse_w_id.addr_party_id, null, 2), null)

Line 2739: nvl(hz_psuse.party_site_use_id, hz_party_site_uses_s.nextval)

2735: )
2736: (
2737: select /*+ leading(addruse_w_id) use_nl(hz_psuse) */
2738: addruse_w_id.site_use_type, pos, posr,
2739: nvl(hz_psuse.party_site_use_id, hz_party_site_uses_s.nextval)
2740: siteusr_id, addruse_w_id.site_id, addruse_w_id.int_row_id,
2741: nvl2(hz_psuse.party_site_use_id, 'U', 'I') action_flag,
2742: decode(addruse_w_id.addr_action_flag, 'I', decode(
2743: addruse_w_id.party_id, addruse_w_id.addr_party_id, null, 2), null)