DBA Data[Home] [Help]

APPS.PJI_FM_PLAN_MAINT_PVT dependencies on PA_BUDGET_LINES

Line 4665: , PA_BUDGET_LINES bl

4661: , ver.WP_FLAG
4662: FROM
4663: PJI_FM_EXTR_PLNVER4 ver
4664: , pa_resource_asSIGNments ra
4665: , PA_BUDGET_LINES bl
4666: , pa_projects_all ppa
4667: , PA_PROJ_ELEM_VER_STRUCTURE pevs
4668: WHERE
4669: ra.resource_asSIGNment_id = bl.resource_asSIGNment_id

Line 5268: , PA_BUDGET_LINES bl

5264: , ver.time_phased_type_code
5265: FROM
5266: PJI_FM_EXTR_PLNVER4 ver
5267: , PA_RESOURCE_ASSIGNMENTS ra
5268: , PA_BUDGET_LINES bl
5269: , PA_PROJECTS_ALL ppa
5270: , PA_PROJ_ELEM_VER_STRUCTURE pevs
5271: WHERE
5272: ra.resource_asSIGNment_id = bl.resource_asSIGNment_id

Line 6133: FROM pa_budget_lines bl

6129: , 'E'
6130: , prd.end_date
6131: , TO_DATE(NULL)
6132: ) end_date
6133: FROM pa_budget_lines bl
6134: , pji_time_cal_period_v prd
6135: , PJI_FM_EXTR_PLNVER4 ver
6136: , pa_projects_all ppa
6137: ,PJI_ORG_EXTR_INFO inf

Line 6192: FROM PA_BUDGET_LINES bl,

6188: PJI_FM_EXTR_PLNVER4 ver
6189: SET rate_dangling_flag = 'Y'
6190: WHERE (project_id,plan_version_id) IN
6191: ( SELECT project_id,budget_version_id
6192: FROM PA_BUDGET_LINES bl,
6193: pji_time_cal_period_v prd,
6194: PJI_FM_AGGR_DLY_RATES rates
6195: WHERE rates.time_id=prd.cal_period_id
6196: AND bl.period_name = prd.name

Line 9610: , PA_BUDGET_LINES bl

9606: , ver.WP_FLAG
9607: FROM
9608: PJI_FM_EXTR_PLNVER4 ver
9609: , pa_resource_asSIGNments ra
9610: , PA_BUDGET_LINES bl
9611: , pa_projects_all ppa
9612: , PJI_ORG_EXTR_INFO oei
9613: , pji_pjp_rbs_header rhdr
9614: , pji_time_cal_period_v prd

Line 9922: , PA_BUDGET_LINES bl

9918: , ver.WP_FLAG
9919: FROM
9920: PJI_FM_EXTR_PLNVER4 ver
9921: , pa_resource_asSIGNments ra
9922: , PA_BUDGET_LINES bl
9923: , pa_projects_all ppa
9924: , pji_pjp_rbs_header rhdr
9925: , PJI_FM_AGGR_DLY_RATES rates
9926: , pji_fp_txn_accum_header hdr

Line 10799: , PA_BUDGET_LINES bl

10795: , ver.WP_FLAG
10796: FROM
10797: PJI_FM_EXTR_PLNVER4 ver
10798: , pa_resource_asSIGNments ra
10799: , PA_BUDGET_LINES bl
10800: , pa_projects_all ppa
10801: , PJI_ORG_EXTR_INFO oei
10802: , pji_time_cal_period_v prd
10803: , PJI_FM_AGGR_DLY_RATES rates

Line 11093: , PA_BUDGET_LINES bl

11089: , ver.WP_FLAG
11090: FROM
11091: PJI_FM_EXTR_PLNVER4 ver
11092: , pa_resource_asSIGNments ra
11093: , PA_BUDGET_LINES bl
11094: , pa_projects_all ppa
11095: , PJI_FM_AGGR_DLY_RATES rates
11096: , PA_PROJ_ELEM_VER_STRUCTURE pevs
11097: WHERE 1=1

Line 11786: , PA_BUDGET_LINES bl

11782: , ver.plan_type_code plan_type_code /* 4471527*/
11783: FROM
11784: PJI_FM_EXTR_PLNVER4 ver
11785: , PA_RESOURCE_ASSIGNMENTS ra
11786: , PA_BUDGET_LINES bl
11787: , PA_PROJECTS_ALL ppa
11788: , PA_PROJ_ELEM_VER_STRUCTURE pevs
11789: WHERE
11790: ra.resource_asSIGNment_id = bl.resource_asSIGNment_id