DBA Data[Home] [Help]

APPS.PA_COST1 dependencies on PA_PROJECTS_ALL

Line 193: ,pa_projects_all pp

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' ;
197: EXCEPTION

Line 222: ,pa_projects_all pp

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' ;
226: EXCEPTION

Line 230: FROM pa_projects_all pp

226: EXCEPTION
227: WHEN NO_DATA_FOUND Then
228: SELECT pp.cost_ind_rate_sch_id
229: INTO x_burden_sch_id
230: FROM pa_projects_all pp
231: WHERE pp.project_id = p_project_id ;
232:
233: END;
234:

Line 475: , pa_projects_all proj

471:
472: cursor cur_burden_flag IS
473: SELECT NVL(burden_cost_flag,'N')
474: FROM pa_project_types_all typ
475: , pa_projects_all proj
476: WHERE typ.project_type = P_project_type
477: AND proj.project_type = typ.project_type
478: AND proj.project_id = p_project_id
479: AND proj.org_id = typ.org_id; --Bug#5903720

Line 2364: ,pa_projects_all pp

2360: ,'User',cur.PROJFUNC_COST_EXCHANGE_RATE
2361: , null),bl.projfunc_cost_exchange_rate) projfunc_exchange_rate
2362: from pa_budget_versions bv
2363: ,pa_proj_fp_options fpo
2364: ,pa_projects_all pp
2365: ,pa_fp_txn_currencies cur
2366: ,pa_budget_lines bl
2367: where bv.project_id = pp.project_id
2368: and fpo.project_id = pp.project_id