APPS.PJI_PJP_PRG_PERF_ALL dependencies on PA_PROJECTS_ALL

Line 1950: , pa_projects_all ppa

1946: pji_time_cal_period_v pri
1947: , pji_org_extr_info orginfo
1948: , pji_time_cal_period_v sec
1949: , pji_fm_extr_plnver4 ver
1950: , pa_projects_all ppa
1951: WHERE 1=1
1952: AND ppa.org_id=orginfo.org_id
1953: AND ver.worker_id = g_worker_id
1954: AND pri.calendar_id in (orginfo.gl_calendar_id,orginfo.pa_calendar_id)

Line 2790: , pa_projects_all ppa

2786: ) end_date
2787: FROM pa_budget_lines bl
2788: , pji_time_cal_period_v prd
2789: , PJI_FM_EXTR_PLNVER4 ver
2790: , pa_projects_all ppa
2791: ,PJI_ORG_EXTR_INFO inf
2792: WHERE 1=1
2793: AND bl.budget_version_id = ver.plan_version_id
2794: AND ver.time_phased_type_code IN ('P', 'G')

Line 2830: , pa_projects_all ppa

2826: , TO_DATE(NULL)
2827: ) end_date
2828: FROM pa_resource_assignments ra
2829: , PJI_FM_EXTR_PLNVER4 ver
2830: , pa_projects_all ppa
2831: WHERE 1=1
2832: AND ra.budget_version_id = ver.plan_version_id
2833: AND ver.wp_flag = 'N'
2834: AND ver.baselined_flag = 'Y'

Line 3781: , pa_projects_all ppa

3777: FROM
3778: PJI_FM_EXTR_PLNVER4 ver
3779: , pa_resource_asSIGNments ra
3780: , PA_BUDGET_LINES bl
3781: , pa_projects_all ppa
3782: , PJI_ORG_EXTR_INFO oei
3783: , pji_time_cal_period_v prd
3784: , PJI_FM_AGGR_DLY_RATES rates
3785: , PA_PROJ_ELEM_VER_STRUCTURE pevs

Line 4072: , pa_projects_all ppa

4068: FROM
4069: PJI_FM_EXTR_PLNVER4 ver
4070: , pa_resource_asSIGNments ra
4071: , PA_BUDGET_LINES bl
4072: , pa_projects_all ppa
4073: , PJI_FM_AGGR_DLY_RATES rates
4074: , PA_PROJ_ELEM_VER_STRUCTURE pevs
4075: WHERE 1=1
4076: AND ra.resource_asSIGNment_id = bl.resource_asSIGNment_id