APPS.PQH_GSP_STAGE_TO_HR dependencies on PER_GRADES

Line 1133: from per_grades

1129: function get_max_grd_seq(p_business_group_id in number) return number is
1130: l_max_seq number;
1131: begin
1132: select max(sequence) into l_max_seq
1133: from per_grades
1134: where business_group_id = p_business_group_id;
1135: l_max_seq := nvl(l_max_seq,0) +1;
1136: return l_max_seq;
1137: exception

Line 1622: from per_grades

1618: -- No Payscale is attached to grade previously
1619: begin
1620: select date_from
1621: into l_grd_effstdt
1622: from per_grades
1623: where grade_id = l_grade_id;
1624: exception
1625: when others then
1626: l_grd_effstdt := p_effective_date;

Line 1983: (p_table_name => 'PER_GRADES',

1979: l_concat_segments := get_grd_segment(p_grade_id => l_grade_id,
1980: p_grade_definition_id => grd_rec.information221);
1981: hr_utility.set_location('con seg is'||substr(l_concat_segments,1,55),61);
1982: l_db_ovn := pqh_gsp_stage_to_ben.get_ovn
1983: (p_table_name => 'PER_GRADES',
1984: p_key_column_name => 'GRADE_ID',
1985: p_key_column_value => l_grade_id);
1986: hr_utility.set_location(' ovn is '||l_db_ovn,30);
1987: if l_db_ovn <> l_ovn then