APPS.PQH_DE_VLD_NEWVER_DEL dependencies on PQH_DE_WRKPLC_VLDTN_LVLNUMS

Line 15: l_WRKPLC_VLDTN_LVLNUM_Id Pqh_de_Wrkplc_Vldtn_Lvlnums.WRKPLC_VLDTN_LVLNUM_Id%TYPE;

11: l_Job_Object_Version_Number Pqh_De_Wrkplc_Vldtn_Jobs.object_Version_Number%TYPE;
12: l_Wrkplc_Vldtn_Job_Id Pqh_De_Wrkplc_Vldtn_Jobs.Wrkplc_Vldtn_JOb_Id%TYPE;
13: l_Jobftr_Object_Version_Number Pqh_De_Wrkplc_Vldtn_JobFtrs.object_Version_Number%TYPE;
14: l_Wrkplc_Vldtn_JobFTr_Id Pqh_De_Wrkplc_Vldtn_JobFTRS.Wrkplc_Vldtn_JObFTr_Id%TYPE;
15: l_WRKPLC_VLDTN_LVLNUM_Id Pqh_de_Wrkplc_Vldtn_Lvlnums.WRKPLC_VLDTN_LVLNUM_Id%TYPE;
16: l_Lvlnum_Object_Version_Number Pqh_De_Wrkplc_Vldtn_Lvlnums.object_Version_Number%TYPE;
17:
18:
19: Cursor wrkplc_vldtn_defn is

Line 16: l_Lvlnum_Object_Version_Number Pqh_De_Wrkplc_Vldtn_Lvlnums.object_Version_Number%TYPE;

12: l_Wrkplc_Vldtn_Job_Id Pqh_De_Wrkplc_Vldtn_Jobs.Wrkplc_Vldtn_JOb_Id%TYPE;
13: l_Jobftr_Object_Version_Number Pqh_De_Wrkplc_Vldtn_JobFtrs.object_Version_Number%TYPE;
14: l_Wrkplc_Vldtn_JobFTr_Id Pqh_De_Wrkplc_Vldtn_JobFTRS.Wrkplc_Vldtn_JObFTr_Id%TYPE;
15: l_WRKPLC_VLDTN_LVLNUM_Id Pqh_de_Wrkplc_Vldtn_Lvlnums.WRKPLC_VLDTN_LVLNUM_Id%TYPE;
16: l_Lvlnum_Object_Version_Number Pqh_De_Wrkplc_Vldtn_Lvlnums.object_Version_Number%TYPE;
17:
18:
19: Cursor wrkplc_vldtn_defn is
20: Select b.Wrkplc_Vldtn_Id,VALIDATION_NAME, EMPLOYMENT_TYPE, REMUNERATION_REGULATION, WRKPLC_VLDTN_VER_ID, VERSION_NUMBER,

Line 51: From Pqh_De_Wrkplc_Vldtn_Lvlnums

47: Business_group_id = p_Business_group_id;
48:
49: Cursor Wrkplc_Vldtn_Lvlnum (p_WRKPLC_VLDTN_VER_ID In Number) is
50: Select WRKPLC_VLDTN_LVLNUM_ID, LEVEL_NUMBER_ID, LEVEL_CODE_ID
51: From Pqh_De_Wrkplc_Vldtn_Lvlnums
52: where Wrkplc_Vldtn_Ver_id = p_WRKPLC_VLDTN_VER_ID and
53: Business_group_Id = p_Business_Group_Id;
54:
55: Begin

Line 186: From Pqh_De_Wrkplc_Vldtn_Lvlnums

182: Business_group_id = p_Business_group_id;
183:
184: Cursor Wrkplc_Vldtn_Lvlnum (p_WRKPLC_VLDTN_VER_ID In Number) is
185: Select WRKPLC_VLDTN_LVLNUM_ID, LEVEL_NUMBER_ID, LEVEL_CODE_ID, Object_Version_Number
186: From Pqh_De_Wrkplc_Vldtn_Lvlnums
187: where Wrkplc_Vldtn_Ver_id = p_WRKPLC_VLDTN_VER_ID and
188: Business_group_Id = p_Business_Group_Id;
189: l_vldcnt Number;
190:

Line 380: pqh_de_wrkplc_vldtn_lvlnums

376:
377: Cursor Chk_Ins_Upd(p_Wrkplc_Val_Ver_Id IN Number, p_Lvl_Code_Id IN Number, p_Lvl_Number_Id IN Number)
378: is
379: Select count(*) from
380: pqh_de_wrkplc_vldtn_lvlnums
381: where WRKPLC_VLDTN_VER_ID = p_Wrkplc_Val_Ver_Id
382: and LEVEL_NUMBER_ID = p_Lvl_Number_Id
383: and LEVEL_CODE_ID = p_Lvl_Code_Id;
384: Begin