DBA Data[Home] [Help]

APPS.XTR_FPS1_P dependencies on XTR_COUNTERPARTY_LIMITS

Line 885: from XTR_COUNTERPARTY_LIMITS cpl

881: l_level OUT NOCOPY VARCHAR2) is
882: --
883: cursor LIMIT_TYPE is
884: select 1
885: from XTR_COUNTERPARTY_LIMITS cpl
886: where cpl.CPARTY_CODE = l_cparty_code
887: and cpl.COMPANY_CODE = l_company_code
888: and cpl.LIMIT_CODE = l_limit_code
889: and (cpl.EXPIRY_DATE >= trunc(sysdate) or