VIEW: APPS.PER_ASSIGNMENT_RATES_V

Source

View Text - Preformatted

SELECT pgr.rowid row_id, pgr.grade_rule_id, pgr.effective_start_date, pgr.effective_end_date, pgr.business_group_id, pgr.rate_type, pgr.rate_id, pgr.value, pgr.request_id, pgr.program_application_id, pgr.program_id, pgr.program_update_date, pgr.last_update_date, pgr.last_updated_by, pgr.last_update_login, pgr.created_by, pgr.creation_date, pr.name rate_name, pr.asg_rate_type, fnd_asr.meaning asg_rate_type_name, pgr.grade_or_spinal_point_id assignment_id, pgr.currency_code, cur.name cuirrency_name, pgr.object_version_number object_version_number, pr.rate_basis, substrb(hr_general.decode_lookup('RATE_BASIS',pr.rate_basis),1,80) rate_basis_name FROM pay_grade_rules_f pgr, pay_rates pr, fnd_currencies_vl cur, fnd_lookups fnd_asr WHERE cur.currency_code (+) = pgr.currency_code and pr.rate_id = pgr.rate_id and pgr.rate_type = 'A' and fnd_asr.lookup_code (+) = pr.asg_rate_type and fnd_asr.lookup_type (+) = 'PRICE DIFFERENTIALS'

View Text - HTML Formatted

SELECT PGR.ROWID ROW_ID
, PGR.GRADE_RULE_ID
, PGR.EFFECTIVE_START_DATE
, PGR.EFFECTIVE_END_DATE
, PGR.BUSINESS_GROUP_ID
, PGR.RATE_TYPE
, PGR.RATE_ID
, PGR.VALUE
, PGR.REQUEST_ID
, PGR.PROGRAM_APPLICATION_ID
, PGR.PROGRAM_ID
, PGR.PROGRAM_UPDATE_DATE
, PGR.LAST_UPDATE_DATE
, PGR.LAST_UPDATED_BY
, PGR.LAST_UPDATE_LOGIN
, PGR.CREATED_BY
, PGR.CREATION_DATE
, PR.NAME RATE_NAME
, PR.ASG_RATE_TYPE
, FND_ASR.MEANING ASG_RATE_TYPE_NAME
, PGR.GRADE_OR_SPINAL_POINT_ID ASSIGNMENT_ID
, PGR.CURRENCY_CODE
, CUR.NAME CUIRRENCY_NAME
, PGR.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, PR.RATE_BASIS
, SUBSTRB(HR_GENERAL.DECODE_LOOKUP('RATE_BASIS'
, PR.RATE_BASIS)
, 1
, 80) RATE_BASIS_NAME
FROM PAY_GRADE_RULES_F PGR
, PAY_RATES PR
, FND_CURRENCIES_VL CUR
, FND_LOOKUPS FND_ASR
WHERE CUR.CURRENCY_CODE (+) = PGR.CURRENCY_CODE
AND PR.RATE_ID = PGR.RATE_ID
AND PGR.RATE_TYPE = 'A'
AND FND_ASR.LOOKUP_CODE (+) = PR.ASG_RATE_TYPE
AND FND_ASR.LOOKUP_TYPE (+) = 'PRICE DIFFERENTIALS'