APPS.PQH_DE_VLD_NEWVER_DEL dependencies on PQH_DE_WRKPLC_VLDTN_OPS

Line 9: l_Opr_Object_Version_Number Pqh_De_Wrkplc_Vldtn_Ops.object_Version_Number%TYPE;

5: P_Business_Group_Id In Number) is
6:
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;

Line 10: l_Wrkplc_Vldtn_Op_Id Pqh_De_Wrkplc_Vldtn_Ops.Wrkplc_Vldtn_Op_Id%TYPE;

6:
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;

Line 32: From Pqh_De_Wrkplc_Vldtn_Ops

28: b.Business_Group_Id = a.Business_Group_Id;
29:
30: Cursor Wrkplc_Vldtn_Oprs (p_WRKPLC_VLDTN_VER_ID In Number) is
31: Select WRKPLC_VLDTN_OP_ID, WRKPLC_OPERATION_ID, DESCRIPTION, UNIT_PERCENTAGE
32: From Pqh_De_Wrkplc_Vldtn_Ops
33: Where Wrkplc_Vldtn_Ver_Id = P_Wrkplc_Vldtn_Ver_Id and
34: Business_Group_id = P_Business_Group_Id;
35:
36: Cursor Wrkplc_Vldtn_Jobs (p_Wrkplc_Vldtn_Op_Id in Number) is

Line 167: From Pqh_De_Wrkplc_Vldtn_Ops

163: b.Business_Group_Id = a.Business_Group_Id;
164:
165: Cursor Wrkplc_Vldtn_Oprs (p_WRKPLC_VLDTN_VER_ID In Number) is
166: Select WRKPLC_VLDTN_OP_ID, WRKPLC_OPERATION_ID, DESCRIPTION, UNIT_PERCENTAGE, Object_Version_Number
167: From Pqh_De_Wrkplc_Vldtn_Ops
168: Where Wrkplc_Vldtn_Ver_Id = P_Wrkplc_Vldtn_Ver_Id and
169: Business_Group_id = P_Business_Group_Id;
170:
171: Cursor Wrkplc_Vldtn_Jobs (p_Wrkplc_Vldtn_Op_Id in Number) is

Line 274: From Pqh_De_Wrkplc_Vldtn_Ops

270: P_Business_Group_Id In Number) is
271:
272: Cursor Wrkplc_Vldtn_Oprs is
273: Select WRKPLC_VLDTN_OP_ID, WRKPLC_OPERATION_ID, DESCRIPTION, UNIT_PERCENTAGE, Object_Version_Number
274: From Pqh_De_Wrkplc_Vldtn_Ops
275: Where WRKPLC_VLDTN_OP_ID = P_WRKPLC_VLDTN_OP_ID and
276: Business_Group_id = P_Business_Group_Id;
277:
278: Cursor Wrkplc_Vldtn_Jobs (p_Wrkplc_Vldtn_Op_Id in Number) is