APPS.XTR_NI_TRANSFERS_PKG dependencies on XTR_PARTIES_V

Line 869: from xtr_parties_v

865: end if;
866:
867: select count(*)
868: into l_count
869: from xtr_parties_v
870: where party_type = 'CP'
871: and party_category = 'CL'
872: and party_code = p_client_code;
873:

Line 1119: from xtr_parties_v

1115: BEGIN
1116: /* bug 2798328
1117: select count(*)
1118: into l_count
1119: from xtr_parties_v
1120: where party_code=p_party_code;
1121:
1122: return (p_party_code is null or l_count>0);
1123: */

Line 1420: from xtr_parties_v

1416: if l_use_currency is null then
1417:
1418: select nvl(set_of_books_currency,l_system_currency)
1419: into l_function_currency
1420: from xtr_parties_v
1421: where party_code = p_company_code;
1422:
1423: if l_function_currency <> p_currency_code then
1424: xtr_fps2_p.currency_cross_rate(l_function_currency,

Line 2008: from xtr_PARTIES_v p,

2004: where m.CURRENCY = G_Ni_Main_Rec.CURRENCY;
2005:
2006: cursor RND_FAC is
2007: select m.ROUNDING_FACTOR
2008: from xtr_PARTIES_v p,
2009: xtr_MASTER_CURRENCIES_v m
2010: where p.PARTY_CODE = G_Ni_Main_Rec.COMPANY_CODE
2011: and p.PARTY_TYPE = 'C'
2012: and m.CURRENCY = p.HOME_CURRENCY;

Line 2534: from xtr_parties_v p,

2530: l_roundfac NUMBER(3,2);
2531:
2532: cursor rnd_fac is
2533: select m.rounding_factor
2534: from xtr_parties_v p,
2535: xtr_master_currencies_v m
2536: where p.party_code = G_Ni_Main_Rec.company_code
2537: and p.party_type = 'C'
2538: and m.currency = p.home_currency;

Line 2726: xtr_PARTIES_v p

2722: select nvl(a.ROUNDING_FACTOR,2),
2723: nvl(b.ROUNDING_FACTOR,2)
2724: from XTR_MASTER_CURRENCIES_v a,
2725: xtr_MASTER_CURRENCIES_v b,
2726: xtr_PARTIES_v p
2727: where a.CURRENCY = G_Ni_Main_Rec.CURRENCY
2728: and p.PARTY_CODE = G_Ni_Main_Rec.COMPANY_CODE
2729: and p.PARTY_TYPE = 'C'
2730: and b.CURRENCY = p.HOME_CURRENCY;

Line 2927: from xtr_parties_v

2923: /*--------------------------------------------------------------------------------*/
2924: PROCEDURE GET_RISK_PARTY_NAMES IS
2925: cursor risk_party_name(p_party_code in VARCHAR2) is
2926: select short_name
2927: from xtr_parties_v
2928: where party_code=p_party_code;
2929:
2930: BEGIN
2931: open risk_party_name(G_Ni_Main_Rec.ACCEPTOR_CODE);