DBA Data[Home] [Help]

APPS.PJI_FM_PLAN_MAINT_PVT dependencies on PA_BUDGET_LINES

Line 3513: , PA_BUDGET_LINES bl

3509: , ver.WP_FLAG
3510: FROM
3511: PJI_FM_EXTR_PLNVER4 ver
3512: , pa_resource_asSIGNments ra
3513: , PA_BUDGET_LINES bl
3514: , pa_projects_all ppa
3515: , PA_PROJ_ELEM_VER_STRUCTURE pevs
3516: WHERE
3517: ra.resource_asSIGNment_id = bl.resource_asSIGNment_id

Line 4097: , PA_BUDGET_LINES bl

4093: , ver.time_phased_type_code
4094: FROM
4095: PJI_FM_EXTR_PLNVER4 ver
4096: , PA_RESOURCE_ASSIGNMENTS ra
4097: , PA_BUDGET_LINES bl
4098: , PA_PROJECTS_ALL ppa
4099: , PA_PROJ_ELEM_VER_STRUCTURE pevs
4100: WHERE
4101: ra.resource_asSIGNment_id = bl.resource_asSIGNment_id

Line 4942: FROM pa_budget_lines bl

4938: , 'E'
4939: , prd.end_date
4940: , TO_DATE(NULL)
4941: ) end_date
4942: FROM pa_budget_lines bl
4943: , pji_time_cal_period_v prd
4944: , PJI_FM_EXTR_PLNVER4 ver
4945: , pa_projects_all ppa
4946: ,PJI_ORG_EXTR_INFO inf

Line 5001: FROM PA_BUDGET_LINES bl,

4997: PJI_FM_EXTR_PLNVER4 ver
4998: SET rate_dangling_flag = 'Y'
4999: WHERE (project_id,plan_version_id) IN
5000: ( SELECT project_id,budget_version_id
5001: FROM PA_BUDGET_LINES bl,
5002: pji_time_cal_period_v prd,
5003: PJI_FM_AGGR_DLY_RATES rates
5004: WHERE rates.time_id=prd.cal_period_id
5005: AND bl.period_name = prd.name

Line 8327: , PA_BUDGET_LINES bl

8323: , ver.WP_FLAG
8324: FROM
8325: PJI_FM_EXTR_PLNVER4 ver
8326: , pa_resource_asSIGNments ra
8327: , PA_BUDGET_LINES bl
8328: , pa_projects_all ppa
8329: , PJI_ORG_EXTR_INFO oei
8330: , pji_pjp_rbs_header rhdr
8331: , pji_time_cal_period_v prd

Line 8636: , PA_BUDGET_LINES bl

8632: , ver.WP_FLAG
8633: FROM
8634: PJI_FM_EXTR_PLNVER4 ver
8635: , pa_resource_asSIGNments ra
8636: , PA_BUDGET_LINES bl
8637: , pa_projects_all ppa
8638: , pji_pjp_rbs_header rhdr
8639: , PJI_FM_AGGR_DLY_RATES rates
8640: , pji_fp_txn_accum_header hdr

Line 9491: , PA_BUDGET_LINES bl

9487: , ver.WP_FLAG
9488: FROM
9489: PJI_FM_EXTR_PLNVER4 ver
9490: , pa_resource_asSIGNments ra
9491: , PA_BUDGET_LINES bl
9492: , pa_projects_all ppa
9493: , PJI_ORG_EXTR_INFO oei
9494: , pji_time_cal_period_v prd
9495: , PJI_FM_AGGR_DLY_RATES rates

Line 9782: , PA_BUDGET_LINES bl

9778: , ver.WP_FLAG
9779: FROM
9780: PJI_FM_EXTR_PLNVER4 ver
9781: , pa_resource_asSIGNments ra
9782: , PA_BUDGET_LINES bl
9783: , pa_projects_all ppa
9784: , PJI_FM_AGGR_DLY_RATES rates
9785: , PA_PROJ_ELEM_VER_STRUCTURE pevs
9786: WHERE 1=1

Line 10454: , PA_BUDGET_LINES bl

10450: , ver.plan_type_code plan_type_code /* 4471527*/
10451: FROM
10452: PJI_FM_EXTR_PLNVER4 ver
10453: , PA_RESOURCE_ASSIGNMENTS ra
10454: , PA_BUDGET_LINES bl
10455: , PA_PROJECTS_ALL ppa
10456: , PA_PROJ_ELEM_VER_STRUCTURE pevs
10457: WHERE
10458: ra.resource_asSIGNment_id = bl.resource_asSIGNment_id