DBA Data[Home] [Help]

APPS.XTR_WRAPPER_API_P dependencies on XTR_COUNTERPARTY_LIMITS

Line 398: from XTR_COUNTERPARTY_LIMITS cl, XTR_LIMIT_TYPES lt

394: order by BALANCE_DATE;
395: --
396: cursor GET_LIM_CODE_CPARTY is
397: select cl.LIMIT_CODE
398: from XTR_COUNTERPARTY_LIMITS cl, XTR_LIMIT_TYPES lt
399: where cl.COMPANY_CODE = new_company
400: and cl.CPARTY_CODE = l_bank_code
401: and cl.LIMIT_TYPE = lt.LIMIT_TYPE
402: and ((new_bal_ledger >= 0 and lt.FX_INVEST_FUND_TYPE = 'I')