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_ZBA_DEAL_GENERATION dependencies on CE_CASHPOOL_SUB_ACCTS

Line 469: l_acct_type ce_cashpool_sub_accts.type%TYPE; -- Bug 14512483

465:
466: l_bank_acct_text ce_statement_lines.bank_account_text%TYPE; -- Bug # 7829965
467: l_dst_bank_acct_id ce_statement_headers.bank_account_id%TYPE :=0; -- Bug # 7829965
468:
469: l_acct_type ce_cashpool_sub_accts.type%TYPE; -- Bug 14512483
470: l_offset_acct_type ce_cashpool_sub_accts.type%TYPE; -- Bug 14512483
471:
472: BEGIN
473: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.zba_generation');

Line 470: l_offset_acct_type ce_cashpool_sub_accts.type%TYPE; -- Bug 14512483

466: l_bank_acct_text ce_statement_lines.bank_account_text%TYPE; -- Bug # 7829965
467: l_dst_bank_acct_id ce_statement_headers.bank_account_id%TYPE :=0; -- Bug # 7829965
468:
469: l_acct_type ce_cashpool_sub_accts.type%TYPE; -- Bug 14512483
470: l_offset_acct_type ce_cashpool_sub_accts.type%TYPE; -- Bug 14512483
471:
472: BEGIN
473: cep_standard.debug('>>CE_ZBA_DEAL_GENERATION.zba_generation');
474: cep_standard.debug('p_bank_branch_id : '|| p_bank_branch_id);

Line 695: CE_CASHPOOL_SUB_ACCTS cps

691: SELECT cps. account_id
692: INTO l_dst_bank_acct_id
693: FROM ce_bank_accounts cba,
694: ce_cashpools cp,
695: CE_CASHPOOL_SUB_ACCTS cps
696: WHERE cba.bank_account_id = cp.conc_account_id
697: AND cp.cashpool_id = cps.cashpool_id
698: AND cps.type in ('ACCT','CONC','INV','FUND') /* bug 14140123 */
699: AND cps.account_id IN (SELECT bank_account_id

Line 742: FROM CE_CASHPOOL_SUB_ACCTS

738: -- Bug 14512483 Start
739: -- Validations for Cashpools with 2 Concentration accounts
740: SELECT TYPE
741: INTO L_ACCT_TYPE
742: FROM CE_CASHPOOL_SUB_ACCTS
743: WHERE CASHPOOL_ID = X_CASHPOOL_ID
744: AND ACCOUNT_ID = CE_ZBA_DEAL_GENERATION.csh_bank_account_id;
745:
746: SELECT TYPE

Line 748: FROM CE_CASHPOOL_SUB_ACCTS

744: AND ACCOUNT_ID = CE_ZBA_DEAL_GENERATION.csh_bank_account_id;
745:
746: SELECT TYPE
747: INTO L_OFFSET_ACCT_TYPE
748: FROM CE_CASHPOOL_SUB_ACCTS
749: WHERE CASHPOOL_ID = X_CASHPOOL_ID
750: AND ACCOUNT_ID = X_OFFSET_BANK_ACCOUNT_ID;
751:
752: cep_standard.debug('L_ACCT_TYPE = '||L_ACCT_TYPE);