36: SELECT
37: END_DATE
38: INTO X_END_DATE
39: FROM
40: PER_TIME_PERIODS
41: WHERE TIME_PERIOD_ID = P_TIME_PERIOD_ID;
42: SELECT
43: FULL_NAME
44: INTO X_PERSON_NAME
62: SELECT
63: START_DATE
64: INTO P_START_DATE
65: FROM
66: PER_TIME_PERIODS
67: WHERE TIME_PERIOD_ID = P_TIME_PERIOD_ID;
68: RETURN (TRUE);
69: RETURN NULL;
70: EXCEPTION
167: SELECT
168: PERIOD_NAME
169: INTO X_TIME_PERIOD
170: FROM
171: PER_TIME_PERIODS
172: WHERE TIME_PERIOD_ID = P_TIME_PERIOD_ID;
173: RETURN (X_TIME_PERIOD);
174: END IF;
175: RETURN NULL;