APPS.PJI_FM_PLAN_MAINT_T_PVT dependencies on PA_RESOURCE_ASSIGNMENTS

Line 1826: , pa_resource_asSIGNments ra

1822: , ppa.carrying_out_organization_id project_organization_id
1823: , ver.plan_type_code plan_type_code /* 4471527 */
1824: FROM
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

Line 2607: , pa_resource_asSIGNments ra

2603: ,decode(ver.rate_dangling_flag,'Y',-1,1) rate2
2604: , ver.plan_type_code plan_type_code /* 4471527 */
2605: FROM
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

Line 2913: , pa_resource_asSIGNments ra

2909: ,decode(ver.rate_dangling_flag,'Y',-1,1) rate2
2910: , ver.plan_type_code plan_type_code /* 4471527 */
2911: FROM
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

Line 3668: , pa_resource_asSIGNments ra

3664: ,decode(ver.rate_dangling_flag,'Y',-1,1) rate2
3665: , ver.plan_type_code plan_type_code /* 4471527 */
3666: FROM
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

Line 3960: , pa_resource_asSIGNments ra

3956: ,decode(ver.rate_dangling_flag,'Y',-1,1) rate2
3957: , ver.plan_type_code plan_type_code /* 4471527 */
3958: FROM
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

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

5157:
5158:
5159: DELETE FROM PJI_FM_AGGR_DLY_RATES_T
5160: WHERE worker_id = g_worker_id;
5161: -- Removed pa_resource_assignments join and Added joins with pji_org_extr_info
5162: -- for bug 4149422
5163: -- SQL for getting rates for time phased budgets.
5164: PJI_UTILS.g_max_roll_days := 1500; /*5155692 */
5165:

Line 5257: FROM pa_resource_assignments ra

5253: , TO_DATE(NULL)
5254: ) end_date
5255: , l_gl1_mau mau1
5256: , l_gl2_mau mau2
5257: FROM pa_resource_assignments ra
5258: , PJI_FM_EXTR_PLNVER3_T ver
5259: , pa_projects_all ppa
5260: WHERE ra.budget_version_id = ver.plan_version_id
5261: AND ver.wp_flag = 'N'

Line 5285: FROM pa_resource_assignments ra,

5281: AND (sign(rates.rate)=-1 OR sign(rates.rate2) = -1)
5282: AND ver.time_phased_type_code IN ('P', 'G')
5283: UNION ALL
5284: SELECT project_id,budget_version_id
5285: FROM pa_resource_assignments ra,
5286: PJI_FM_AGGR_DLY_RATES_T rates
5287: WHERE rates.time_id= DECODE ( g_currency_conversion_rule
5288: , 'S'
5289: , TO_NUMBER(to_CHAR(ra.planning_start_date, 'J'))

Line 7270: , PA_RESOURCE_ASSIGNMENTS ra

7266: , ppa.carrying_out_organization_id project_organization_id
7267: , ver.plan_type_code plan_type_code /* 4471527 */
7268: FROM
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