APPS.PQH_DE_OPERATION dependencies on PQH_DE_WRKPLC_VLDTN_JOBS

Line 97: l_Wrkplc_Vldtn_Job_Id Pqh_de_Wrkplc_Vldtn_Jobs.Wrkplc_Vldtn_Job_Id%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
101: Select Decode(Node_Type,'OPR_OPTS','O','OPR_JOB_DTLS','J','OPR_JOB_FTR','F'), Entity_Id

Line 260: From PQH_DE_TATIGKEIT_DETAILS a, Pqh_De_Wrkplc_Vldtn_JObs b

256:
257: Cursor Jobs(p_WRKPLC_VLDTN_OP_ID in Number) is
258: Select WRKPLC_VLDTN_JOB_ID, b.DESCRIPTION,
259: WRKPLC_JOB_ID, TATIGKEIT_NUMBER
260: From PQH_DE_TATIGKEIT_DETAILS a, Pqh_De_Wrkplc_Vldtn_JObs b
261: Where WRKPLC_VLDTN_OP_ID = p_WRKPLC_VLDTN_OP_ID
262: and a.TATIGKEIT_DETAIL_ID = WRKPLC_JOB_ID;
263:
264: Cursor JobFtrs(p_WRKPLC_VLDTN_OPR_JOB_ID In Number, Type In Varchar2) Is