DBA Data[Home] [Help]

APPS.CE_BANK_ACCT_BALANCE_REPORT dependencies on CE_PROJECTED_BALANCES

Line 1285: from ce_bank_accounts ba, ce_bank_branches_v bh, ce_bank_acct_balances bb, ce_projected_balances pb

1281: l_balance_type_meaning as "ActualBalanceType",
1282: CE_BANKACCT_BA_REPORT_UTIL.get_balance(pb.PROJECTED_BALANCE,ba.CURRENCY_CODE) as "ProjectedBalance"
1283: ))))
1284: into l_xml
1285: from ce_bank_accounts ba, ce_bank_branches_v bh, ce_bank_acct_balances bb, ce_projected_balances pb
1286: where ba.BANK_BRANCH_ID = bh.BRANCH_PARTY_ID
1287: and ba.BANK_ACCOUNT_ID = bb.BANK_ACCOUNT_ID
1288: and bb.BALANCE_DATE between nvl(to_date(p_from_date, 'YYYY/MM/DD HH24:MI:SS'),bb.BALANCE_DATE) and nvl(to_date(p_to_date, 'YYYY/MM/DD HH24:MI:SS'),bb.BALANCE_DATE)
1289: and bh.BRANCH_PARTY_ID = nvl(p_branch_party_id, bh.BRANCH_PARTY_ID)