176: -- then select the Project level override
177: SELECT irs.ind_rate_sch_id
178: INTO x_burden_sch_id
179: FROM pa_tasks t,
180: pa_ind_rate_schedules irs
181: WHERE t.task_id = p_task_id
182: AND t.project_id = p_project_id
183: AND t.task_id = irs.task_id
184: AND irs.cost_ovr_sch_flag = 'Y';
188: -- check the project level override
189: BEGIN
190: SELECT irs.ind_rate_sch_id
191: INTO x_burden_sch_id
192: FROM pa_ind_rate_schedules irs
193: ,pa_projects_all pp
194: WHERE pp.project_id = p_project_id
195: AND irs.project_id = pp.project_id
196: AND irs.cost_ovr_sch_flag = 'Y' ;
217: BEGIN
218:
219: SELECT irs.ind_rate_sch_id
220: INTO x_burden_sch_id
221: FROM pa_ind_rate_schedules irs
222: ,pa_projects_all pp
223: WHERE pp.project_id = p_project_id
224: AND irs.project_id = pp.project_id
225: AND irs.cost_ovr_sch_flag = 'Y' ;