DBA Data[Home] [Help]

APPS.PQH_OPL_BUS dependencies on PER_GEN_HIERARCHY_NODES

Line 233: select '1' from per_gen_hierarchy_nodes

229: Procedure Chk_delete
230: (p_rec in pqh_opl_shd.g_rec_type) is
231: l_proc varchar2(72) := g_package||'Ckh_Delete';
232: Cursor Del is
233: select '1' from per_gen_hierarchy_nodes
234: where NODE_TYPE = 'OPR_OPTS'
235: and entity_id = p_rec.OPERATION_NUMBER;
236: l_Status Varchar2(1);
237: Begin