APPS.XTR_ACCOUNT_BAL_MAINT_P dependencies on CE_CASHPOOLS

Line 472: p_cashpool_id IN CE_CASHPOOLS.CASHPOOL_ID%TYPE,

468: END upload_accts_program;
469: ------------------------------------------------------------------------------------------------------------------
470: PROCEDURE MAINTAIN_SETOFFS(
471: p_party_code IN VARCHAR2,
472: p_cashpool_id IN CE_CASHPOOLS.CASHPOOL_ID%TYPE,
473: p_conc_acct_id IN CE_BANK_ACCOUNTS.BANK_ACCOUNT_ID%TYPE,
474: p_calc_date IN DATE) is
475: --
476: -- This procedure calculates the setoff account balances

Line 987: FROM ce_cashpools pool, ce_cashpool_sub_accts subs

983: and b.COMPANY_CODE = p_party_code
984: AND b.balance_date < l_prv_date);
985: CURSOR CASHPOOL_DETAILS IS
986: SELECT pool.cashpool_id, pool.conc_account_id
987: FROM ce_cashpools pool, ce_cashpool_sub_accts subs
988: WHERE pool.type = 'NOTIONAL'
989: AND pool.cashpool_id = subs.cashpool_id
990: AND subs.type in ('CONC','ACCT')
991: AND subs.account_id = l_bank_account_id

Line 994: FROM ce_cashpools pool, ce_cashpool_sub_accts subs

990: AND subs.type in ('CONC','ACCT')
991: AND subs.account_id = l_bank_account_id
992: UNION
993: SELECT pool.cashpool_id, pool.conc_account_id
994: FROM ce_cashpools pool, ce_cashpool_sub_accts subs
995: WHERE pool.type = 'NOTIONAL'
996: AND subs.type = 'POOL'
997: AND pool.cashpool_id = subs.cashpool_id
998: AND (subs.conc_account_id = l_bank_account_id OR

Line 1016: l_cashpool_id CE_CASHPOOLS.CASHPOOL_ID%TYPE;

1012: l_first_trans_flag VARCHAR2(1);
1013: l_oldest_date DATE;
1014: l_original_amount NUMBER;
1015: l_prv_prv_day_count_type VARCHAR2(1);
1016: l_cashpool_id CE_CASHPOOLS.CASHPOOL_ID%TYPE;
1017: l_conc_acct_id CE_BANK_ACCOUNTS.BANK_ACCOUNT_ID%TYPE;
1018: l_created_by XTR_DEALER_CODES.DEALER_CODE%TYPE;
1019: l_updated_by XTR_DEALER_CODES.DEALER_CODE%TYPE;
1020: --