APPS.FPA_PROCESS_PVT dependencies on FPA_AW_PC_INFO_V

Line 1099: FROM FPA_AW_PC_INFO_V prevPC,

1095: l_last_pc_id NUMBER;
1096:
1097: CURSOR c_last_pc_id IS
1098: SELECT prevPC.planning_cycle
1099: FROM FPA_AW_PC_INFO_V prevPC,
1100: FPA_AW_PC_INFO_V currPC
1101: WHERE prevPC.portfolio = currPC.portfolio
1102: AND currPC.planning_cycle = p_pc_id
1103: AND prevPC.last_flag = 1;

Line 1100: FPA_AW_PC_INFO_V currPC

1096:
1097: CURSOR c_last_pc_id IS
1098: SELECT prevPC.planning_cycle
1099: FROM FPA_AW_PC_INFO_V prevPC,
1100: FPA_AW_PC_INFO_V currPC
1101: WHERE prevPC.portfolio = currPC.portfolio
1102: AND currPC.planning_cycle = p_pc_id
1103: AND prevPC.last_flag = 1;
1104:

Line 1148: FROM FPA_AW_PC_INFO_V

1144: END IF;
1145:
1146: SELECT CALENDAR_NAME , PERIOD_TYPE, CAL_PERIOD_TYPE
1147: INTO l_cal_name, l_period_type, l_cal_period_type
1148: FROM FPA_AW_PC_INFO_V
1149: WHERE PLANNING_CYCLE = p_pc_id;
1150:
1151: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1152: FND_LOG.String

Line 2345: from fpa_pcs_vl a ,fpa_aw_pc_info_v b

2341: END IF;
2342:
2343: select a.name ,a.description ,b.initiate_date ,b.submission_due_date
2344: into l_pc_name, l_pc_description, l_pc_date_initiated, l_due_date
2345: from fpa_pcs_vl a ,fpa_aw_pc_info_v b
2346: where a.planning_cycle = b.planning_cycle
2347: and a.planning_cycle = l_pc_id;
2348:
2349: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

Line 2526: from fpa_aw_sce_info_v sc, fpa_aw_pc_info_v pc, fpa_aw_project_sets_v pset

2522:
2523:
2524: cursor c_init_project_set is
2525: select pset.INIT_PROJECT_SET_ID
2526: from fpa_aw_sce_info_v sc, fpa_aw_pc_info_v pc, fpa_aw_project_sets_v pset
2527: where sc.planning_cycle = pc.planning_cycle
2528: and pc.portfolio = pset.portfolio
2529: and sc.scenario = p_scenario_id;
2530:

Line 5334: fpa_aw_pc_info_v c

5330: cursor c_pc_active is
5331: select count(a.project) Validpc
5332: from fpa_aw_projs_v a,
5333: fpa_aw_pcs_v b,
5334: fpa_aw_pc_info_v c
5335: where a.portfolio = b.portfolio
5336: and b.planning_cycle = c.planning_cycle
5337: and c.pc_status in ('COLLECTING', 'ANALYSIS')
5338: and a.project = p_project_id;