DBA Data[Home] [Help]

APPS.XTR_IG_TRANSFERS_PKG dependencies on XTR_LIMIT_TYPES_V

Line 746: xtr_limit_types_v b

742: -----------------------------------------------------------------------------------------------------
743: cursor curs(c_comp in varchar2, c_cparty in varchar2, c_limit in varchar2, c_limit_type in varchar2) is
744: select 'Y'
745: from xtr_counterparty_limits_v a,
746: xtr_limit_types_v b
747: where a.company_code = c_comp
748: and a.cparty_code = c_cparty
749: and a.limit_code = c_limit
750: and a.limit_type = b.limit_type

Line 2426: xtr_limit_types_v b

2422: /* This will be checked by VALID_LIMIT_CODE. Don't need to check for final balance.
2423: cursor get_type (c_limit_code IN VARCHAR2) is
2424: select b.fx_invest_fund_type
2425: from xtr_counterparty_limits_v a,
2426: xtr_limit_types_v b
2427: where a.company_code = p_company_code
2428: and a.cparty_code = p_party_code
2429: and a.limit_type = b.limit_type
2430: and a.limit_code = c_limit_code;