APPS.XTR_COF_P dependencies on XTR_PARTIES_V

Line 3053: FROM xtr_parties_v p

3049: Sum(no_of_deals) num_deals
3050: FROM xtr_cost_of_funds_v
3051: WHERE as_at_date BETWEEN p_date_from AND p_date_to
3052: AND company_code IN (SELECT p.party_code
3053: FROM xtr_parties_v p
3054: WHERE p.party_type = 'C')
3055: AND deal_type LIKE Nvl(p_deal_type,'%')
3056: AND ( (deal_type = 'NI' AND deal_subtype = 'BUY')
3057: OR (deal_type = 'BOND' AND deal_subtype = 'BUY')

Line 3131: FROM xtr_parties_v p

3127: Sum(no_of_deals) num_deals
3128: FROM xtr_cost_of_funds_v
3129: WHERE as_at_date BETWEEN p_date_from AND p_date_to
3130: AND company_code IN (SELECT p.party_code
3131: FROM xtr_parties_v p
3132: WHERE p.party_type = 'C')
3133: AND deal_type LIKE Nvl(p_deal_type,'%')
3134: AND ( (deal_type = 'NI' AND deal_subtype = 'ISSUE')
3135: OR (deal_type = 'BOND' AND deal_subtype = 'ISSUE')

Line 3204: FROM xtr_parties_v p

3200: Decode(Sum(gross_base_amount),0,0, Sum(gross_contra_spot_amount)/Sum(gross_base_amount)) avg_spot_rate
3201: FROM xtr_cost_of_funds_v
3202: WHERE as_at_date BETWEEN p_date_from AND p_date_to
3203: AND company_code IN (SELECT p.party_code
3204: FROM xtr_parties_v p
3205: WHERE p.party_type = 'C')
3206: AND deal_type LIKE Nvl(p_deal_type,'%')
3207: AND deal_type = 'FX'
3208: AND currency LIKE Nvl(p_currency,'%')

Line 3231: FROM xtr_parties_v p

3227: WHERE as_at_date BETWEEN p_from_date and p_to_date
3228: AND ((v_company IS NOT NULL AND company_code = v_company)
3229: OR (v_company IS NULL AND
3230: company_code IN (SELECT p.party_code
3231: FROM xtr_parties_v p
3232: WHERE p.party_type = 'C')))
3233: AND deal_type LIKE Nvl(v_deal, '%')
3234: AND (product_type LIKE Nvl(v_product, '%') or product_type is null)
3235: AND (portfolio_code LIKE Nvl(v_portfolio, '%') or portfolio_code is null)

Line 3250: FROM xtr_parties_v p

3246: WHERE as_at_date BETWEEN p_from_date and p_to_date
3247: AND ((v_company IS NOT NULL AND company_code = v_company)
3248: OR (v_company IS NULL AND
3249: company_code IN (SELECT p.party_code
3250: FROM xtr_parties_v p
3251: WHERE p.party_type = 'C')))
3252: AND deal_type LIKE Nvl(v_deal, '%')
3253: AND (product_type LIKE Nvl(v_product, '%') or product_type is null)
3254: AND (portfolio_code LIKE Nvl(v_portfolio, '%') or portfolio_code is null)

Line 3268: FROM xtr_parties_v p

3264: WHERE as_at_date BETWEEN p_from_date and p_to_date
3265: AND ((v_company IS NOT NULL AND company_code = v_company)
3266: OR (v_company IS NULL AND
3267: company_code IN (SELECT p.party_code
3268: FROM xtr_parties_v p
3269: WHERE p.party_type = 'C')))
3270: AND deal_type LIKE Nvl(v_deal, '%')
3271: AND (product_type LIKE Nvl(v_product, '%') or product_type is null)
3272: AND (portfolio_code LIKE Nvl(v_portfolio, '%') or portfolio_code is null)