DBA Data[Home] [Help]

APPS.PQH_FR_SYNC_SAL_RATES dependencies on PAY_RATES

Line 255: pay_rates pr

251: /* Update rates that have the name same as the Pay scale name */
252: CURSOR csr_hrrate_for_point(p_point_id IN NUMBER, p_scale_name varchar2) IS
253: SELECT pgr.grade_rule_id,pgr.currency_code,pgr.value,pgr.object_version_number
254: FROM pay_grade_rules_f pgr,
255: pay_rates pr
256: WHERE pgr.rate_type = 'SP'
257: AND pgr.grade_or_spinal_point_id = p_point_id
258: AND p_effective_date BETWEEN pgr.effective_start_date AND pgr.effective_end_date
259: AND pgr.rate_id =pr.rate_id