APPS.PJI_FM_PLAN_MAINT_PVT dependencies on PA_RESOURCE_LISTS_ALL_BG

Line 126: FROM PJI_FM_EXTR_PLNVER4 b, pa_proj_fp_options a, pa_resource_lists_all_bg c

122: l_resource_list_id_tbl num_tbl;
123:
124: CURSOR res_list IS
125: SELECT /*+ ordered */ b.plan_version_id
126: FROM PJI_FM_EXTR_PLNVER4 b, pa_proj_fp_options a, pa_resource_lists_all_bg c
127: WHERE b.project_id = a.project_id
128: AND b.PLAN_TYPE_ID = a.FIN_PLAN_TYPE_ID
129: AND b.plan_version_id = a.fin_plan_version_id
130: and decode(b.plan_type_code, 'C', a.cost_resource_list_id, 'R', a.revenue_resource_list_id, 'A', a.all_resource_list_id) = c.resource_list_id

Line 134: FROM PJI_FM_EXTR_PLNVER3_T b, pa_proj_fp_options a, pa_resource_lists_all_bg c

130: and decode(b.plan_type_code, 'C', a.cost_resource_list_id, 'R', a.revenue_resource_list_id, 'A', a.all_resource_list_id) = c.resource_list_id
131: and nvl(resource_class_flag,'Y') = 'N'
132: UNION
133: SELECT /*+ ordered */ b.plan_version_id
134: FROM PJI_FM_EXTR_PLNVER3_T b, pa_proj_fp_options a, pa_resource_lists_all_bg c
135: WHERE b.project_id = a.project_id
136: AND b.PLAN_TYPE_ID = a.FIN_PLAN_TYPE_ID
137: AND b.plan_version_id = a.fin_plan_version_id
138: and decode(b.plan_type_code, 'C', a.cost_resource_list_id, 'R', a.revenue_resource_list_id, 'A', a.all_resource_list_id) = c.resource_list_id