[Home] [Help]
View: HRFV_PAYROLLS
Product: | PER - Human Resources |
Description: | Business view template from which the flexfield view is generated. |
Implementation/DBA Data: |
APPS.HRFV_PAYROLLS
|
View Text
SELECT BGRT.NAME BUSINESS_GROUP_NAME
, PAY.PAYROLL_NAME PAYROLL_NAME
, PAY.PERIOD_TYPE PAYROLL_PERIOD_TYPE
, OPM.ORG_PAYMENT_METHOD_NAME DEFAULT_PAYMENT_METHOD
, '_DF:PAY:PAY_PAYROLLS:PAY'
, PAY.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, PAY.DEFAULT_PAYMENT_METHOD_ID DEFAULT_PAYMENT_METHOD_ID
, PAY.PAYROLL_ID PAYROLL_ID
FROM PAY_PAYROLLS_X PAY
, PAY_ORG_PAYMENT_METHODS_X OPM
, HR_ALL_ORGANIZATION_UNITS_TL BGRT
WHERE PAY.DEFAULT_PAYMENT_METHOD_ID = OPM.ORG_PAYMENT_METHOD_ID(+)
AND PAY.BUSINESS_GROUP_ID = BGRT.ORGANIZATION_ID
AND BGRT.LANGUAGE = USERENV('LANG')
AND PAY.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, PAY.BUSINESS_GROUP_ID) WITH READ ONLY
Columns
Name |
BUSINESS_GROUP_NAME |
PAYROLL_NAME |
PAYROLL_PERIOD_TYPE |
DEFAULT_PAYMENT_METHOD |
"_DF" |
BUSINESS_GROUP_ID |
DEFAULT_PAYMENT_METHOD_ID |
PAYROLL_ID |