VIEW: APPS.PAY_IN_ALLOWANCE_NAME_V

Source

View Text - Preformatted

SELECT r.row_low_range_or_name Allowance_Name from pay_user_tables t ,pay_user_columns c ,pay_user_rows_f r ,pay_user_column_instances_f i ,fnd_sessions ses WHERE ses.effective_date between i.effective_start_date and i.effective_end_date and ses.effective_date between r.effective_start_date and r.effective_end_date and t.user_table_id = c.user_table_id and t.user_table_id = r.user_table_id and c.user_column_id = i.user_column_id and r.user_row_id = i.user_row_id and t.user_table_name = 'IN_ALLOWANCES' and t.legislation_code = 'IN' and (r.legislation_code = 'IN' OR r.business_group_id = fnd_profile.value('PER_BUSINESS_GROUP_ID')) and (i.legislation_code = 'IN' OR i.business_group_id = fnd_profile.value('PER_BUSINESS_GROUP_ID')) and c.user_column_name = 'Category' and ses.session_id = userenv('sessionid')

View Text - HTML Formatted

SELECT R.ROW_LOW_RANGE_OR_NAME ALLOWANCE_NAME
FROM PAY_USER_TABLES T
, PAY_USER_COLUMNS C
, PAY_USER_ROWS_F R
, PAY_USER_COLUMN_INSTANCES_F I
, FND_SESSIONS SES
WHERE SES.EFFECTIVE_DATE BETWEEN I.EFFECTIVE_START_DATE
AND I.EFFECTIVE_END_DATE
AND SES.EFFECTIVE_DATE BETWEEN R.EFFECTIVE_START_DATE
AND R.EFFECTIVE_END_DATE
AND T.USER_TABLE_ID = C.USER_TABLE_ID
AND T.USER_TABLE_ID = R.USER_TABLE_ID
AND C.USER_COLUMN_ID = I.USER_COLUMN_ID
AND R.USER_ROW_ID = I.USER_ROW_ID
AND T.USER_TABLE_NAME = 'IN_ALLOWANCES'
AND T.LEGISLATION_CODE = 'IN'
AND (R.LEGISLATION_CODE = 'IN' OR R.BUSINESS_GROUP_ID = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID'))
AND (I.LEGISLATION_CODE = 'IN' OR I.BUSINESS_GROUP_ID = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID'))
AND C.USER_COLUMN_NAME = 'CATEGORY'
AND SES.SESSION_ID = USERENV('SESSIONID')