DBA Data[Home] [Help]

APPS.XTR_MISC_P dependencies on XTR_SETTLEMENTS_V

Line 1240: from XTR_SETTLEMENTS_V

1236: and (b.PARTY_TYPE = 'C' or b.INTERNAL_PTY = 'Y');
1237: --
1238: cursor CFLOWS is
1239: select sum(CASHFLOW_AMOUNT),COMPANY_ACCOUNT,CURRENCY
1240: from XTR_SETTLEMENTS_V
1241: where AMOUNT_DATE > nvl(l_state_date,to_date('01/01/1980','DD/MM/YYYY'))
1242: and AMOUNT_DATE < trunc(SYSDATE)
1243: and COMPANY = l_acct_party
1244: and COMPANY_ACCOUNT = l_acct