VIEW: APPS.PAYLV_ORG_PAYMENT_METHODS_F_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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