APPS.XTR_ACCOUNT_BAL_MAINT_P dependencies on CE_CASHPOOL_SUB_ACCTS

Line 522: FROM ce_cashpool_sub_accts

518: --
519:
520: cursor SEL_SETOFF_ACCT is
521: SELECT account_id acct_id
522: FROM ce_cashpool_sub_accts
523: WHERE cashpool_id = p_cashpool_id
524: AND type in ('CONC','ACCT')
525: UNION
526: SELECT nvl(conc_account_id, inv_conc_account_id) acct_id

Line 527: FROM ce_cashpool_sub_accts

523: WHERE cashpool_id = p_cashpool_id
524: AND type in ('CONC','ACCT')
525: UNION
526: SELECT nvl(conc_account_id, inv_conc_account_id) acct_id
527: FROM ce_cashpool_sub_accts
528: WHERE cashpool_id = p_cashpool_id
529: AND type = 'POOL'
530: AND nvl(conc_account_id, inv_conc_account_id) is not null
531: UNION

Line 533: FROM ce_cashpool_sub_accts

529: AND type = 'POOL'
530: AND nvl(conc_account_id, inv_conc_account_id) is not null
531: UNION
532: SELECT fund_conc_account_id acct_id
533: FROM ce_cashpool_sub_accts
534: WHERE cashpool_id = p_cashpool_id
535: AND type = 'POOL'
536: AND fund_conc_account_id is not null;
537:

Line 557: FROM ce_cashpool_sub_accts

553: FROM ce_bank_acct_balances --4696629
554: WHERE balance_date >= p_calc_date
555: AND bank_account_id IN
556: (SELECT account_id acct_id
557: FROM ce_cashpool_sub_accts
558: WHERE cashpool_id = p_cashpool_id
559: AND type in ('CONC','ACCT')
560: UNION
561: SELECT nvl(conc_account_id, inv_conc_account_id) acct_id

Line 562: FROM ce_cashpool_sub_accts

558: WHERE cashpool_id = p_cashpool_id
559: AND type in ('CONC','ACCT')
560: UNION
561: SELECT nvl(conc_account_id, inv_conc_account_id) acct_id
562: FROM ce_cashpool_sub_accts
563: WHERE cashpool_id = p_cashpool_id
564: AND type = 'POOL'
565: AND nvl(conc_account_id, inv_conc_account_id) is not null
566: UNION

Line 568: FROM ce_cashpool_sub_accts

564: AND type = 'POOL'
565: AND nvl(conc_account_id, inv_conc_account_id) is not null
566: UNION
567: SELECT fund_conc_account_id acct_id
568: FROM ce_cashpool_sub_accts
569: WHERE cashpool_id = p_cashpool_id
570: AND type = 'POOL'
571: AND fund_conc_account_id is not null)
572: order by balance_date asc;

Line 601: FROM ce_cashpool_sub_accts

597: nvl(sum(a.AVAILABLE_BALANCE),0)
598: FROM CE_BANK_ACCT_BALANCES a --bug 4696629
599: WHERE a.bank_account_id IN
600: (SELECT account_id acct_id
601: FROM ce_cashpool_sub_accts
602: WHERE cashpool_id = p_cashpool_id
603: AND type in ('CONC','ACCT')
604: UNION
605: SELECT nvl(conc_account_id, inv_conc_account_id) acct_id

Line 606: FROM ce_cashpool_sub_accts

602: WHERE cashpool_id = p_cashpool_id
603: AND type in ('CONC','ACCT')
604: UNION
605: SELECT nvl(conc_account_id, inv_conc_account_id) acct_id
606: FROM ce_cashpool_sub_accts
607: WHERE cashpool_id = p_cashpool_id
608: AND type = 'POOL'
609: AND nvl(conc_account_id, inv_conc_account_id) is not null
610: UNION

Line 612: FROM ce_cashpool_sub_accts

608: AND type = 'POOL'
609: AND nvl(conc_account_id, inv_conc_account_id) is not null
610: UNION
611: SELECT fund_conc_account_id acct_id
612: FROM ce_cashpool_sub_accts
613: WHERE cashpool_id = p_cashpool_id
614: AND type = 'POOL'
615: AND fund_conc_account_id is not null)
616: AND a.BALANCE_DATE = (

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