APPS.CE_CSH_FCST_POP dependencies on CE_FORECAST_ORGS_V

Line 735: FROM CE_FORECAST_ORGS_V

731: ELSIF ( CE_CASH_FCST.G_set_of_books_id IS NOT NULL AND
732: CE_CASH_FCST.G_set_of_books_id <> -1) THEN
733: where_clause := where_clause ||'
734: AND (src.org_id IS NULL OR src.org_id IN (SELECT DISTINCT(org_id)
735: FROM CE_FORECAST_ORGS_V
736: WHERE set_of_books_id = '||to_char(CE_CASH_FCST.G_set_of_books_id)||' )) ';
737: END IF;
738: END IF;
739:

Line 2846: FROM CE_FORECAST_ORGS_V

2842: AND conversion_rate = CE_CASH_FCST.G_forecast_row_id;
2843:
2844: CURSOR C_sob(p_org_id NUMBER) IS
2845: SELECT 1
2846: FROM CE_FORECAST_ORGS_V
2847: WHERE set_of_books_id = CE_CASH_FCST.G_set_of_books_id
2848: AND org_id = p_org_id;
2849:
2850: CURSOR C_rate(p_currency_code VARCHAR2) IS

Line 3811: FROM CE_FORECAST_ORGS_V

3807:
3808:
3809: CURSOR C_sob(p_org_id NUMBER) IS
3810: SELECT 1
3811: FROM CE_FORECAST_ORGS_V
3812: WHERE set_of_books_id = CE_CASH_FCST.G_set_of_books_id
3813: AND org_id = p_org_id;
3814:
3815: CURSOR C_rate(p_currency_code VARCHAR2) IS

Line 4936: FROM CE_FORECAST_ORGS_V

4932: AND conversion_rate = CE_CASH_FCST.G_forecast_row_id;
4933:
4934: CURSOR C_sob(p_org_id NUMBER) IS
4935: SELECT 1
4936: FROM CE_FORECAST_ORGS_V
4937: WHERE set_of_books_id = CE_CASH_FCST.G_set_of_books_id
4938: AND org_id = p_org_id;
4939:
4940: CURSOR C_rate(p_currency_code VARCHAR2) IS