View: PAY_RUN_TYPE_USAGES_V

Product:	PAY - Payroll
Description:
Implementation/DBA Data:	APPS.PAY_RUN_TYPE_USAGES_V

View Text

SELECT RTU.RUN_TYPE_USAGE_ID
, RTU.PARENT_RUN_TYPE_ID
, RTU.CHILD_RUN_TYPE_ID
, RTU.EFFECTIVE_START_DATE
, RTU.EFFECTIVE_END_DATE
, RTU.SEQUENCE
, RTU.OBJECT_VERSION_NUMBER
, RTU.BUSINESS_GROUP_ID
, RTU.LEGISLATION_CODE
, TL_P.RUN_TYPE_NAME
, TL_P.SHORTNAME
, PRT_P.RUN_METHOD
, TL_C.RUN_TYPE_NAME
, TL_C.SHORTNAME
, PRT_C.RUN_METHOD
, HL.MEANING
FROM PAY_RUN_TYPE_USAGES_F RTU
, PAY_RUN_TYPES_F PRT_P
, PAY_RUN_TYPES_F PRT_C
, PAY_RUN_TYPES_F_TL TL_P
, PAY_RUN_TYPES_F_TL TL_C
, FND_SESSIONS FS
, HR_LOOKUPS HL
WHERE RTU.PARENT_RUN_TYPE_ID = PRT_P.RUN_TYPE_ID
AND PRT_P.RUN_TYPE_ID = TL_P.RUN_TYPE_ID
AND TL_P.LANGUAGE = USERENV('LANG')
AND RTU.CHILD_RUN_TYPE_ID = PRT_C.RUN_TYPE_ID
AND PRT_C.RUN_TYPE_ID = TL_C.RUN_TYPE_ID
AND TL_C.LANGUAGE = USERENV('LANG')
AND HL.LOOKUP_TYPE = 'RUN_METHOD'
AND HL.LOOKUP_CODE = PRT_C.RUN_METHOD
AND FS.SESSION_ID = USERENV('SESSIONID')
AND FS.EFFECTIVE_DATE BETWEEN RTU.EFFECTIVE_START_DATE
AND RTU.EFFECTIVE_END_DATE
AND FS.EFFECTIVE_DATE BETWEEN PRT_P.EFFECTIVE_START_DATE
AND PRT_P.EFFECTIVE_END_DATE
AND FS.EFFECTIVE_DATE BETWEEN PRT_C.EFFECTIVE_START_DATE
AND PRT_C.EFFECTIVE_END_DATE

Columns