The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
NAME
FROM
PSB_BUDGET_PERIODS
WHERE BUDGET_PERIOD_ID = P_BUDGET_GROUP_ID1;
SELECT
NAME
FROM
PSB_BUDGET_PERIODS
WHERE BUDGET_PERIOD_ID = P_BUDGET_GROUP_ID2;
SELECT
NAME
FROM
PSB_BUDGET_PERIODS
WHERE BUDGET_PERIOD_ID = P_BUDGET_GROUP_ID3;
SELECT
NAME
FROM
PSB_BUDGET_PERIODS
WHERE BUDGET_PERIOD_ID = P_BUDGET_GROUP_ID4;
SELECT
NAME
INTO CP_PARAM_SP_NAME
FROM
PSB_SERVICE_PACKAGES
WHERE SERVICE_PACKAGE_ID = P_SERVICE_PACKAGE_ID;
SELECT
NAME,
SEQUENCE_NUMBER
INTO CP_PARAM_STAGE_NAME,CP_SEQUENCE_NUMBER
FROM
PSB_BUDGET_STAGES
WHERE BUDGET_STAGE_ID = P_STAGE_ID;
SELECT
ST.NAME,
ST.SEQUENCE_NUMBER
INTO CP_PARAM_STAGE_NAME,CP_SEQUENCE_NUMBER
FROM
PSB_BUDGET_STAGES ST,
PSB_WORKSHEETS WS
WHERE WS.WORKSHEET_ID = P_GLOBAL_WORKSHEET_ID
AND ST.BUDGET_STAGE_SET_ID = WS.STAGE_SET_ID
AND ST.SEQUENCE_NUMBER = WS.CURRENT_STAGE_SEQ;
SELECT
NAME,
BUDGET_CALENDAR_ID,
FLEX_MAPPING_SET_ID
INTO CP_PARAM_WS_NAME,L_CALENDAR_ID,CP_FLEX_MAPPING_SET_ID
FROM
PSB_WORKSHEETS
WHERE WORKSHEET_ID = P_GLOBAL_WORKSHEET_ID;
/*SELECT
BUDGET_YEAR_TYPE_ID
INTO CP_CY_PERIOD_ID
FROM
PSB_BUDGET_PERIODS
WHERE BUDGET_CALENDAR_ID = L_CALENDAR_ID
AND BUDGET_PERIOD_TYPE = 'Y';*/
FUNCTION SELECT_AMT_P RETURN VARCHAR2 IS
BEGIN
RETURN SELECT_AMT;
END SELECT_AMT_P;