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
1830: WHERE
1831: ra.resource_asSIGNment_id = bl.resource_asSIGNment_id
1832: AND ra.project_id = ver.PROJECT_ID
1833: AND ra.budget_version_id = ver.plan_version_id
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
2611: , PJI_FM_AGGR_DLY_RATES_T rates
2612: , pji_time_cal_period_v prd
2613: , PJI_ORG_EXTR_INFO oei
2614: , pji_fp_txn_accum_header hdr
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
2917: , PJI_FM_AGGR_DLY_RATES_T rates
2918: -- , pji_time_cal_period prd
2919: -- , PJI_ORG_EXTR_INFO oei
2920: , pji_fp_txn_accum_header hdr
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
3672: , PJI_FM_AGGR_DLY_RATES_T rates
3673: , pji_time_cal_period_v prd
3674: , PJI_ORG_EXTR_INFO oei
3675: WHERE 1=1
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
3964: , PJI_FM_AGGR_DLY_RATES_T rates
3965: WHERE 1=1
3966: AND ra.resource_asSIGNment_id = bl.resource_asSIGNment_id
3967: AND ra.project_id = ver.PROJECT_ID
4948: FROM
4949: PJI_FM_EXTR_PLAN_LINES bl
4950: , PJI_FM_EXTR_PLNVER3_T ver
4951: , pa_projects_all ppa
4952: , PA_PROJ_ELEM_VER_STRUCTURE pevs
4953: , pji_fp_rmap_fpr_update_t rwid
4954: WHERE 1=1
4955: AND bl.project_id = ver.project_id
4956: AND bl.plan_version_id = ver.plan_version_id
7199: FROM
7200: PJI_FM_EXTR_PLAN_LINES bl
7201: , PJI_FM_EXTR_PLNVER3_T ver
7202: , PA_PROJECTS_ALL ppa
7203: , PA_PROJ_ELEM_VER_STRUCTURE pevs
7204: , pji_fp_rmap_fpr_update_t rwid
7205: WHERE 1=1
7206: AND bl.project_id = ver.project_id
7207: AND bl.plan_version_id = ver.plan_version_id
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
7274: WHERE
7275: ra.resource_asSIGNment_id = bl.resource_asSIGNment_id
7276: AND ra.project_id = ver.PROJECT_ID
7277: AND ra.budget_version_id = ver.plan_version_id