Product: | PAY - Payroll |
---|---|
Description: | |
Implementation/DBA Data: | APPS.PAYBV_RUN_TYPES_F_V |
SELECT HR_BIS.BIS_DECODE_LOOKUP('RUN_METHOD'
, B.RUN_METHOD) RUN_METHOD_M
, T.RUN_TYPE_NAME
, B.EFFECTIVE_START_DATE
, B.EFFECTIVE_END_DATE
, T.SHORTNAME
, B.SRS_FLAG
, 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
, B.RUN_METHOD
, B.BUSINESS_GROUP_ID
, B.LEGISLATION_CODE
, B.RUN_TYPE_ID
, B.RUN_INFORMATION_CATEGORY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_LOGIN
, B.CREATED_BY
, B.CREATION_DATE
, B.OBJECT_VERSION_NUMBER
, CASE WHEN ((B.BUSINESS_GROUP_ID IS NULL
AND B.LEGISLATION_CODE IS NULL) OR (B.BUSINESS_GROUP_ID IS NULL
AND B.LEGISLATION_CODE = NVL(HR_BIS.GET_LEGISLATION_CODE
, B.LEGISLATION_CODE)) OR (B.BUSINESS_GROUP_ID= NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, B.BUSINESS_GROUP_ID))) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE
FROM PAY_RUN_TYPES_F_TL T
, PAY_RUN_TYPES_F B
WHERE B.RUN_TYPE_ID = T.RUN_TYPE_ID
AND T.LANGUAGE = USERENV('LANG') WITH READ ONLY