APPS.PER_POSITIONS_PKG dependencies on PER_GRADES

Line 1137: from per_grades g

1133: update per_valid_grades vg
1134: set vg.date_to =
1135: (select least(nvl(p_date_end, p_end_of_time),
1136: nvl(g.date_to, p_end_of_time))
1137: from per_grades g
1138: where g.grade_id = vg.grade_id)
1139: where
1140: vg.position_id = p_position_id
1141: and nvl(vg.date_to, p_end_of_time) > p_date_end;

Line 1191: from per_grades g

1187: g.date_to,
1188: p_end_of_time,
1189: null,
1190: p_date_end)
1191: from per_grades g
1192: where g.grade_id = vg.grade_id)
1193: where
1194: vg.position_id = p_position_id
1195: and nvl(vg.date_to, p_end_of_time) = (select nvl(p.date_end,p_end_of_time)