APPS.FPA_PORTFOLIO_PROJECT_SETS_PVT dependencies on FPA_AW_PC_INFO_V

Line 6: p_pc_id IN fpa_aw_pc_info_v.planning_cycle%TYPE,

2: /* $Header: FPAVPRSB.pls 120.2 2006/06/16 22:27:49 sishanmu noship $ */
3:
4: PROCEDURE create_project_set
5: ( p_api_version IN NUMBER,
6: p_pc_id IN fpa_aw_pc_info_v.planning_cycle%TYPE,
7: x_return_status OUT NOCOPY VARCHAR2,
8: x_msg_data OUT NOCOPY VARCHAR2,
9: x_msg_count OUT NOCOPY NUMBER) IS
10: cursor c_project_sets(p_portfolio_id in number) is

Line 33: from pa_project_parties ppp, pa_project_role_types pprt, hz_parties hzp, per_people_f per, fpa_aw_pc_info_v pc

29: l_count number(15);
30:
31: cursor c_portfolio_owner is
32: select hzp.party_id
33: from pa_project_parties ppp, pa_project_role_types pprt, hz_parties hzp, per_people_f per, fpa_aw_pc_info_v pc
34: where ppp.object_type = 'PJP_PORTFOLIO'
35: and ppp.project_role_id = pprt.project_role_id
36: and pprt.project_role_type = 'PORTFOLIO_OWNER'
37: and ppp.resource_source_id = per.person_id

Line 179: FROM fpa_aw_pc_info_v

175: END IF;
176:
177: SELECT portfolio
178: INTO l_portfolio_id
179: FROM fpa_aw_pc_info_v
180: WHERE planning_cycle = p_pc_id;
181:
182: --Select portfolio name, to be part of the project_set name.
183: SELECT name

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

396:
397: cursor c_scenario_project_set_det is
398: select sc.scenario, sc.planning_cycle, is_initial_scenario,
399: sc.approved_flag, pc.portfolio, pset.INIT_PROJECT_SET_ID, pset.APPR_PROJECT_SET_ID
400: from fpa_aw_sce_info_v sc, fpa_aw_pc_info_v pc, fpa_aw_project_sets_v pset
401: where sc.planning_cycle = pc.planning_cycle
402: and pc.portfolio = pset.portfolio
403: and sc.scenario = p_scen_id;
404: