APPS.PJI_FM_PLAN_MAINT_T_PVT dependencies on PA_RESOURCE_ASSIGNMENTS

Line 1784: , pa_resource_asSIGNments ra

1780: , ppa.carrying_out_organization_id project_organization_id
1781: , ver.plan_type_code plan_type_code /* 4471527 */
1782: FROM
1783: PA_BUDGET_LINES bl
1784: , pa_resource_asSIGNments ra
1785: , PJI_FM_EXTR_PLNVER3_T ver
1786: , pa_projects_all ppa
1787: , PA_PROJ_ELEM_VER_STRUCTURE pevs
1788: WHERE

Line 2540: , pa_resource_asSIGNments ra

2536: ,decode(ver.rate_dangling_flag,'Y',-1,1) rate2
2537: , ver.plan_type_code plan_type_code /* 4471527 */
2538: FROM
2539: PA_BUDGET_LINES bl
2540: , pa_resource_asSIGNments ra
2541: , PJI_FM_EXTR_PLNVER3_T ver
2542: , pa_projects_all ppa
2543: , PA_PROJ_ELEM_VER_STRUCTURE pevs
2544: , PJI_FM_AGGR_DLY_RATES_T rates

Line 2843: , pa_resource_asSIGNments ra

2839: ,decode(ver.rate_dangling_flag,'Y',-1,1) rate2
2840: , ver.plan_type_code plan_type_code /* 4471527 */
2841: FROM
2842: PA_BUDGET_LINES bl
2843: , pa_resource_asSIGNments ra
2844: , PJI_FM_EXTR_PLNVER3_T ver
2845: , pa_projects_all ppa
2846: , PA_PROJ_ELEM_VER_STRUCTURE pevs
2847: , PJI_FM_AGGR_DLY_RATES_T rates

Line 3584: , pa_resource_asSIGNments ra

3580: ,decode(ver.rate_dangling_flag,'Y',-1,1) rate2
3581: , ver.plan_type_code plan_type_code /* 4471527 */
3582: FROM
3583: PA_BUDGET_LINES bl
3584: , pa_resource_asSIGNments ra
3585: , PJI_FM_EXTR_PLNVER3_T ver
3586: , pa_projects_all ppa
3587: , PA_PROJ_ELEM_VER_STRUCTURE pevs
3588: , PJI_FM_AGGR_DLY_RATES_T rates

Line 3873: , pa_resource_asSIGNments ra

3869: ,decode(ver.rate_dangling_flag,'Y',-1,1) rate2
3870: , ver.plan_type_code plan_type_code /* 4471527 */
3871: FROM
3872: PA_BUDGET_LINES bl
3873: , pa_resource_asSIGNments ra
3874: , PJI_FM_EXTR_PLNVER3_T ver
3875: , pa_projects_all ppa
3876: , PA_PROJ_ELEM_VER_STRUCTURE pevs
3877: , PJI_FM_AGGR_DLY_RATES_T rates

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

5057:
5058:
5059: DELETE FROM PJI_FM_AGGR_DLY_RATES_T
5060: WHERE worker_id = g_worker_id;
5061: -- Removed pa_resource_assignments join and Added joins with pji_org_extr_info
5062: -- for bug 4149422
5063: -- SQL for getting rates for time phased budgets.
5064: PJI_UTILS.g_max_roll_days := 1500; /*5155692 */
5065:

Line 5156: FROM pa_resource_assignments ra

5152: , TO_DATE(NULL)
5153: ) end_date
5154: , l_gl1_mau mau1
5155: , l_gl2_mau mau2
5156: FROM pa_resource_assignments ra
5157: , PJI_FM_EXTR_PLNVER3_T ver
5158: , pa_projects_all ppa
5159: WHERE ra.budget_version_id = ver.plan_version_id
5160: AND ver.wp_flag = 'N'

Line 5184: FROM pa_resource_assignments ra,

5180: AND (sign(rates.rate)=-1 OR sign(rates.rate2) = -1)
5181: AND ver.time_phased_type_code IN ('P', 'G')
5182: UNION ALL
5183: SELECT project_id,budget_version_id
5184: FROM pa_resource_assignments ra,
5185: PJI_FM_AGGR_DLY_RATES_T rates
5186: WHERE rates.time_id= DECODE ( g_currency_conversion_rule
5187: , 'S'
5188: , TO_NUMBER(to_CHAR(ra.planning_start_date, 'J'))

Line 7137: , PA_RESOURCE_ASSIGNMENTS ra

7133: , ppa.carrying_out_organization_id project_organization_id
7134: , ver.plan_type_code plan_type_code /* 4471527 */
7135: FROM
7136: PA_BUDGET_LINES bl
7137: , PA_RESOURCE_ASSIGNMENTS ra
7138: , PJI_FM_EXTR_PLNVER3_T ver
7139: , PA_PROJECTS_ALL ppa
7140: , PA_PROJ_ELEM_VER_STRUCTURE pevs
7141: WHERE