DBA Data[Home] [Help]

APPS.FPA_PROCESS_PVT dependencies on FPA_AW_PROJS_V

Line 3382: select class_code from fpa_aw_projs_v where project = p_proj_id;

3378:
3379: IS
3380:
3381: cursor c_class_code is
3382: select class_code from fpa_aw_projs_v where project = p_proj_id;
3383:
3384: l_api_version NUMBER;
3385: l_data_to_calc varchar2(30);
3386: l_class_code_id NUMBER;

Line 5332: from fpa_aw_projs_v a,

5328:
5329: -- Cursor checks for Active planning cycles in the portfolio that the project belongs to.
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