VIEW: APPS.PAYBV_USER_ROW

Source

View Text - Preformatted

SELECT pur.EFFECTIVE_START_DATE ,pur.EFFECTIVE_END_DATE ,pur.ROW_LOW_RANGE_OR_NAME ,pur.DISPLAY_SEQUENCE ,pur.ROW_HIGH_RANGE ,pur.LEGISLATION_CODE ,pur.LEGISLATION_SUBGROUP ,pur.USER_ROW_ID ,pur.USER_TABLE_ID ,pur.BUSINESS_GROUP_ID ,pur.LAST_UPDATE_DATE ,pur.LAST_UPDATED_BY ,pur.LAST_UPDATE_LOGIN ,pur.CREATED_BY ,pur.CREATION_DATE ,pur.OBJECT_VERSION_NUMBER ,CASE WHEN ((pur.business_group_id IS NULL AND pur.legislation_code IS NULL) OR (pur.business_group_id IS NULL AND pur.legislation_code = NVL(hr_bis.get_legislation_code,pur.legislation_code)) OR (pur.business_group_id = NVL(hr_bis.get_sec_profile_bg_id, pur.business_group_id))) THEN 'Y' ELSE 'N' END bg_security_flag_code FROM pay_user_rows_f pur WITH READ ONLY

View Text - HTML Formatted

SELECT PUR.EFFECTIVE_START_DATE
, PUR.EFFECTIVE_END_DATE
, PUR.ROW_LOW_RANGE_OR_NAME
, PUR.DISPLAY_SEQUENCE
, PUR.ROW_HIGH_RANGE
, PUR.LEGISLATION_CODE
, PUR.LEGISLATION_SUBGROUP
, PUR.USER_ROW_ID
, PUR.USER_TABLE_ID
, PUR.BUSINESS_GROUP_ID
, PUR.LAST_UPDATE_DATE
, PUR.LAST_UPDATED_BY
, PUR.LAST_UPDATE_LOGIN
, PUR.CREATED_BY
, PUR.CREATION_DATE
, PUR.OBJECT_VERSION_NUMBER
, CASE WHEN ((PUR.BUSINESS_GROUP_ID IS NULL
AND PUR.LEGISLATION_CODE IS NULL) OR (PUR.BUSINESS_GROUP_ID IS NULL
AND PUR.LEGISLATION_CODE = NVL(HR_BIS.GET_LEGISLATION_CODE
, PUR.LEGISLATION_CODE)) OR (PUR.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, PUR.BUSINESS_GROUP_ID))) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE
FROM PAY_USER_ROWS_F PUR WITH READ ONLY