APPS.PA_FORECASTITEM_PVT dependencies on PA_SCHEDULES

Line 14024: FROM pa_schedules psch

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

Line 14049: FROM pa_schedules psch

14045: OR ( p_start_date IS NULL AND p_end_date IS NOT NULL AND trunc(frcst_itms.item_date) <= trunc(p_end_date))
14046: OR ( p_start_date IS NULL AND p_end_date IS NULL ) )
14047: )
14048: OR EXISTS ( SELECT NULL
14049: FROM pa_schedules psch
14050: WHERE proj_asgn.assignment_id = psch.assignment_id
14051: AND psch.forecast_txn_generated_flag = 'N')
14052: ); */
14053: -- Bug# 10071003 - Added - Start

Line 14072: FROM pa_schedules psch

14068: BETWEEN trunc(NVL(p_start_date,trunc(frcst_itms.item_date)))
14069: AND trunc(NVL(p_end_date,trunc(frcst_itms.item_date)))
14070: )
14071: OR EXISTS ( SELECT NULL
14072: FROM pa_schedules psch
14073: WHERE proj_asgn.assignment_id = psch.assignment_id
14074: AND psch.forecast_txn_generated_flag = 'N')
14075: )
14076: UNION

Line 14099: FROM pa_schedules psch

14095: BETWEEN trunc(NVL(p_start_date,trunc(frcst_itms.item_date)))
14096: AND trunc(NVL(p_end_date,trunc(frcst_itms.item_date)))
14097: )
14098: OR EXISTS ( SELECT NULL
14099: FROM pa_schedules psch
14100: WHERE proj_asgn.assignment_id = psch.assignment_id
14101: AND psch.forecast_txn_generated_flag = 'N')
14102: );
14103: -- Bug# 10071003 - Added - End