DBA Data[Home] [Help]

APPS.PSP_PSPLDSSA_XMLP_PKG dependencies on PAY_ELEMENT_TYPES_F

Line 228: PAY_ELEMENT_TYPES_F

224: DISTINCT
225: ELEMENT_NAME
226: INTO V_ELEMENT_NAME
227: FROM
228: PAY_ELEMENT_TYPES_F
229: WHERE ELEMENT_TYPE_ID = ELEMENT_TYPE_ID_arg
230: AND ( P_TIME_PERIOD_END Between EFFECTIVE_START_DATE
231: AND EFFECTIVE_END_DATE );
232: ELSE

Line 238: PAY_ELEMENT_TYPES_F

234: DISTINCT
235: ELEMENT_NAME
236: INTO V_ELEMENT_NAME
237: FROM
238: PAY_ELEMENT_TYPES_F
239: WHERE ELEMENT_TYPE_ID = ELEMENT_TYPE_ID_arg;
240: END IF;
241: RETURN V_ELEMENT_NAME;
242: RETURN NULL;