APPS.XTR_IG_TRANSFERS_PKG dependencies on XTR_PARTIES_V

Line 131: from XTR_PARTIES_V

127: function IS_COMPANY(p_comp IN VARCHAR2) return boolean is
128: -----------------------------------------------------------------------------------------------------
129: cursor curs(c_comp IN VARCHAR2) is
130: select 'Y'
131: from XTR_PARTIES_V
132: where party_code = c_comp
133: and party_type = 'C';
134:
135: l_dummy VARCHAR2(1);

Line 405: from XTR_PARTIES_V

401: p_cparty IN VARCHAR2) return boolean is
402: -----------------------------------------------------------------------------------------------------
403: cursor curs(c_comp IN VARCHAR2, c_cparty IN VARCHAR2) is
404: select 'Y'
405: from XTR_PARTIES_V
406: where party_code = c_cparty
407: and ((internal_pty = 'Y' and cross_ref_to_other_party = c_comp)
408: or (party_type = 'C' and party_code <> c_comp));
409:

Line 811: from xtr_PARTIES_v p,

807: function VALID_COMP_REPORTING_CCY (p_comp IN VARCHAR2) return boolean is
808: -----------------------------------------------------------------------------------------------------
809: cursor RND_FAC is
810: select 'Y'
811: from xtr_PARTIES_v p,
812: xtr_MASTER_CURRENCIES_v m
813: where p.PARTY_CODE = p_comp
814: and m.CURRENCY = p.HOME_CURRENCY;
815:

Line 1274: from xtr_PARTIES_v p,

1270: roundfac NUMBER(3,2);
1271:
1272: cursor RND_FAC is
1273: select m.ROUNDING_FACTOR
1274: from xtr_PARTIES_v p,
1275: xtr_MASTER_CURRENCIES_v m
1276: where p.PARTY_CODE = G_Ig_Main_Rec.COMPANY_CODE
1277: and m.CURRENCY = p.HOME_CURRENCY;
1278:

Line 2388: xtr_PARTIES_V p,

2384: a.rounding_factor,
2385: a.ig_year_basis,
2386: m.rounding_factor
2387: from xtr_MASTER_CURRENCIES_V a,
2388: xtr_PARTIES_V p,
2389: xtr_MASTER_CURRENCIES_V m
2390: where a.CURRENCY = p_currency
2391: and p.PARTY_CODE = p_company_code
2392: and m.CURRENCY = p.HOME_CURRENCY;

Line 2778: from xtr_parties_v

2774: -- 3800146 ******************************************************************************************************
2775: --*****************************************************************************************************************
2776: cursor USER_ACCESS (l_comp VARCHAR2) is
2777: select 'Y'
2778: from xtr_parties_v
2779: where party_type = 'C'
2780: and party_code = l_comp;
2781: /*
2782: temp_Interface_rate_a XTR_DEALS_INTERFACE.RATE_A%TYPE;