APPS.HZ_IMP_LOAD_SSM_MATCHING_PKG dependencies on HZ_PARTY_SITES_S

Line 321: nvl(party_site_id, hz_party_sites_s.nextval),

317: (
318: pid, pos, posr,
319: psos, psosr,
320: int_row_id, action_flag,
321: nvl(party_site_id, hz_party_sites_s.nextval),
322: error_flag, party_action_flag,
323: old_psosr, overwrite_osr_flag,
324: P_BATCH_ID, P_BATCH_MODE_FLAG,
325: primary_flag

Line 343: nvl(party_site_id, hz_party_sites_s.nextval),

339: ( 'HZ_PARTY_SITES',
340: overwrite_osr_flag,
341: old_psosr,
342: psosr,
343: nvl(party_site_id, hz_party_sites_s.nextval),
344: P_BATCH_ID, pid
345: )
346: select /*+ leading(ps_int_w_psosr) use_nl(psosr_mosr,hz_ps) index(hz_ps, hz_party_sites_n4) */
347: ps_int_w_psosr.pid, ps_int_w_psosr.pos, ps_int_w_psosr.posr,

Line 352: --nvl(psosr_mosr.owner_table_id, hz_party_sites_s.nextval) party_site_id,

348: ps_int_w_psosr.psos, ps_int_w_psosr.psosr,
349: ps_int_w_psosr.int_row_id,
350: nvl2(psosr_mosr.owner_table_id,decode(ps_int_w_psosr.owning_pty_chg_flag,'Y','I','U'),'I') action_flag,
351: nvl2(ps_int_w_psosr.owning_pty_chg_flag,null,psosr_mosr.owner_table_id) party_site_id,
352: --nvl(psosr_mosr.owner_table_id, hz_party_sites_s.nextval) party_site_id,
353: --psosr_mosr.owner_table_id party_site_id, -- Bug6082657
354: DECODE (ps_int_w_psosr.ps_int_pid, NULL, nvl2(nullif(psosr_mosr.party_id, ps_int_w_psosr.pid), 2, null),
355: NVL2(p.party_id, NULL, 3) ) error_flag,
356: ps_int_w_psosr.party_action_flag,

Line 451: nvl(party_site_id, hz_party_sites_s.nextval),

447: (
448: pid, pos, posr,
449: psos, psosr,
450: int_row_id, action_flag,
451: nvl(party_site_id, hz_party_sites_s.nextval),
452: error_flag, party_action_flag,
453: old_psosr, overwrite_osr_flag,
454: P_BATCH_ID, P_BATCH_MODE_FLAG,
455: primary_flag

Line 472: nvl(party_site_id, hz_party_sites_s.nextval),

468: ( 'HZ_PARTY_SITES',
469: overwrite_osr_flag,
470: old_psosr,
471: psosr,
472: nvl(party_site_id, hz_party_sites_s.nextval),
473: P_BATCH_ID, pid
474: )
475: select /*+ leading(ps_int_w_psosr) use_nl(psosr_mosr,hz_ps) index(hz_ps, hz_party_sites_n4) */
476: ps_int_w_psosr.pid, ps_int_w_psosr.pos, ps_int_w_psosr.posr,

Line 481: --nvl(psosr_mosr.owner_table_id, hz_party_sites_s.nextval) party_site_id,

477: ps_int_w_psosr.psos, ps_int_w_psosr.psosr,
478: ps_int_w_psosr.int_row_id,
479: nvl2(psosr_mosr.owner_table_id,decode(ps_int_w_psosr.owning_pty_chg_flag,'Y','I','U'),'I') action_flag,
480: nvl2(ps_int_w_psosr.owning_pty_chg_flag,null,psosr_mosr.owner_table_id) party_site_id,
481: --nvl(psosr_mosr.owner_table_id, hz_party_sites_s.nextval) party_site_id,
482: --psosr_mosr.owner_table_id party_site_id, -- Bug6082657
483: DECODE (ps_int_w_psosr.ps_int_pid, NULL, nvl2(nullif(psosr_mosr.party_id, ps_int_w_psosr.pid), 2, null),
484: NVL2(p.party_id, NULL, 3) ) error_flag,
485: ps_int_w_psosr.party_action_flag,