APPS.PJI_FM_PLAN_MAINT_PVT dependencies on PA_RESOURCE_ASSIGNMENTS

Line 4664: , pa_resource_asSIGNments ra

4660: , ver.plan_type_code /*4471527 */
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

Line 5267: , PA_RESOURCE_ASSIGNMENTS ra

5263: , ver.plan_type_code
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

Line 6082: -- Removed pa_resource_assignments join and Added joins with pji_org_extr_info

6078:
6079: print_time('........GET_GLOBAL_EXCHANGE_RATES: # rows deleted is: ' || SQL%ROWCOUNT );
6080:
6081: PJI_UTILS.g_max_roll_days := 1500; /*5155692 */
6082: -- Removed pa_resource_assignments join and Added joins with pji_org_extr_info
6083: -- for bug 4149422
6084: -- SQL for getting rates for time phased budgets.
6085: INSERT INTO PJI_FM_AGGR_DLY_RATES (
6086: WORKER_ID ,

Line 6173: FROM pa_resource_assignments ra

6169: , 'E'
6170: , ra.planning_end_date
6171: , TO_DATE(NULL)
6172: ) end_date
6173: FROM pa_resource_assignments ra
6174: , PJI_FM_EXTR_PLNVER4 ver
6175: , pa_projects_all ppa
6176: WHERE 1=1
6177: AND ra.budget_version_id = ver.plan_version_id

Line 6202: FROM pa_resource_assignments ra,

6198: AND ver.time_phased_type_code IN ('P', 'G')
6199: AND rates.worker_id=g_worker_id /* Added for bug 4083581 */
6200: UNION ALL
6201: SELECT project_id,budget_version_id
6202: FROM pa_resource_assignments ra,
6203: PJI_FM_AGGR_DLY_RATES rates
6204: WHERE rates.time_id= DECODE ( g_currency_conversion_rule
6205: , 'S'
6206: , TO_NUMBER(to_CHAR(ra.planning_start_date, 'J'))

Line 9609: , pa_resource_asSIGNments ra

9605: ,ver.plan_type_code plan_type_code /*4471527 */
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

Line 9921: , pa_resource_asSIGNments ra

9917: , ver.plan_type_code plan_type_code /*4471527 */
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

Line 10798: , pa_resource_asSIGNments ra

10794: , ver.plan_type_code plan_type_code /*4471527 */
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

Line 11092: , pa_resource_asSIGNments ra

11088: , ver.plan_type_code plan_type_code /*4471527 */
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

Line 11785: , PA_RESOURCE_ASSIGNMENTS ra

11781: , ppa.carrying_out_organization_id project_organization_id
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