APPS.PJI_FM_PLAN_MAINT_T_PVT dependencies on PA_BUDGET_LINES

Line 1783: PA_BUDGET_LINES bl

1779: , ppa.org_id project_org_id
1780: , ppa.carrying_out_organization_id project_organization_id
1781: , ver.plan_type_code plan_type_code /* 4471527 */
1782: FROM
1783: PA_BUDGET_LINES bl
1784: , pa_resource_asSIGNments ra
1785: , PJI_FM_EXTR_PLNVER3_T ver
1786: , pa_projects_all ppa
1787: , PA_PROJ_ELEM_VER_STRUCTURE pevs

Line 2539: PA_BUDGET_LINES bl

2535: ,decode(ver.rate_dangling_flag,'Y',-1,1) rate
2536: ,decode(ver.rate_dangling_flag,'Y',-1,1) rate2
2537: , ver.plan_type_code plan_type_code /* 4471527 */
2538: FROM
2539: PA_BUDGET_LINES bl
2540: , pa_resource_asSIGNments ra
2541: , PJI_FM_EXTR_PLNVER3_T ver
2542: , pa_projects_all ppa
2543: , PA_PROJ_ELEM_VER_STRUCTURE pevs

Line 2842: PA_BUDGET_LINES bl

2838: ,decode(ver.rate_dangling_flag,'Y',-1,1) rate
2839: ,decode(ver.rate_dangling_flag,'Y',-1,1) rate2
2840: , ver.plan_type_code plan_type_code /* 4471527 */
2841: FROM
2842: PA_BUDGET_LINES bl
2843: , pa_resource_asSIGNments ra
2844: , PJI_FM_EXTR_PLNVER3_T ver
2845: , pa_projects_all ppa
2846: , PA_PROJ_ELEM_VER_STRUCTURE pevs

Line 3583: PA_BUDGET_LINES bl

3579: ,decode(ver.rate_dangling_flag,'Y',-1,1) rate
3580: ,decode(ver.rate_dangling_flag,'Y',-1,1) rate2
3581: , ver.plan_type_code plan_type_code /* 4471527 */
3582: FROM
3583: PA_BUDGET_LINES bl
3584: , pa_resource_asSIGNments ra
3585: , PJI_FM_EXTR_PLNVER3_T ver
3586: , pa_projects_all ppa
3587: , PA_PROJ_ELEM_VER_STRUCTURE pevs

Line 3872: PA_BUDGET_LINES bl

3868: ,decode(ver.rate_dangling_flag,'Y',-1,1) rate
3869: ,decode(ver.rate_dangling_flag,'Y',-1,1) rate2
3870: , ver.plan_type_code plan_type_code /* 4471527 */
3871: FROM
3872: PA_BUDGET_LINES bl
3873: , pa_resource_asSIGNments ra
3874: , PJI_FM_EXTR_PLNVER3_T ver
3875: , pa_projects_all ppa
3876: , PA_PROJ_ELEM_VER_STRUCTURE pevs

Line 5114: FROM pa_budget_lines bl

5110: , TO_DATE(NULL)
5111: ) end_date
5112: , l_gl1_mau mau1
5113: , l_gl2_mau mau2
5114: FROM pa_budget_lines bl
5115: , pa_budget_versions bv -- added for bug 5842896
5116: , pji_time_cal_period_v prd
5117: , PJI_FM_EXTR_PLNVER3_T ver
5118: , pa_projects_all ppa

Line 5175: FROM PA_BUDGET_LINES bl,

5171: UPDATE PJI_FM_EXTR_PLNVER3_T ver
5172: SET rate_dangling_flag = 'Y'
5173: WHERE (project_id,plan_version_id) IN
5174: ( SELECT project_id,budget_version_id
5175: FROM PA_BUDGET_LINES bl,
5176: pji_time_cal_period_v prd,
5177: PJI_FM_AGGR_DLY_RATES_T rates
5178: WHERE rates.time_id=prd.cal_period_id
5179: AND bl.period_name = prd.name

Line 7136: PA_BUDGET_LINES bl

7132: , ppa.org_id project_org_id
7133: , ppa.carrying_out_organization_id project_organization_id
7134: , ver.plan_type_code plan_type_code /* 4471527 */
7135: FROM
7136: PA_BUDGET_LINES bl
7137: , PA_RESOURCE_ASSIGNMENTS ra
7138: , PJI_FM_EXTR_PLNVER3_T ver
7139: , PA_PROJECTS_ALL ppa
7140: , PA_PROJ_ELEM_VER_STRUCTURE pevs