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 452: nvl(party_site_id, hz_party_sites_s.nextval),

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

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

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

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

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