APPS.PQH_FR_SYNC_SAL_RATES dependencies on PAY_GRADE_RULES_F

Line 254: FROM pay_grade_rules_f pgr,

250:
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

Line 261: l_rt_currency_cd pay_grade_rules_f.currency_code%TYPE;

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
260: AND pr.name = p_scale_name;
261: l_rt_currency_cd pay_grade_rules_f.currency_code%TYPE;
262: l_new_value NUMBER := 0;
263: l_conv_factor NUMBER := 1;
264: l_dt_upd_mode VARCHAR2(30);
265: l_effective_start_date DATE;

Line 295: l_dt_upd_mode := pqh_gsp_stage_to_ben.get_update_mode(p_table_name => 'PAY_GRADE_RULES_F'

291: END IF;
292: -- Now apply the conversion rates to Grade ladder Currency from the Bareme Currency
293: l_new_value := (p_inm*g_sal_point_rate)*l_conv_factor;
294:
295: l_dt_upd_mode := pqh_gsp_stage_to_ben.get_update_mode(p_table_name => 'PAY_GRADE_RULES_F'
296: ,p_key_column_name => 'GRADE_RULE_ID'
297: ,p_key_column_value => l_rate_rec.grade_rule_id
298: ,p_effective_date => p_effective_date);
299: hr_rate_values_api.update_rate_value