APPS.CE_CP_PRIORDAY dependencies on CE_CP_WORKSHEET_LINES

Line 416: CE_CP_WORKSHEET_LINES WSL

412: SELECT -sum(decode(AP.currency_code, l_currency_code,
413: AP.amount, AP.base_amount))
414: INTO tmp_balance
415: FROM CE_AP_FC_PAYMENTS_V AP,
416: CE_CP_WORKSHEET_LINES WSL
417: WHERE WSL.worksheet_header_id = l_ws_id
418: AND WSL.source_type = 'APP'
419: AND WSL.include_flag = 'Y'
420: AND WSL.cut_off_days is not null

Line 466: CE_CP_WORKSHEET_LINES WSL

462: SELECT sum(decode(ARR.currency_code, l_currency_code,
463: ARR.amount, ARR.base_amount))
464: INTO tmp_balance
465: FROM CE_AR_FC_RECEIPTS_V ARR,
466: CE_CP_WORKSHEET_LINES WSL
467: WHERE WSL.worksheet_header_id = l_ws_id
468: AND WSL.source_type = 'ARR'
469: AND WSL.include_flag = 'Y'
470: AND WSL.cut_off_days is not null

Line 511: FROM CE_CP_WORKSHEET_LINES WSL,

507: tmp_balance := 0;
508:
509: SELECT sum(XTR.amount)
510: INTO tmp_balance
511: FROM CE_CP_WORKSHEET_LINES WSL,
512: CE_XTR_CASHFLOWS_V XTR
513: WHERE WSL.worksheet_header_id = l_ws_id
514: AND WSL.source_type = 'XTI'
515: AND WSL.include_flag = 'Y'

Line 558: FROM CE_CP_WORKSHEET_LINES WSL,

554: tmp_balance := 0;
555:
556: SELECT sum(XTR.amount)
557: INTO tmp_balance
558: FROM CE_CP_WORKSHEET_LINES WSL,
559: CE_XTR_CASHFLOWS_V XTR
560: WHERE WSL.worksheet_header_id = l_ws_id
561: AND WSL.source_type = 'XTO'
562: AND WSL.include_flag = 'Y'

Line 609: CE_CP_WORKSHEET_LINES WSL

605: SELECT -sum(decode(CEI.currency_code, l_currency_code,
606: CEI.cashflow_amount, CEI.base_amount))
607: INTO tmp_balance
608: FROM CE_CE_CASHFLOWS_V CEI,
609: CE_CP_WORKSHEET_LINES WSL
610: WHERE WSL.worksheet_header_id = l_ws_id
611: AND WSL.source_type = 'CEI'
612: AND WSL.include_flag = 'Y'
613: AND WSL.cut_off_days is not null

Line 665: CE_CP_WORKSHEET_LINES WSL

661: SELECT -sum(decode(CEO.currency_code, l_currency_code,
662: CEO.cashflow_amount, CEO.base_amount))
663: INTO tmp_balance
664: FROM CE_CE_CASHFLOWS_V CEO,
665: CE_CP_WORKSHEET_LINES WSL
666: WHERE WSL.worksheet_header_id = l_ws_id
667: AND WSL.source_type = 'CEO'
668: AND WSL.include_flag = 'Y'
669: AND WSL.cut_off_days is not null