APPS.PQH_GSP_STAGE_TO_HR dependencies on PER_GRADES

Line 1172: from per_grades

1168: function get_max_grd_seq(p_business_group_id in number) return number is
1169: l_max_seq number;
1170: begin
1171: select max(sequence) into l_max_seq
1172: from per_grades
1173: where business_group_id = p_business_group_id;
1174: l_max_seq := nvl(l_max_seq,0) +1;
1175: return l_max_seq;
1176: exception

Line 1661: from per_grades

1657: -- No Payscale is attached to grade previously
1658: begin
1659: select date_from
1660: into l_grd_effstdt
1661: from per_grades
1662: where grade_id = l_grade_id;
1663: exception
1664: when others then
1665: l_grd_effstdt := p_effective_date;

Line 2023: (p_table_name => 'PER_GRADES',

2019: l_concat_segments := get_grd_segment(p_grade_id => l_grade_id,
2020: p_grade_definition_id => grd_rec.information221);
2021: hr_utility.set_location('con seg is'||substr(l_concat_segments,1,55),61);
2022: l_db_ovn := pqh_gsp_stage_to_ben.get_ovn
2023: (p_table_name => 'PER_GRADES',
2024: p_key_column_name => 'GRADE_ID',
2025: p_key_column_value => l_grade_id);
2026: hr_utility.set_location(' ovn is '||l_db_ovn,30);
2027: if l_db_ovn <> l_ovn then