DBA Data[Home] [Help]

APPS.PA_COST1 dependencies on PA_IND_RATE_SCHEDULES

Line 180: pa_ind_rate_schedules irs

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';

Line 192: FROM pa_ind_rate_schedules irs

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' ;

Line 221: FROM pa_ind_rate_schedules irs

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' ;