APPS.PQH_DE_OPERATION dependencies on DUAL

Line 63: into l_Hierarchy_Node_Id from Dual;

59: Where Hierarchy_Version_Id = l_Hierarchy_Version_Id
60: and Node_type = l_Node_Type;
61:
62: Select Per_Gen_Hierarchy_Nodes_s.nextval
63: into l_Hierarchy_Node_Id from Dual;
64:
65: Insert into
66: Per_Gen_Hierarchy_Nodes
67: (HIERARCHY_NODE_ID, BUSINESS_GROUP_ID, ENTITY_ID, HIERARCHY_VERSION_ID,

Line 311: Select Per_gen_Hierarchy_Nodes_s.Nextval into l_JHierarchy_Node_Id from Dual;

307: Open Hierarchy_Data(Jobrec.TATIGKEIT_NUMBER, 'OPR_JOB_DTLS');
308: Fetch Hierarchy_Data into l_Hierarchy_Node_Id, l_Hierarchy_Version_Id, l_Parent_Hierarchy_Node_Id, l_Node_type;
309: If Hierarchy_Data%NotFound Then
310: Close Hierarchy_Data;
311: Select Per_gen_Hierarchy_Nodes_s.Nextval into l_JHierarchy_Node_Id from Dual;
312: l_Seq := Null;
313: Open Seq(l_OprParent_Hierarchy_Node_Id,'OPR_JOB_DTLS');
314: Fetch Seq into l_Seq;
315: Close Seq;

Line 335: Select Per_gen_Hierarchy_Nodes_s.Nextval into l_Hierarchy_Node_Id from Dual;

331: Open Hierarchy_Data(Jobftrrec.JOB_FEATURE_CODE, 'OPR_JOB_FTR');
332: Fetch Hierarchy_Data into l_Hierarchy_Node_Id, l_Hierarchy_Version_Id, l_Parent_Hierarchy_Node_Id, l_Node_type;
333: If Hierarchy_Data%NotFound Then
334: Close HIerarchy_data;
335: Select Per_gen_Hierarchy_Nodes_s.Nextval into l_Hierarchy_Node_Id from Dual;
336: Open Seq(l_OprParent_Hierarchy_Node_Id,'OPR_JOB_DTLS');
337: Fetch Seq into l_Seq;
338: Close Seq;
339: Insert into

Line 365: Select Per_gen_Hierarchy_Nodes_s.Nextval into l_Hierarchy_Node_Id from Dual;

361: Open Hierarchy_Data(Jobftrrec.JOB_FEATURE_CODE, 'OPR_JOB_FTR');
362: Fetch Hierarchy_Data into l_Hierarchy_Node_Id, l_Hierarchy_Version_Id, l_Parent_Hierarchy_Node_Id, l_Node_type;
363: If Hierarchy_Data%NotFound Then
364: Close HIerarchy_data;
365: Select Per_gen_Hierarchy_Nodes_s.Nextval into l_Hierarchy_Node_Id from Dual;
366: Open Seq(l_OprParent_Hierarchy_Node_Id,'OPR_JOB_DTLS');
367: Fetch Seq into l_Seq;
368: Close Seq;
369: Insert Into