APPS.PA_FORECASTITEM_PVT dependencies on PA_SCHEDULES

Line 14021: FROM pa_schedules psch

14017: FROM pa_project_assignments proj_asgn
14018: WHERE proj_asgn.expenditure_organization_id = p_orgz_id
14019: AND proj_asgn.template_flag = 'N'
14020: AND EXISTS ( SELECT NULL
14021: FROM pa_schedules psch
14022: WHERE proj_asgn.assignment_id =
14023: psch.assignment_id
14024: AND psch.forecast_txn_generated_flag = 'N');
14025: */

Line 14045: FROM pa_schedules psch

14041: OR ( p_start_date IS NULL AND p_end_date IS NOT NULL AND trunc(frcst_itms.item_date) <= trunc(p_end_date))
14042: OR ( p_start_date IS NULL AND p_end_date IS NULL ) )
14043: )
14044: OR EXISTS ( SELECT NULL
14045: FROM pa_schedules psch
14046: WHERE proj_asgn.assignment_id = psch.assignment_id
14047: AND psch.forecast_txn_generated_flag = 'N')
14048: );
14049: