View: PAYLV_ORG_PAYMENT_METHODS_F_V

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

View Text

SELECT OPMT.ORG_PAYMENT_METHOD_NAME
, OPM.ORG_PAYMENT_METHOD_ID
, OPM.EFFECTIVE_START_DATE
, OPM.EFFECTIVE_END_DATE
, CASE WHEN (OPM.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, OPM.BUSINESS_GROUP_ID)) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE
, OPMT.ORG_PAYMENT_METHOD_NAME ORDER_BY
FROM PAY_ORG_PAYMENT_METHODS_F OPM
, PAY_ORG_PAYMENT_METHODS_F_TL OPMT
WHERE OPM.ORG_PAYMENT_METHOD_ID = OPMT.ORG_PAYMENT_METHOD_ID
AND OPMT.LANGUAGE = USERENV('LANG') UNION ALL SELECT NULL
, -1
, HR_GENERAL.START_OF_TIME
, HR_GENERAL.END_OF_TIME
, 'Y'
, ' ' ORDER_BY
FROM DUAL WITH READ ONLY

Columns