72: NAME,
73: SEQUENCE_NUMBER
74: INTO CP_PARAM_STAGE_NAME,CP_SEQUENCE_NUMBER
75: FROM
76: PSB_BUDGET_STAGES
77: WHERE BUDGET_STAGE_ID = P_STAGE_ID;
78: ELSE
79: SELECT
80: ST.NAME,
80: ST.NAME,
81: ST.SEQUENCE_NUMBER
82: INTO CP_PARAM_STAGE_NAME,CP_SEQUENCE_NUMBER
83: FROM
84: PSB_BUDGET_STAGES ST,
85: PSB_WORKSHEETS WS
86: WHERE WS.WORKSHEET_ID = P_GLOBAL_WORKSHEET_ID
87: AND ST.BUDGET_STAGE_SET_ID = WS.STAGE_SET_ID
88: AND ST.SEQUENCE_NUMBER = WS.CURRENT_STAGE_SEQ;