APPS.PQH_OPS_BUS dependencies on PQH_DE_WRKPLC_VLDTNS

Line 220: from Pqh_De_Wrkplc_Vldtns a, Pqh_De_Wrkplc_Vldtn_Vers b

216: l_proc varchar2(72) := g_package||'Chk_Ops';
217: --
218: Cursor Ops is
219: Select Employment_type, Remuneration_regulation
220: from Pqh_De_Wrkplc_Vldtns a, Pqh_De_Wrkplc_Vldtn_Vers b
221: Where Wrkplc_Vldtn_Ver_Id = p_rec.Wrkplc_Vldtn_Ver_Id
222: and a.Wrkplc_Vldtn_Id = b.Wrkplc_Vldtn_id;
223:
224: l_Employment_type Pqh_De_Wrkplc_Vldtns.Employment_Type%TYPE;

Line 224: l_Employment_type Pqh_De_Wrkplc_Vldtns.Employment_Type%TYPE;

220: from Pqh_De_Wrkplc_Vldtns a, Pqh_De_Wrkplc_Vldtn_Vers b
221: Where Wrkplc_Vldtn_Ver_Id = p_rec.Wrkplc_Vldtn_Ver_Id
222: and a.Wrkplc_Vldtn_Id = b.Wrkplc_Vldtn_id;
223:
224: l_Employment_type Pqh_De_Wrkplc_Vldtns.Employment_Type%TYPE;
225: l_Remuneration_Regulation Pqh_De_Wrkplc_Vldtns.Remuneration_Regulation%TYPE;
226: Begin
227:
228: hr_utility.set_location('Entering:'||l_proc, 5);

Line 225: l_Remuneration_Regulation Pqh_De_Wrkplc_Vldtns.Remuneration_Regulation%TYPE;

221: Where Wrkplc_Vldtn_Ver_Id = p_rec.Wrkplc_Vldtn_Ver_Id
222: and a.Wrkplc_Vldtn_Id = b.Wrkplc_Vldtn_id;
223:
224: l_Employment_type Pqh_De_Wrkplc_Vldtns.Employment_Type%TYPE;
225: l_Remuneration_Regulation Pqh_De_Wrkplc_Vldtns.Remuneration_Regulation%TYPE;
226: Begin
227:
228: hr_utility.set_location('Entering:'||l_proc, 5);
229: Open Ops;