DBA Data[Home] [Help]

APPS.PSP_PSPLDSSA_XMLP_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 195: PER_ALL_ASSIGNMENTS_F

191: DISTINCT
192: ASSIGNMENT_NUMBER
193: INTO V_ASSIGNMENT_NUMBER
194: FROM
195: PER_ALL_ASSIGNMENTS_F
196: WHERE ASSIGNMENT_ID = ASSIGNMENT_ID_arg
197: AND ( P_TIME_PERIOD_END Between EFFECTIVE_START_DATE
198: AND EFFECTIVE_END_DATE );
199: ELSE

Line 205: PER_ALL_ASSIGNMENTS_F

201: DISTINCT
202: ASSIGNMENT_NUMBER
203: INTO V_ASSIGNMENT_NUMBER
204: FROM
205: PER_ALL_ASSIGNMENTS_F
206: WHERE ASSIGNMENT_ID = ASSIGNMENT_ID_arg;
207: END IF;
208: RETURN V_ASSIGNMENT_NUMBER;
209: RETURN NULL;