APPS.PQH_DE_VLD_NEWVER_DEL dependencies on PQH_DE_WRKPLC_VLDTN_JOBS

Line 11: l_Job_Object_Version_Number Pqh_De_Wrkplc_Vldtn_Jobs.object_Version_Number%TYPE;

7: L_Wrkplc_Vldtn_Ver_Id Pqh_De_Wrkplc_Vldtn_Vers.Wrkplc_Vldtn_Ver_Id%TYPE;
8: l_object_Version_Number Pqh_De_Wrkplc_Vldtn_Vers.object_Version_Number%TYPE;
9: l_Opr_Object_Version_Number Pqh_De_Wrkplc_Vldtn_Ops.object_Version_Number%TYPE;
10: l_Wrkplc_Vldtn_Op_Id Pqh_De_Wrkplc_Vldtn_Ops.Wrkplc_Vldtn_Op_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;

Line 12: l_Wrkplc_Vldtn_Job_Id Pqh_De_Wrkplc_Vldtn_Jobs.Wrkplc_Vldtn_JOb_Id%TYPE;

8: l_object_Version_Number Pqh_De_Wrkplc_Vldtn_Vers.object_Version_Number%TYPE;
9: l_Opr_Object_Version_Number Pqh_De_Wrkplc_Vldtn_Ops.object_Version_Number%TYPE;
10: l_Wrkplc_Vldtn_Op_Id Pqh_De_Wrkplc_Vldtn_Ops.Wrkplc_Vldtn_Op_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;

Line 38: From Pqh_De_Wrkplc_Vldtn_Jobs

34: Business_Group_id = P_Business_Group_Id;
35:
36: Cursor Wrkplc_Vldtn_Jobs (p_Wrkplc_Vldtn_Op_Id in Number) is
37: Select WRKPLC_VLDTN_JOB_ID, WRKPLC_JOB_ID, DESCRIPTION
38: From Pqh_De_Wrkplc_Vldtn_Jobs
39: Where Wrkplc_Vldtn_Op_Id = P_Wrkplc_Vldtn_Op_Id and
40: Business_Group_Id = p_Business_Group_Id;
41:
42: Cursor Wrkplc_Vldtn_JobFtrs (P_Wrkplc_Vldtn_OpJob_Id In Number,P_Wrkplc_Vldtn_OprJob_Type In Varchar2) is

Line 173: From Pqh_De_Wrkplc_Vldtn_Jobs

169: Business_Group_id = P_Business_Group_Id;
170:
171: Cursor Wrkplc_Vldtn_Jobs (p_Wrkplc_Vldtn_Op_Id in Number) is
172: Select WRKPLC_VLDTN_JOB_ID, WRKPLC_JOB_ID, DESCRIPTION, Object_version_Number
173: From Pqh_De_Wrkplc_Vldtn_Jobs
174: Where Wrkplc_Vldtn_Op_Id = P_Wrkplc_Vldtn_Op_Id and
175: Business_Group_Id = p_Business_Group_Id;
176:
177: Cursor Wrkplc_Vldtn_JobFtrs (P_Wrkplc_Vldtn_OpJob_Id In Number,P_Wrkplc_Vldtn_OprJob_Type In Varchar2) is

Line 280: From Pqh_De_Wrkplc_Vldtn_Jobs

276: Business_Group_id = P_Business_Group_Id;
277:
278: Cursor Wrkplc_Vldtn_Jobs (p_Wrkplc_Vldtn_Op_Id in Number) is
279: Select WRKPLC_VLDTN_JOB_ID, WRKPLC_JOB_ID, DESCRIPTION, Object_version_Number
280: From Pqh_De_Wrkplc_Vldtn_Jobs
281: Where Wrkplc_Vldtn_Op_Id = P_Wrkplc_Vldtn_Op_Id and
282: Business_Group_Id = p_Business_Group_Id;
283:
284: Cursor Wrkplc_Vldtn_JobFtrs (P_Wrkplc_Vldtn_OpJob_Id In Number,P_Wrkplc_Vldtn_OprJob_Type In Varchar2) is

Line 332: From Pqh_De_Wrkplc_Vldtn_Jobs

328: P_Business_Group_Id In Number) is
329:
330: Cursor Wrkplc_Vldtn_Jobs is
331: Select WRKPLC_VLDTN_JOB_ID, WRKPLC_JOB_ID, DESCRIPTION, Object_version_Number
332: From Pqh_De_Wrkplc_Vldtn_Jobs
333: Where Wrkplc_Vldtn_Job_Id = p_WRKPLC_VLDTN_JOB_ID and
334: Business_Group_Id = p_Business_Group_Id;
335:
336: Cursor Wrkplc_Vldtn_JobFtrs (P_Wrkplc_Vldtn_OpJob_Id In Number,P_Wrkplc_Vldtn_OprJob_Type In Varchar2) is