DBA Data[Home] [Help]

APPS.PQH_FR_PROGRESSION_POINT_PKG dependencies on PAY_GRADE_RULES_F

Line 19: FROM pay_grade_rules_f

15: WHERE parent_spine_id = p_parent_spine_id;
16:
17: CURSOR csr_rate_ovn(p_grd_rule_id NUMBER) IS
18: SELECT object_version_number
19: FROM pay_grade_rules_f
20: WHERE grade_rule_id = p_grd_rule_id
21: AND TRUNC(SYSDATE) between effective_start_date and effective_end_date;
22:
23: l_scale_type varchar2(30);

Line 85: p_base_table_name => 'PAY_GRADE_RULES_F',

81: ELSE
82: RETURN;
83: END IF;
84: pqh_fr_utility.get_datetrack_mode(p_effective_date => trunc(sysdate),
85: p_base_table_name => 'PAY_GRADE_RULES_F',
86: p_base_key_column => 'GRADE_RULE_ID',
87: p_base_key_value => l_hr_rate_id,
88: p_datetrack_mode => l_dt_upd_mode);
89: