APPS.XTR_ACCOUNT_BAL_MAINT_P dependencies on XTR_LIMIT_TYPES

Line 280: from XTR_COUNTERPARTY_LIMITS cl, XTR_LIMIT_TYPES lt

276: order by BALANCE_DATE;
277: --
278: cursor GET_LIM_CODE_CPARTY is
279: select cl.LIMIT_CODE
280: from XTR_COUNTERPARTY_LIMITS cl, XTR_LIMIT_TYPES lt
281: where cl.COMPANY_CODE = new_company
282: and cl.CPARTY_CODE = l_bank_code
283: and cl.LIMIT_TYPE = lt.LIMIT_TYPE
284: and ((new_bal >= 0 and lt.FX_INVEST_FUND_TYPE = 'I')