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

356: END IF;
357: IF l_bat_profile = 'CE' THEN
358: SELECT count(1)
359: INTO l_count
360: FROM ce_cashpool_sub_accts
361: WHERE cashpool_id = X_cashpool_id
362: AND account_id = X_from_bank_account_id
363: AND type in ('CONC','INV','FUND');
364:

Line 535: INSERT INTO ce_cashpool_sub_accts(

531: UPDATE ce_cashpools
532: SET parent_cashpool_id = p_parent_cashpool_id
533: WHERE cashpool_id = p_cashpool_id;
534:
535: INSERT INTO ce_cashpool_sub_accts(
536: cashpool_sub_acct_id,
537: cashpool_id,
538: type,
539: account_id,

Line 548: SELECT CE_CASHPOOL_SUB_ACCTS_S.nextval,

544: creation_date,
545: last_updated_by,
546: last_update_date,
547: last_update_login)
548: SELECT CE_CASHPOOL_SUB_ACCTS_S.nextval,
549: p_parent_cashpool_id,
550: 'NEST',
551: sub.account_id,
552: sub.party_code,

Line 560: FROM ce_cashpool_sub_accts sub

556: sysdate,
557: nvl(fnd_global.user_id,-1),
558: sysdate,
559: nvl(fnd_global.user_id,-1)
560: FROM ce_cashpool_sub_accts sub
561: WHERE sub.cashpool_id = p_cashpool_id
562: AND sub.type <> 'POOL';
563:
564: END Populate_Nested_Accounts;

Line 588: DELETE FROM ce_cashpool_sub_accts

584: UPDATE ce_cashpools
585: SET parent_cashpool_id = null
586: WHERE parent_cashpool_id = p_cashpool_id;
587:
588: DELETE FROM ce_cashpool_sub_accts
589: WHERE cashpool_id = p_cashpool_id;
590:
591: END Delete_Sub_Accounts;
592:

Line 613: DELETE FROM ce_cashpool_sub_accts

609: PROCEDURE Update_Parent_Nested_Accounts(p_cashpool_id NUMBER,
610: p_parent_cashpool_id NUMBER) IS
611: BEGIN
612:
613: DELETE FROM ce_cashpool_sub_accts
614: WHERE cashpool_id = p_parent_cashpool_id
615: AND nested_parent_pool_id = p_cashpool_id;
616:
617: INSERT INTO ce_cashpool_sub_accts(

Line 617: INSERT INTO ce_cashpool_sub_accts(

613: DELETE FROM ce_cashpool_sub_accts
614: WHERE cashpool_id = p_parent_cashpool_id
615: AND nested_parent_pool_id = p_cashpool_id;
616:
617: INSERT INTO ce_cashpool_sub_accts(
618: cashpool_sub_acct_id,
619: cashpool_id,
620: type,
621: account_id,

Line 630: SELECT CE_CASHPOOL_SUB_ACCTS_S.nextval,

626: creation_date,
627: last_updated_by,
628: last_update_date,
629: last_update_login)
630: SELECT CE_CASHPOOL_SUB_ACCTS_S.nextval,
631: p_parent_cashpool_id,
632: 'NEST',
633: sub.account_id,
634: sub.party_code,

Line 642: FROM ce_cashpool_sub_accts sub

638: sysdate,
639: nvl(fnd_global.user_id,-1),
640: sysdate,
641: nvl(fnd_global.user_id,-1)
642: FROM ce_cashpool_sub_accts sub
643: WHERE sub.cashpool_id = p_cashpool_id
644: AND sub.type <> 'POOL';
645:
646: END Update_Parent_Nested_Accounts;

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

723: | Update_Bank_Account_Id |
724: | |
725: | DESCRIPTION |
726: | This procedure updates the bank account id in ce_cashpools |
727: | and ce_cashpool_sub_accts when a bank account that is also a |
728: | cash pool sub-account is "linked" or "unlinked" with AP |
729: | |
730: | CALLED BY |
731: | OA Controller Classes |

Line 741: UPDATE ce_cashpool_sub_accts

737: PROCEDURE Update_Bank_Account_Id(p_old_bank_account_id NUMBER,
738: p_new_bank_account_id NUMBER) IS
739: BEGIN
740:
741: UPDATE ce_cashpool_sub_accts
742: SET account_id = p_new_bank_account_id
743: WHERE account_id = p_old_bank_account_id
744: AND type <> 'POOL';
745:

Line 746: UPDATE ce_cashpool_sub_accts

742: SET account_id = p_new_bank_account_id
743: WHERE account_id = p_old_bank_account_id
744: AND type <> 'POOL';
745:
746: UPDATE ce_cashpool_sub_accts
747: SET conc_account_id = p_new_bank_account_id
748: WHERE conc_account_id = p_old_bank_account_id;
749:
750: UPDATE ce_cashpool_sub_accts

Line 750: UPDATE ce_cashpool_sub_accts

746: UPDATE ce_cashpool_sub_accts
747: SET conc_account_id = p_new_bank_account_id
748: WHERE conc_account_id = p_old_bank_account_id;
749:
750: UPDATE ce_cashpool_sub_accts
751: SET inv_conc_account_id = p_new_bank_account_id
752: WHERE inv_conc_account_id = p_old_bank_account_id;
753:
754: UPDATE ce_cashpool_sub_accts

Line 754: UPDATE ce_cashpool_sub_accts

750: UPDATE ce_cashpool_sub_accts
751: SET inv_conc_account_id = p_new_bank_account_id
752: WHERE inv_conc_account_id = p_old_bank_account_id;
753:
754: UPDATE ce_cashpool_sub_accts
755: SET fund_conc_account_id = p_new_bank_account_id
756: WHERE fund_conc_account_id = p_old_bank_account_id;
757:
758: UPDATE ce_cashpools

Line 821: FROM ce_cashpool_sub_accts

817:
818: IF p_trx_type = 'SWEEP_IN' THEN -- Sweep in
819: SELECT cashpool_id, type
820: INTO l_cashpool_id, l_type
821: FROM ce_cashpool_sub_accts
822: WHERE type in ('ACCT','CONC','INV')
823: AND account_id = p_header_bank_account_id
824: AND cashpool_id in
825: (select cashpool_id

Line 832: FROM ce_cashpool_sub_accts

828: and nvl(effective_date_to,p_trx_date) >= p_trx_date);
829:
830: SELECT type
831: INTO l_offset_type
832: FROM ce_cashpool_sub_accts
833: WHERE cashpool_id = l_cashpool_id
834: AND account_id = l_offset_bank_account_id
835: AND type in ('ACCT','CONC','FUND');
836:

Line 847: FROM ce_cashpool_sub_accts

843:
844: ELSE -- Sweep out
845: SELECT cashpool_id, type
846: INTO l_cashpool_id, l_type
847: FROM ce_cashpool_sub_accts
848: WHERE type in ('ACCT','CONC','FUND')
849: AND account_id = p_header_bank_account_id
850: AND cashpool_id in
851: (select cashpool_id

Line 858: FROM ce_cashpool_sub_accts

854: and nvl(effective_date_to,p_trx_date) >= p_trx_date);
855:
856: SELECT type
857: INTO l_offset_type
858: FROM ce_cashpool_sub_accts
859: WHERE cashpool_id = l_cashpool_id
860: AND account_id = l_offset_bank_account_id
861: AND type in ('ACCT','CONC','INV');
862: