DBA Data[Home] [Help]

APPS.PQH_DE_OPERATION dependencies on PQH_DE_WRKPLC_VLDTN_JOBFTRS

Line 95: l_WRKPLC_VLDTN_JObFTR_ID Pqh_de_Wrkplc_Vldtn_JobFtrs.WRKPLC_VLDTN_JObFTR_ID%TYPE;

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:
99:

Line 267: From Pqh_De_Wrkplc_Vldtn_Jobftrs

263:
264: Cursor JobFtrs(p_WRKPLC_VLDTN_OPR_JOB_ID In Number, Type In Varchar2) Is
265: Select WRKPLC_VLDTN_JOBFTR_ID, WRKPLC_VLDTN_OPR_JOB_ID
266: JOB_FEATURE_CODE, WRKPLC_VLDTN_OPR_JOB_TYPE
267: From Pqh_De_Wrkplc_Vldtn_Jobftrs
268: Where WRKPLC_VLDTN_OPR_JOB_ID = p_WRKPLC_VLDTN_OPR_JOB_ID
269: and WRKPLC_VLDTN_OPR_JOB_TYPE = Type;
270:
271: Cursor Hierarchy_Data(p_Entity_Id In VARCHAR2, P_Node_Type in Varchar2) is