VIEW: APPS.HRFV_PAYROLLS

Source

View Text - Preformatted

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

View Text - HTML Formatted

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