APPS.PQH_DE_OPERATION dependencies on PQH_DE_WRKPLC_VLDTN_OPS

Line 94: l_Wrkplc_Vldtn_Op_Id Pqh_de_Wrkplc_Vldtn_ops.Wrkplc_Vldtn_Op_Id%TYPE;

90:
91: l_Hierarchy_Node_Id Per_Gen_Hierarchy_nodes.Hierarchy_node_Id%TYPE;
92: l_desc Pqh_De_Operations.Description%TYPE;
93: l_Job_Id Pqh_de_Tatigkeit_details.TATIGKEIT_DETAIL_ID%TYPE;
94: l_Wrkplc_Vldtn_Op_Id Pqh_de_Wrkplc_Vldtn_ops.Wrkplc_Vldtn_Op_Id%TYPE;
95: l_WRKPLC_VLDTN_JObFTR_ID Pqh_de_Wrkplc_Vldtn_JobFtrs.WRKPLC_VLDTN_JObFTR_ID%TYPE;
96: l_Object_Version_Number Pqh_de_Wrkplc_Vldtn_ops.Object_Version_Number%TYPE;
97: l_Wrkplc_Vldtn_Job_Id Pqh_de_Wrkplc_Vldtn_Jobs.Wrkplc_Vldtn_Job_Id%TYPE;
98:

Line 96: l_Object_Version_Number Pqh_de_Wrkplc_Vldtn_ops.Object_Version_Number%TYPE;

92: l_desc Pqh_De_Operations.Description%TYPE;
93: l_Job_Id Pqh_de_Tatigkeit_details.TATIGKEIT_DETAIL_ID%TYPE;
94: l_Wrkplc_Vldtn_Op_Id Pqh_de_Wrkplc_Vldtn_ops.Wrkplc_Vldtn_Op_Id%TYPE;
95: l_WRKPLC_VLDTN_JObFTR_ID Pqh_de_Wrkplc_Vldtn_JobFtrs.WRKPLC_VLDTN_JObFTR_ID%TYPE;
96: l_Object_Version_Number Pqh_de_Wrkplc_Vldtn_ops.Object_Version_Number%TYPE;
97: l_Wrkplc_Vldtn_Job_Id Pqh_de_Wrkplc_Vldtn_Jobs.Wrkplc_Vldtn_Job_Id%TYPE;
98:
99:
100: /* Cursor Operations is

Line 253: From Pqh_de_operations a, Pqh_De_Wrkplc_Vldtn_Ops b

249: l_seq Per_Gen_Hierarchy_nodes.Seq%TYPE;
250:
251: Cursor Operations is
252: Select WRKPLC_VLDTN_OP_ID, OPERATION_NUMBER, WRKPLC_OPERATION_ID
253: From Pqh_de_operations a, Pqh_De_Wrkplc_Vldtn_Ops b
254: Where WRKPLC_VLDTN_VER_ID = p_WRKPLC_VLDTN_VER_ID
255: and a.Operation_Id = WRKPLC_OPERATION_ID;
256:
257: Cursor Jobs(p_WRKPLC_VLDTN_OP_ID in Number) is