APPS.PJI_FM_PLAN_MAINT_PVT dependencies on PA_RESOURCE_ASSIGNMENTS

Line 3512: , pa_resource_asSIGNments ra

3508: , ver.plan_type_code /*4471527 */
3509: , ver.WP_FLAG
3510: FROM
3511: PJI_FM_EXTR_PLNVER4 ver
3512: , pa_resource_asSIGNments ra
3513: , PA_BUDGET_LINES bl
3514: , pa_projects_all ppa
3515: , PA_PROJ_ELEM_VER_STRUCTURE pevs
3516: WHERE

Line 4096: , PA_RESOURCE_ASSIGNMENTS ra

4092: , ver.plan_type_code
4093: , ver.time_phased_type_code
4094: FROM
4095: PJI_FM_EXTR_PLNVER4 ver
4096: , PA_RESOURCE_ASSIGNMENTS ra
4097: , PA_BUDGET_LINES bl
4098: , PA_PROJECTS_ALL ppa
4099: , PA_PROJ_ELEM_VER_STRUCTURE pevs
4100: WHERE

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

4887:
4888: print_time('........GET_GLOBAL_EXCHANGE_RATES: # rows deleted is: ' || SQL%ROWCOUNT );
4889:
4890: PJI_UTILS.g_max_roll_days := 1500; /*5155692 */
4891: -- Removed pa_resource_assignments join and Added joins with pji_org_extr_info
4892: -- for bug 4149422
4893: -- SQL for getting rates for time phased budgets.
4894: INSERT INTO PJI_FM_AGGR_DLY_RATES (
4895: WORKER_ID ,

Line 4982: FROM pa_resource_assignments ra

4978: , 'E'
4979: , ra.planning_end_date
4980: , TO_DATE(NULL)
4981: ) end_date
4982: FROM pa_resource_assignments ra
4983: , PJI_FM_EXTR_PLNVER4 ver
4984: , pa_projects_all ppa
4985: WHERE 1=1
4986: AND ra.budget_version_id = ver.plan_version_id

Line 5011: FROM pa_resource_assignments ra,

5007: AND ver.time_phased_type_code IN ('P', 'G')
5008: AND rates.worker_id=g_worker_id /* Added for bug 4083581 */
5009: UNION ALL
5010: SELECT project_id,budget_version_id
5011: FROM pa_resource_assignments ra,
5012: PJI_FM_AGGR_DLY_RATES rates
5013: WHERE rates.time_id= DECODE ( g_currency_conversion_rule
5014: , 'S'
5015: , TO_NUMBER(to_CHAR(ra.planning_start_date, 'J'))

Line 8326: , pa_resource_asSIGNments ra

8322: ,ver.plan_type_code plan_type_code /*4471527 */
8323: , ver.WP_FLAG
8324: FROM
8325: PJI_FM_EXTR_PLNVER4 ver
8326: , pa_resource_asSIGNments ra
8327: , PA_BUDGET_LINES bl
8328: , pa_projects_all ppa
8329: , PJI_ORG_EXTR_INFO oei
8330: , pji_pjp_rbs_header rhdr

Line 8635: , pa_resource_asSIGNments ra

8631: , ver.plan_type_code plan_type_code /*4471527 */
8632: , ver.WP_FLAG
8633: FROM
8634: PJI_FM_EXTR_PLNVER4 ver
8635: , pa_resource_asSIGNments ra
8636: , PA_BUDGET_LINES bl
8637: , pa_projects_all ppa
8638: , pji_pjp_rbs_header rhdr
8639: , PJI_FM_AGGR_DLY_RATES rates

Line 9490: , pa_resource_asSIGNments ra

9486: , ver.plan_type_code plan_type_code /*4471527 */
9487: , ver.WP_FLAG
9488: FROM
9489: PJI_FM_EXTR_PLNVER4 ver
9490: , pa_resource_asSIGNments ra
9491: , PA_BUDGET_LINES bl
9492: , pa_projects_all ppa
9493: , PJI_ORG_EXTR_INFO oei
9494: , pji_time_cal_period_v prd

Line 9781: , pa_resource_asSIGNments ra

9777: , ver.plan_type_code plan_type_code /*4471527 */
9778: , ver.WP_FLAG
9779: FROM
9780: PJI_FM_EXTR_PLNVER4 ver
9781: , pa_resource_asSIGNments ra
9782: , PA_BUDGET_LINES bl
9783: , pa_projects_all ppa
9784: , PJI_FM_AGGR_DLY_RATES rates
9785: , PA_PROJ_ELEM_VER_STRUCTURE pevs

Line 10453: , PA_RESOURCE_ASSIGNMENTS ra

10449: , ppa.carrying_out_organization_id project_organization_id
10450: , ver.plan_type_code plan_type_code /* 4471527*/
10451: FROM
10452: PJI_FM_EXTR_PLNVER4 ver
10453: , PA_RESOURCE_ASSIGNMENTS ra
10454: , PA_BUDGET_LINES bl
10455: , PA_PROJECTS_ALL ppa
10456: , PA_PROJ_ELEM_VER_STRUCTURE pevs
10457: WHERE