DBA Data[Home] [Help]

APPS.PA_PROJECT_UTILS dependencies on PA_FORECASTING_OPTIONS_ALL

Line 850: FROM pa_projects_all ppa, pa_forecasting_options_all pfoa

846: -- Bug 5750591: Cursor to check whether the project_id passed is PJR Unassigned time project
847: l_temp_char VARCHAR2(1);
848: CURSOR c_is_unassigned_time_proj(l_project_id IN NUMBER) IS
849: SELECT 'Y'
850: FROM pa_projects_all ppa, pa_forecasting_options_all pfoa
851: WHERE ppa.project_id = l_project_id
852: AND ppa.org_id = pfoa.org_id
853: AND (pfoa.bill_unassign_proj_id = ppa.project_id OR pfoa.nonbill_unassign_proj_id = ppa.project_id);
854: