DBA Data[Home] [Help]

APPS.PQH_TKT_BUS dependencies on PER_GEN_HIERARCHY_NODES

Line 232: select '1' from per_gen_hierarchy_nodes

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