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_CASHPOOL_SUB_ACCTS

Line 408: -- FROM ce_cashpool_sub_accts

404: -- The source account will always be the payment account
405: l_payment_details_from := 'SRC';
406: -- SELECT count(1)
407: -- INTO l_count
408: -- FROM ce_cashpool_sub_accts
409: -- WHERE cashpool_id = X_cashpool_id
410: -- AND account_id = X_from_bank_account_id
411: -- AND type in ('CONC','INV','FUND');
412: --

Line 613: INSERT INTO ce_cashpool_sub_accts(

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(
614: /*01*/cashpool_sub_acct_id,
615: /*02*/cashpool_id,
616: /*03*/type,
617: /*04*/account_id,

Line 627: /01/CE_CASHPOOL_SUB_ACCTS_S.nextval,

623: /*10*/last_updated_by,
624: /*11*/last_update_date,
625: /*12*/last_update_login)
626: SELECT
627: /*01*/CE_CASHPOOL_SUB_ACCTS_S.nextval,
628: /*02*/p_parent_cashpool_id,
629: /*03*/'NEST',
630: /*04*/sub.account_id,
631: /*05*/sub.party_code,

Line 639: FROM ce_cashpool_sub_accts sub

635: /*09*/sysdate,
636: /*10*/nvl(fnd_global.user_id,-1),
637: /*11*/sysdate,
638: /*12*/nvl(fnd_global.user_id,-1)
639: FROM ce_cashpool_sub_accts sub
640: WHERE sub.cashpool_id = p_cashpool_id
641: AND sub.type <> 'POOL';
642:
643: END Populate_Nested_Accounts;

Line 667: DELETE ce_cashpool_sub_accts

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
668: WHERE cashpool_id = p_cashpool_id;
669:
670: END Delete_Sub_Accounts;
671:

Line 694: DELETE FROM ce_cashpool_sub_accts

690: p_parent_cashpool_id NUMBER
691: ) IS
692: BEGIN
693:
694: DELETE FROM ce_cashpool_sub_accts
695: WHERE cashpool_id = p_parent_cashpool_id
696: AND nested_parent_pool_id = p_cashpool_id;
697:
698: INSERT INTO ce_cashpool_sub_accts(

Line 698: INSERT INTO ce_cashpool_sub_accts(

694: DELETE FROM ce_cashpool_sub_accts
695: WHERE cashpool_id = p_parent_cashpool_id
696: AND nested_parent_pool_id = p_cashpool_id;
697:
698: INSERT INTO ce_cashpool_sub_accts(
699: /*01*/cashpool_sub_acct_id,
700: /*02*/cashpool_id,
701: /*03*/type,
702: /*04*/account_id,

Line 712: /01/CE_CASHPOOL_SUB_ACCTS_S.nextval,

708: /*10*/last_updated_by,
709: /*11*/last_update_date,
710: /*12*/last_update_login)
711: SELECT
712: /*01*/CE_CASHPOOL_SUB_ACCTS_S.nextval,
713: /*02*/p_parent_cashpool_id,
714: /*03*/'NEST',
715: /*04*/sub.account_id,
716: /*05*/sub.party_code,

Line 724: FROM ce_cashpool_sub_accts sub

720: /*09*/sysdate,
721: /*10*/nvl(fnd_global.user_id,-1),
722: /*11*/sysdate,
723: /*12*/nvl(fnd_global.user_id,-1)
724: FROM ce_cashpool_sub_accts sub
725: WHERE sub.cashpool_id = p_cashpool_id
726: AND sub.type <> 'POOL';
727:
728: END Update_Parent_Nested_Accounts;

Line 809: | and ce_cashpool_sub_accts when a bank account that is also a |

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 |
813: | OA Controller Classes |

Line 824: UPDATE ce_cashpool_sub_accts

820: p_old_bank_account_id NUMBER,
821: p_new_bank_account_id NUMBER
822: ) IS
823: BEGIN
824: UPDATE ce_cashpool_sub_accts
825: SET account_id = p_new_bank_account_id
826: WHERE account_id = p_old_bank_account_id
827: AND type <> 'POOL';
828:

Line 829: UPDATE ce_cashpool_sub_accts

825: SET account_id = p_new_bank_account_id
826: WHERE account_id = p_old_bank_account_id
827: AND type <> 'POOL';
828:
829: UPDATE ce_cashpool_sub_accts
830: SET conc_account_id = p_new_bank_account_id
831: WHERE conc_account_id = p_old_bank_account_id;
832:
833: UPDATE ce_cashpool_sub_accts

Line 833: UPDATE ce_cashpool_sub_accts

829: UPDATE ce_cashpool_sub_accts
830: SET conc_account_id = p_new_bank_account_id
831: WHERE conc_account_id = p_old_bank_account_id;
832:
833: UPDATE ce_cashpool_sub_accts
834: SET inv_conc_account_id = p_new_bank_account_id
835: WHERE inv_conc_account_id = p_old_bank_account_id;
836:
837: UPDATE ce_cashpool_sub_accts

Line 837: UPDATE ce_cashpool_sub_accts

833: UPDATE ce_cashpool_sub_accts
834: SET inv_conc_account_id = p_new_bank_account_id
835: WHERE inv_conc_account_id = p_old_bank_account_id;
836:
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

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 920: FROM ce_cashpool_sub_accts

916: IF p_trx_type = 'SWEEP_IN'
917: THEN -- Sweep in
918: SELECT cashpool_id, type
919: INTO l_cashpool_id, l_type
920: FROM ce_cashpool_sub_accts
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

Line 932: FROM ce_cashpool_sub_accts

928: log_msg(l_debug_proc,'l_cashpool_id='||l_cashpool_id||',l_type='||l_type);
929:
930: SELECT type
931: INTO l_offset_type
932: FROM ce_cashpool_sub_accts
933: WHERE cashpool_id = l_cashpool_id
934: AND account_id = l_offset_bank_account_id
935: AND type in ('ACCT','CONC','FUND','INV'); -- Bug 14512843: Added INV
936: log_msg(l_debug_proc,'l_offset_type='||l_offset_type);

Line 949: FROM ce_cashpool_sub_accts

945:
946: ELSE -- Sweep out
947: SELECT cashpool_id, type
948: INTO l_cashpool_id, l_type
949: FROM ce_cashpool_sub_accts
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

Line 961: FROM ce_cashpool_sub_accts

957: log_msg(l_debug_proc,'l_cashpool_id='||l_cashpool_id||',l_type='||l_type);
958:
959: SELECT type
960: INTO l_offset_type
961: FROM ce_cashpool_sub_accts
962: WHERE cashpool_id = l_cashpool_id
963: AND account_id = l_offset_bank_account_id
964: AND type in ('ACCT','CONC','INV','FUND'); -- Bug 14512843: Added FUND
965: log_msg(l_debug_proc,'l_offset_type='||l_offset_type);