eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CE_LEVELING_UTILS dependencies on CE_CASHPOOLS

Line 137: FROM ce_cashpools

133: THEN
134: SELECT nvl(effective_date_from,to_date(p_as_of_date,'YYYY/MM/DD HH24:MI:SS')),
135: nvl(effective_date_to,to_date(p_as_of_date,'YYYY/MM/DD HH24:MI:SS'))
136: INTO l_effective_date_from, l_effective_date_to
137: FROM ce_cashpools
138: WHERE cashpool_id = p_transfer.cashpool_id;
139:
140: IF ( to_date(p_as_of_date,'YYYY/MM/DD HH24:MI:SS') >= l_effective_date_from
141: AND to_date(p_as_of_date,'YYYY/MM/DD HH24:MI:SS') <= l_effective_date_to)

Line 287: l_authorization_bat CE_CASHPOOLS.authorization_bat%TYPE;

283: l_count NUMBER;
284: l_trx_subtype VARCHAR2(30);
285: l_result VARCHAR2(7);
286: l_msg_count NUMBER;
287: l_authorization_bat CE_CASHPOOLS.authorization_bat%TYPE;
288: l_trx_type CE_STATEMENT_LINES.trx_type%TYPE;
289: l_from_bank_account_id CE_BANK_ACCOUNTS.bank_Account_id%TYPE;
290: l_to_bank_Account_id CE_BANK_ACCOUNTS.bank_account_id%TYPE;
291:

Line 308: FROM ce_cashpools

304:
305: IF (l_bat_profile = 'XTR') THEN
306: SELECT authorization_bat
307: INTO l_authorization_bat
308: FROM ce_cashpools
309: WHERE cashpool_id = X_cashpool_id;
310:
311: log_msg(l_debug_proc,'l_authorization_bat='||nvl(l_authorization_bat,''));
312: IF (l_authorization_bat IS NOT NULL)

Line 330: FROM ce_cashpools

326: SELECT decode(nvl(single_conc_account_flag,'Y'),'Y',conc_account_id, fund_conc_account_id),
327: currency_code
328: INTO l_conc_account_id,
329: l_currency_code
330: FROM ce_cashpools
331: WHERE cashpool_id = X_cashpool_id;
332:
333: --bug5346601
334: l_from_bank_account_id := X_from_Bank_Account_id;

Line 444: FROM ce_trxns_subtype_codes tst, ce_cashpools cp

440: p_trxn_reference_number => l_trx_number);
441:
442: SELECT tst.transaction_sub_type_name
443: INTO l_trx_subtype
444: FROM ce_trxns_subtype_codes tst, ce_cashpools cp
445: WHERE cp.trxn_subtype_code_id = tst.trxn_subtype_code_id(+)
446: AND cp.cashpool_id = X_cashpool_id;
447:
448: IF l_result = 'SUCCESS' THEN

Line 609: UPDATE ce_cashpools

605: p_parent_cashpool_id NUMBER,
606: p_cashpool_id NUMBER) IS
607: BEGIN
608:
609: UPDATE ce_cashpools
610: SET parent_cashpool_id = p_parent_cashpool_id
611: WHERE cashpool_id = p_cashpool_id;
612:
613: INSERT INTO ce_cashpool_sub_accts(

Line 663: UPDATE ce_cashpools

659: --------------------------------------------------------------------- */
660: PROCEDURE Delete_Sub_Accounts(p_cashpool_id NUMBER) IS
661: BEGIN
662:
663: UPDATE ce_cashpools
664: SET parent_cashpool_id = null
665: WHERE parent_cashpool_id = p_cashpool_id;
666:
667: DELETE ce_cashpool_sub_accts

Line 808: | This procedure updates the bank account id in ce_cashpools |

804: | PUBLIC PROCEDRE |
805: | Update_Bank_Account_Id |
806: | |
807: | DESCRIPTION |
808: | This procedure updates the bank account id in ce_cashpools |
809: | and ce_cashpool_sub_accts when a bank account that is also a |
810: | cash pool sub-account is "linked" or "unlinked" with AP |
811: | |
812: | CALLED BY |

Line 841: UPDATE ce_cashpools

837: UPDATE ce_cashpool_sub_accts
838: SET fund_conc_account_id = p_new_bank_account_id
839: WHERE fund_conc_account_id = p_old_bank_account_id;
840:
841: UPDATE ce_cashpools
842: SET conc_account_id = p_new_bank_account_id
843: WHERE conc_account_id = p_old_bank_account_id;
844:
845: UPDATE ce_cashpools

Line 845: UPDATE ce_cashpools

841: UPDATE ce_cashpools
842: SET conc_account_id = p_new_bank_account_id
843: WHERE conc_account_id = p_old_bank_account_id;
844:
845: UPDATE ce_cashpools
846: SET inv_conc_account_id = p_new_bank_account_id
847: WHERE inv_conc_account_id = p_old_bank_account_id;
848:
849: UPDATE ce_cashpools

Line 849: UPDATE ce_cashpools

845: UPDATE ce_cashpools
846: SET inv_conc_account_id = p_new_bank_account_id
847: WHERE inv_conc_account_id = p_old_bank_account_id;
848:
849: UPDATE ce_cashpools
850: SET fund_conc_account_id = p_new_bank_account_id
851: WHERE fund_conc_account_id = p_old_bank_account_id;
852:
853: UPDATE ce_cp_worksheet_lines

Line 902: FROM ce_bank_accounts cba, ce_cashpools cp, ce_cashpool_sub_accts cps

898:
899: -- Bug 8489586 Start
900: SELECT DISTINCT cps. account_id -- Bug 14512843: Added DISTINCT
901: INTO l_offset_bank_account_id
902: FROM ce_bank_accounts cba, ce_cashpools cp, ce_cashpool_sub_accts cps
903: WHERE cba.bank_account_id in(cp.conc_account_id, -- Bug 14512483 Modified clause
904: cp.inv_conc_account_id,
905: cp.fund_conc_account_id)
906: AND cp.cashpool_id = cps.cashpool_id

Line 925: FROM ce_cashpools

921: WHERE type in ('ACCT','CONC','INV','FUND') -- Bug 14512483: Added FUND
922: AND account_id = p_header_bank_account_id
923: AND cashpool_id in
924: (SELECT cashpool_id
925: FROM ce_cashpools
926: WHERE sweeps_flag = 'Y'
927: AND NVL(effective_date_to,p_trx_date) >= p_trx_date);
928: log_msg(l_debug_proc,'l_cashpool_id='||l_cashpool_id||',l_type='||l_type);
929:

Line 954: FROM ce_cashpools

950: WHERE type in ('ACCT','CONC','FUND','INV') -- Bug 14512843: Added INV
951: AND account_id = p_header_bank_account_id
952: AND cashpool_id in
953: (SELECT cashpool_id
954: FROM ce_cashpools
955: WHERE sweeps_flag = 'Y'
956: AND nvl(effective_date_to,p_trx_date) >= p_trx_date);
957: log_msg(l_debug_proc,'l_cashpool_id='||l_cashpool_id||',l_type='||l_type);
958: