APPS.PQH_RSS_BUS dependencies on PER_GRADES

Line 235: from per_grades

231: (p_rec in pqh_rss_shd.g_rec_type) is
232: --
233: Cursor c_Grade_id is
234: Select Grade_id
235: from per_grades
236: Where Grade_id = p_rec.Grade_id;
237: l_Grade_id PQH_DE_RESULT_SETS.Grade_id%TYPE;
238:
239: l_proc varchar2(72) := g_package || 'Check_Grade_id';

Line 281: PER_GRADES_VL pg

277: PER_GEN_HIERARCHY_NODES pghn3 ,
278: PER_GEN_HIERARCHY_NODES pghn4 ,
279: PER_GEN_HIERARCHY_NODES pghn5 ,
280: PER_GEN_HIERARCHY_NODES pghn6 ,
281: PER_GRADES_VL pg
282: WHERE pgh.TYPE='REMUNERATION_REGULATION'
283: and pgh.HIERARCHY_ID=pghv.HIERARCHY_ID
284: and p_Effective_Date between pghv.Date_from and Nvl(pghv.Date_To,Trunc(Sysdate))
285: and pghv.HIERARCHY_VERSION_ID=pghn.HIERARCHY_VERSION_ID

Line 309: PER_GRADES_VL pg

305: PER_GEN_HIERARCHY_NODES pghn4 ,
306: PER_GEN_HIERARCHY_NODES pghn5 ,
307: PER_GEN_HIERARCHY_NODES pghn6 ,
308: PER_GEN_HIERARCHY_NODES pghn7 ,
309: PER_GRADES_VL pg
310: where pgh.TYPE='REMUNERATION_REGULATION'
311: and pgh.HIERARCHY_ID=pghv.HIERARCHY_ID
312: and p_Effective_Date between pghv.Date_from and Nvl(pghv.Date_To,Trunc(Sysdate))
313: and pghv.HIERARCHY_VERSION_ID=pghn.HIERARCHY_VERSION_ID

Line 325: l_CIVIL_SERVANTS_Grade_id per_grades.name%TYPE;

321: and pghn5.PARENT_HIERARCHY_NODE_ID = pghn6.HIERARCHY_NODE_ID
322: and pghn6.PARENT_HIERARCHY_NODE_ID = pghn7.HIERARCHY_NODE_ID
323: and pghn7.ENTITY_ID = 'BE';
324:
325: l_CIVIL_SERVANTS_Grade_id per_grades.name%TYPE;
326: l_proc varchar2(72) := g_package || 'Check_CIVIL_Grade_id';
327:
328: Begin
329: hr_utility.set_location(l_proc, 10);