VIEW: APPS.PAY_IN_OTHER_PERQUISITES_V

Source

View Text - Preformatted

SELECT r.row_low_range_or_name Perquisite_Name ,i.value Exemption_Amount 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_PERQUISITES' 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 = 'Exemption Amount' AND ses.session_id = userenv('sessionid')

View Text - HTML Formatted

SELECT R.ROW_LOW_RANGE_OR_NAME PERQUISITE_NAME
, I.VALUE EXEMPTION_AMOUNT
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_PERQUISITES'
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 = 'EXEMPTION AMOUNT'
AND SES.SESSION_ID = USERENV('SESSIONID')