VIEW: APPS.PAY_RUN_TYPES_F_VL

Source

View Text - Preformatted

SELECT B.ROWID ROW_ID , B.RUN_TYPE_ID , B.RUN_METHOD , HL.MEANING RUN_METHOD_MEANING , B.EFFECTIVE_START_DATE , B.EFFECTIVE_END_DATE , B.BUSINESS_GROUP_ID , B.LEGISLATION_CODE , B.LAST_UPDATE_DATE , B.LAST_UPDATED_BY , B.LAST_UPDATE_LOGIN , B.CREATED_BY , B.CREATION_DATE , B.OBJECT_VERSION_NUMBER , T.RUN_TYPE_NAME , T.SHORTNAME , B.SRS_FLAG , B.RUN_INFORMATION_CATEGORY , B.RUN_INFORMATION1 , B.RUN_INFORMATION2 , B.RUN_INFORMATION3 , B.RUN_INFORMATION4 , B.RUN_INFORMATION5 , B.RUN_INFORMATION6 , B.RUN_INFORMATION7 , B.RUN_INFORMATION8 , B.RUN_INFORMATION9 , B.RUN_INFORMATION10 , B.RUN_INFORMATION11 , B.RUN_INFORMATION12 , B.RUN_INFORMATION13 , B.RUN_INFORMATION14 , B.RUN_INFORMATION15 , B.RUN_INFORMATION16 , B.RUN_INFORMATION17 , B.RUN_INFORMATION18 , B.RUN_INFORMATION19 , B.RUN_INFORMATION20 , B.RUN_INFORMATION21 , B.RUN_INFORMATION22 , B.RUN_INFORMATION23 , B.RUN_INFORMATION24 , B.RUN_INFORMATION25 , B.RUN_INFORMATION26 , B.RUN_INFORMATION27 , B.RUN_INFORMATION28 , B.RUN_INFORMATION29 , B.RUN_INFORMATION30 FROM PAY_RUN_TYPES_F_TL T , PAY_RUN_TYPES_F B , FND_SESSIONS FS , HR_LOOKUPS HL WHERE B.RUN_TYPE_ID = T.RUN_TYPE_ID AND T.LANGUAGE = USERENV('LANG') AND FS.EFFECTIVE_DATE BETWEEN B.EFFECTIVE_START_DATE AND B.EFFECTIVE_END_DATE AND FS.SESSION_ID = USERENV('SESSIONID') AND HL.LOOKUP_TYPE = 'RUN_METHOD' AND HL.LOOKUP_CODE = B.RUN_METHOD

View Text - HTML Formatted

SELECT B.ROWID ROW_ID
, B.RUN_TYPE_ID
, B.RUN_METHOD
, HL.MEANING RUN_METHOD_MEANING
, B.EFFECTIVE_START_DATE
, B.EFFECTIVE_END_DATE
, B.BUSINESS_GROUP_ID
, B.LEGISLATION_CODE
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_LOGIN
, B.CREATED_BY
, B.CREATION_DATE
, B.OBJECT_VERSION_NUMBER
, T.RUN_TYPE_NAME
, T.SHORTNAME
, B.SRS_FLAG
, B.RUN_INFORMATION_CATEGORY
, B.RUN_INFORMATION1
, B.RUN_INFORMATION2
, B.RUN_INFORMATION3
, B.RUN_INFORMATION4
, B.RUN_INFORMATION5
, B.RUN_INFORMATION6
, B.RUN_INFORMATION7
, B.RUN_INFORMATION8
, B.RUN_INFORMATION9
, B.RUN_INFORMATION10
, B.RUN_INFORMATION11
, B.RUN_INFORMATION12
, B.RUN_INFORMATION13
, B.RUN_INFORMATION14
, B.RUN_INFORMATION15
, B.RUN_INFORMATION16
, B.RUN_INFORMATION17
, B.RUN_INFORMATION18
, B.RUN_INFORMATION19
, B.RUN_INFORMATION20
, B.RUN_INFORMATION21
, B.RUN_INFORMATION22
, B.RUN_INFORMATION23
, B.RUN_INFORMATION24
, B.RUN_INFORMATION25
, B.RUN_INFORMATION26
, B.RUN_INFORMATION27
, B.RUN_INFORMATION28
, B.RUN_INFORMATION29
, B.RUN_INFORMATION30
FROM PAY_RUN_TYPES_F_TL T
, PAY_RUN_TYPES_F B
, FND_SESSIONS FS
, HR_LOOKUPS HL
WHERE B.RUN_TYPE_ID = T.RUN_TYPE_ID
AND T.LANGUAGE = USERENV('LANG')
AND FS.EFFECTIVE_DATE BETWEEN B.EFFECTIVE_START_DATE
AND B.EFFECTIVE_END_DATE
AND FS.SESSION_ID = USERENV('SESSIONID')
AND HL.LOOKUP_TYPE = 'RUN_METHOD'
AND HL.LOOKUP_CODE = B.RUN_METHOD