APPS.FPA_INVESTMENT_CRITERIA_PVT dependencies on DUAL

Line 108: FROM dual;

104: -- A cursor to get the new unique id for the Strategic Objective.
105: CURSOR l_strobj_s_csr
106: IS
107: SELECT fpa_strategic_obj_s.nextval AS l_strobj_id
108: FROM dual;
109:
110: -- A record to hold the new sequence value
111: l_strobj_s_r l_strobj_s_csr%ROWTYPE;
112:

Line 226: -- The procedure Delete_StrategicObj_AW deletes the individual Strategic Objectives from

222:
223: /*******************************************************************************************
224: *******************************************************************************************/
225:
226: -- The procedure Delete_StrategicObj_AW deletes the individual Strategic Objectives from
227: -- the AW space.
228: PROCEDURE delete_strategicobj_aw
229: (
230: p_api_version IN NUMBER,

Line 689: -- for the Groups. We use the same variable as the individual objectives since the

685: /*******************************************************************************************
686: *******************************************************************************************/
687: /*
688: -- The procedure Update_StrategicObj_AScore_AW updates the Strategic Objective Average Score
689: -- for the Groups. We use the same variable as the individual objectives since the
690: -- individual scores are not entered at the Group level.
691: PROCEDURE Update_StrategicObj_AScore_AW
692: (
693: p_api_version IN number,

Line 690: -- individual scores are not entered at the Group level.

686: *******************************************************************************************/
687: /*
688: -- The procedure Update_StrategicObj_AScore_AW updates the Strategic Objective Average Score
689: -- for the Groups. We use the same variable as the individual objectives since the
690: -- individual scores are not entered at the Group level.
691: PROCEDURE Update_StrategicObj_AScore_AW
692: (
693: p_api_version IN number,
694: p_commit IN varchar2 := FND_API.G_FALSE,