APPS.CE_CSH_FCST_POP dependencies on CE_FORECAST_ORGS_V

Line 796: FROM CE_FORECAST_ORGS_V

792: ELSIF ( CE_CASH_FCST.G_set_of_books_id IS NOT NULL AND
793: CE_CASH_FCST.G_set_of_books_id <> -1) THEN
794: where_clause := where_clause ||'
795: AND (src.org_id IS NULL OR src.org_id IN (SELECT DISTINCT(org_id)
796: FROM CE_FORECAST_ORGS_V
797: WHERE set_of_books_id = '||to_char(CE_CASH_FCST.G_set_of_books_id)||' )) ';
798: END IF;
799: END IF;
800:

Line 2922: FROM CE_FORECAST_ORGS_V

2918: AND conversion_rate = CE_CASH_FCST.G_forecast_row_id;
2919:
2920: CURSOR C_sob(p_org_id NUMBER) IS
2921: SELECT 1
2922: FROM CE_FORECAST_ORGS_V
2923: WHERE set_of_books_id = CE_CASH_FCST.G_set_of_books_id
2924: AND org_id = p_org_id;
2925:
2926: CURSOR C_rate(p_currency_code VARCHAR2) IS

Line 3887: FROM CE_FORECAST_ORGS_V

3883:
3884:
3885: CURSOR C_sob(p_org_id NUMBER) IS
3886: SELECT 1
3887: FROM CE_FORECAST_ORGS_V
3888: WHERE set_of_books_id = CE_CASH_FCST.G_set_of_books_id
3889: AND org_id = p_org_id;
3890:
3891: CURSOR C_rate(p_currency_code VARCHAR2) IS

Line 5011: FROM CE_FORECAST_ORGS_V

5007: AND conversion_rate = CE_CASH_FCST.G_forecast_row_id;
5008:
5009: CURSOR C_sob(p_org_id NUMBER) IS
5010: SELECT 1
5011: FROM CE_FORECAST_ORGS_V
5012: WHERE set_of_books_id = CE_CASH_FCST.G_set_of_books_id
5013: AND org_id = p_org_id;
5014:
5015: CURSOR C_rate(p_currency_code VARCHAR2) IS