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_ELEMENT_SETS

Line 211: -- Validates that the element_set_id exists in pay_element_sets

207: -- |--------------------------< chk_element_set_id >--------------------------|
208: -- ----------------------------------------------------------------------------
209: --
210: -- Description:
211: -- Validates that the element_set_id exists in pay_element_sets
212: --
213: -- Pre-Requisites:
214: -- None
215: --

Line 242: from pay_element_sets pes

238: ) is
239: --
240: cursor csr_element_set_id is
241: select pes.legislation_code , pes.business_group_id, pes.element_set_type
242: from pay_element_sets pes
243: where pes.element_set_id = p_element_set_id ;
244: --
245: l_busgrpid PAY_ELEMENT_SETS.BUSINESS_GROUP_ID%TYPE;
246: l_legcode PAY_ELEMENT_SETS.LEGISLATION_CODE%TYPE;

Line 245: l_busgrpid PAY_ELEMENT_SETS.BUSINESS_GROUP_ID%TYPE;

241: select pes.legislation_code , pes.business_group_id, pes.element_set_type
242: from pay_element_sets pes
243: where pes.element_set_id = p_element_set_id ;
244: --
245: l_busgrpid PAY_ELEMENT_SETS.BUSINESS_GROUP_ID%TYPE;
246: l_legcode PAY_ELEMENT_SETS.LEGISLATION_CODE%TYPE;
247: l_ele_set_type PAY_ELEMENT_SETS.ELEMENT_SET_TYPE%TYPE;
248:
249: l_proc varchar2(100) := g_package || 'chk_element_set_id';

Line 246: l_legcode PAY_ELEMENT_SETS.LEGISLATION_CODE%TYPE;

242: from pay_element_sets pes
243: where pes.element_set_id = p_element_set_id ;
244: --
245: l_busgrpid PAY_ELEMENT_SETS.BUSINESS_GROUP_ID%TYPE;
246: l_legcode PAY_ELEMENT_SETS.LEGISLATION_CODE%TYPE;
247: l_ele_set_type PAY_ELEMENT_SETS.ELEMENT_SET_TYPE%TYPE;
248:
249: l_proc varchar2(100) := g_package || 'chk_element_set_id';
250: begin

Line 247: l_ele_set_type PAY_ELEMENT_SETS.ELEMENT_SET_TYPE%TYPE;

243: where pes.element_set_id = p_element_set_id ;
244: --
245: l_busgrpid PAY_ELEMENT_SETS.BUSINESS_GROUP_ID%TYPE;
246: l_legcode PAY_ELEMENT_SETS.LEGISLATION_CODE%TYPE;
247: l_ele_set_type PAY_ELEMENT_SETS.ELEMENT_SET_TYPE%TYPE;
248:
249: l_proc varchar2(100) := g_package || 'chk_element_set_id';
250: begin
251: