eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_EGU_BUS dependencies on PAY_EVENT_GROUPS

Line 317: -- Validates that the event_group_id exists in pay_event_groups

313: -- |--------------------------< chk_event_group_id >--------------------------|
314: -- ----------------------------------------------------------------------------
315: --
316: -- Description:
317: -- Validates that the event_group_id exists in pay_event_groups
318: --
319: -- Pre-Requisites:
320: -- None
321: --

Line 348: from pay_event_groups peg

344: ) is
345: --
346: cursor csr_event_group_id is
347: select peg.legislation_code , peg.business_group_id
348: from pay_event_groups peg
349: where peg.event_group_id = p_event_group_id ;
350: --
351: l_busgrpid PAY_EVENT_GROUPS.BUSINESS_GROUP_ID%TYPE;
352: l_legcode PAY_EVENT_GROUPS.LEGISLATION_CODE%TYPE;

Line 351: l_busgrpid PAY_EVENT_GROUPS.BUSINESS_GROUP_ID%TYPE;

347: select peg.legislation_code , peg.business_group_id
348: from pay_event_groups peg
349: where peg.event_group_id = p_event_group_id ;
350: --
351: l_busgrpid PAY_EVENT_GROUPS.BUSINESS_GROUP_ID%TYPE;
352: l_legcode PAY_EVENT_GROUPS.LEGISLATION_CODE%TYPE;
353:
354: l_proc varchar2(100) := g_package || 'chk_event_group_id';
355: begin

Line 352: l_legcode PAY_EVENT_GROUPS.LEGISLATION_CODE%TYPE;

348: from pay_event_groups peg
349: where peg.event_group_id = p_event_group_id ;
350: --
351: l_busgrpid PAY_EVENT_GROUPS.BUSINESS_GROUP_ID%TYPE;
352: l_legcode PAY_EVENT_GROUPS.LEGISLATION_CODE%TYPE;
353:
354: l_proc varchar2(100) := g_package || 'chk_event_group_id';
355: begin
356: