APPS.PAY_EVG_BUS dependencies on PAY_EVENT_GROUP_USAGES
Line 366: -- Only interested in child rows from PAY_EVENT_GROUP_USAGES.
362: procedure chk_delete
363: (p_event_group_id in number
364: ) is
365: -- 366: -- Only interested in child rows from PAY_EVENT_GROUP_USAGES. 367: --
368: cursor csr_child_exist
369: (p_event_group_id in number
370: ) is
Line 372: from pay_event_group_usages egu
368: cursor csr_child_exist
369: (p_event_group_id in number
370: ) is
371: select 'Y' 372: from pay_event_group_usages egu 373: where egu.event_group_id = p_event_group_id;
374: --
375: l_ret varchar2(1);
376: begin