APPS.PJI_FM_PLAN_MAINT_T_PVT dependencies on PA_BUDGET_LINES

Line 1825: PA_BUDGET_LINES bl

1821: , ppa.org_id project_org_id
1822: , ppa.carrying_out_organization_id project_organization_id
1823: , ver.plan_type_code plan_type_code /* 4471527 */
1824: FROM
1825: PA_BUDGET_LINES bl
1826: , pa_resource_asSIGNments ra
1827: , PJI_FM_EXTR_PLNVER3_T ver
1828: , pa_projects_all ppa
1829: , PA_PROJ_ELEM_VER_STRUCTURE pevs

Line 2606: PA_BUDGET_LINES bl

2602: ,decode(ver.rate_dangling_flag,'Y',-1,1) rate
2603: ,decode(ver.rate_dangling_flag,'Y',-1,1) rate2
2604: , ver.plan_type_code plan_type_code /* 4471527 */
2605: FROM
2606: PA_BUDGET_LINES bl
2607: , pa_resource_asSIGNments ra
2608: , PJI_FM_EXTR_PLNVER3_T ver
2609: , pa_projects_all ppa
2610: , PA_PROJ_ELEM_VER_STRUCTURE pevs

Line 2912: PA_BUDGET_LINES bl

2908: ,decode(ver.rate_dangling_flag,'Y',-1,1) rate
2909: ,decode(ver.rate_dangling_flag,'Y',-1,1) rate2
2910: , ver.plan_type_code plan_type_code /* 4471527 */
2911: FROM
2912: PA_BUDGET_LINES bl
2913: , pa_resource_asSIGNments ra
2914: , PJI_FM_EXTR_PLNVER3_T ver
2915: , pa_projects_all ppa
2916: , PA_PROJ_ELEM_VER_STRUCTURE pevs

Line 3667: PA_BUDGET_LINES bl

3663: ,decode(ver.rate_dangling_flag,'Y',-1,1) rate
3664: ,decode(ver.rate_dangling_flag,'Y',-1,1) rate2
3665: , ver.plan_type_code plan_type_code /* 4471527 */
3666: FROM
3667: PA_BUDGET_LINES bl
3668: , pa_resource_asSIGNments ra
3669: , PJI_FM_EXTR_PLNVER3_T ver
3670: , pa_projects_all ppa
3671: , PA_PROJ_ELEM_VER_STRUCTURE pevs

Line 3959: PA_BUDGET_LINES bl

3955: ,decode(ver.rate_dangling_flag,'Y',-1,1) rate
3956: ,decode(ver.rate_dangling_flag,'Y',-1,1) rate2
3957: , ver.plan_type_code plan_type_code /* 4471527 */
3958: FROM
3959: PA_BUDGET_LINES bl
3960: , pa_resource_asSIGNments ra
3961: , PJI_FM_EXTR_PLNVER3_T ver
3962: , pa_projects_all ppa
3963: , PA_PROJ_ELEM_VER_STRUCTURE pevs

Line 5214: FROM pa_budget_lines bl

5210: , TO_DATE(NULL)
5211: ) end_date
5212: , l_gl1_mau mau1
5213: , l_gl2_mau mau2
5214: FROM pa_budget_lines bl
5215: , pa_budget_versions bv -- added for bug 5842896
5216: , pji_time_cal_period_v prd
5217: , PJI_FM_EXTR_PLNVER3_T ver
5218: , pa_projects_all ppa

Line 5276: FROM PA_BUDGET_LINES bl,

5272: UPDATE PJI_FM_EXTR_PLNVER3_T ver
5273: SET rate_dangling_flag = 'Y'
5274: WHERE (project_id,plan_version_id) IN
5275: ( SELECT project_id,budget_version_id
5276: FROM PA_BUDGET_LINES bl,
5277: pji_time_cal_period_v prd,
5278: PJI_FM_AGGR_DLY_RATES_T rates
5279: WHERE rates.time_id=prd.cal_period_id
5280: AND bl.period_name = prd.name

Line 7269: PA_BUDGET_LINES bl

7265: , ppa.org_id project_org_id
7266: , ppa.carrying_out_organization_id project_organization_id
7267: , ver.plan_type_code plan_type_code /* 4471527 */
7268: FROM
7269: PA_BUDGET_LINES bl
7270: , PA_RESOURCE_ASSIGNMENTS ra
7271: , PJI_FM_EXTR_PLNVER3_T ver
7272: , PA_PROJECTS_ALL ppa
7273: , PA_PROJ_ELEM_VER_STRUCTURE pevs