DBA Data[Home] [Help]

APPS.PSP_PSPLDDFA_XMLP_PKG dependencies on PER_ASSIGNMENTS_F

Line 302: PER_ASSIGNMENTS_F

298: DISTINCT
299: ASSIGNMENT_NUMBER
300: INTO V_ASSIGNMENT_NUMBER
301: FROM
302: PER_ASSIGNMENTS_F
303: WHERE ASSIGNMENT_ID = CF_ASSIGNMENT_NUMBERFORMULA.ASSIGNMENT_ID
304: AND ( P_TIME_PERIOD_END Between EFFECTIVE_START_DATE
305: AND EFFECTIVE_END_DATE );
306: ELSE

Line 312: PER_ASSIGNMENTS_F

308: DISTINCT
309: ASSIGNMENT_NUMBER
310: INTO V_ASSIGNMENT_NUMBER
311: FROM
312: PER_ASSIGNMENTS_F
313: WHERE ASSIGNMENT_ID = CF_ASSIGNMENT_NUMBERFORMULA.ASSIGNMENT_ID;
314: END IF;
315: RETURN V_ASSIGNMENT_NUMBER;
316: RETURN NULL;