DBA Data[Home] [Help]

APPS.PSP_PSPRCSLD_XMLP_PKG dependencies on PER_TIME_PERIODS

Line 40: PER_TIME_PERIODS

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

Line 66: PER_TIME_PERIODS

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

Line 171: PER_TIME_PERIODS

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;