APPS.XTR_WRAPPER_API_P dependencies on XTR_LIMIT_TYPES

Line 597: from XTR_COUNTERPARTY_LIMITS cl, XTR_LIMIT_TYPES lt

593: order by BALANCE_DATE;
594: --
595: cursor GET_LIM_CODE_CPARTY is
596: select cl.LIMIT_CODE
597: from XTR_COUNTERPARTY_LIMITS cl, XTR_LIMIT_TYPES lt
598: where cl.COMPANY_CODE = new_company
599: and cl.CPARTY_CODE = l_bank_code
600: and cl.LIMIT_TYPE = lt.LIMIT_TYPE
601: and ((new_bal_ledger >= 0 and lt.FX_INVEST_FUND_TYPE = 'I')