APPS.PQH_VER_BUS dependencies on PQH_DE_WRKPLC_VLDTNS

Line 217: l_Emp_Type Pqh_De_Wrkplc_Vldtns.EMPLOYMENT_TYPE%TYPE;

213: (p_effective_date in date
214: ,p_rec in pqh_ver_shd.g_rec_type) is
215: --
216: l_proc Varchar2(200) := g_package||'Ckh_Tariff_Contract';
217: l_Emp_Type Pqh_De_Wrkplc_Vldtns.EMPLOYMENT_TYPE%TYPE;
218: l_Result Varchar2(1);
219:
220: Cursor Tariff_Contract is
221: Select '1' from

Line 238: Pqh_De_Wrkplc_Vldtns

234: b.Hierarchy_Version_id = a.Hierarchy_Version_id;
235:
236: Cursor Emp_Type is
237: Select Employment_type from
238: Pqh_De_Wrkplc_Vldtns
239: Where WRKPLC_VLDTN_ID = p_rec.WRKPLC_VLDTN_ID;
240:
241: Begin
242:

Line 413: l_Emp_Type Pqh_De_Wrkplc_Vldtns.EMPLOYMENT_TYPE%TYPE;

409: (p_rec in pqh_ver_shd.g_rec_type,
410: P_Chk In Varchar2 Default 'N') is
411:
412: l_proc Varchar2(200) := g_package||'Ckh_Freeze';
413: l_Emp_Type Pqh_De_Wrkplc_Vldtns.EMPLOYMENT_TYPE%TYPE;
414: l_Result Varchar2(1);
415:
416: Begin
417: If Nvl(P_Chk,'N') = 'D' and P_rec.Freeze = 'F' Then