APPS.PA_COST1 dependencies on PA_PROJECTS

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 1319: from pa_projects

1315:
1316: -- get the project number and task number details
1317: select segment1
1318: into pa_pay_util.g_project_number
1319: from pa_projects
1320: where project_id = p_project_id;
1321:
1322: l_stage := 'RBC: Project Number: ' || pa_pay_util.g_project_number;
1323: print_msg(l_debug_flag,l_stage);

Line 2676: ,pa_projects_all pp

2672: ,'User',cur.PROJFUNC_COST_EXCHANGE_RATE
2673: , null),bl.projfunc_cost_exchange_rate) projfunc_exchange_rate
2674: from pa_budget_versions bv
2675: ,pa_proj_fp_options fpo
2676: ,pa_projects_all pp
2677: ,pa_fp_txn_currencies cur
2678: ,pa_budget_lines bl
2679: where bv.project_id = pp.project_id
2680: and fpo.project_id = pp.project_id