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_NO_SUPPORT_ORDER dependencies on PAY_ELEMENT_TYPE_EXTRA_INFO

Line 177: from pay_element_type_extra_info

173:
174: /*
175: CURSOR csr_element_info_iv (l_ele_type_id NUMBER) IS
176: select EEI_INFORMATION2 , EEI_INFORMATION3 , EEI_INFORMATION4
177: from pay_element_type_extra_info
178: where ELEMENT_TYPE_ID = l_ele_type_id ;
179: */
180:
181: CURSOR csr_element_info_iv (l_ele_type_id NUMBER) IS

Line 183: from pay_element_type_extra_info

179: */
180:
181: CURSOR csr_element_info_iv (l_ele_type_id NUMBER) IS
182: select EEI_INFORMATION2 , EEI_INFORMATION3 , EEI_INFORMATION4
183: from pay_element_type_extra_info
184: where ELEMENT_TYPE_ID = l_ele_type_id
185: and INFORMATION_TYPE = 'NO_EMPLOYEE_DEDUCTION_REPORT';
186:
187:

Line 207: ,pay_element_type_extra_info info

203: ,info.ELEMENT_TYPE_EXTRA_INFO_ID info_id
204: ,info.EEI_INFORMATION5 def_bal_id
205:
206: from pay_element_types_f ele
207: ,pay_element_type_extra_info info
208: ,pay_input_values_f ipv1
209: ,pay_input_values_f ipv2
210:
211: where ele.ELEMENT_TYPE_ID = p_ele_type_id

Line 212: -- for pay_element_type_extra_info

208: ,pay_input_values_f ipv1
209: ,pay_input_values_f ipv2
210:
211: where ele.ELEMENT_TYPE_ID = p_ele_type_id
212: -- for pay_element_type_extra_info
213: AND info.ELEMENT_TYPE_ID = ele.ELEMENT_TYPE_ID
214: AND info.INFORMATION_TYPE = 'NO_EMPLOYEE_DEDUCTION_REPORT'
215:
216: -- for input value Third Party Payee

Line 228: select nvl((select eei_information1 from pay_element_type_extra_info petei

224:
225: --cursor to get element code
226: cursor csr_ele_code(p_ele_type_id NUMBER
227: ,p_leg_emp_id varchar2) is
228: select nvl((select eei_information1 from pay_element_type_extra_info petei
229: where petei.information_type='NO_ELEMENT_CODES'
230: and element_type_id = p_ele_type_id
231: and petei.eei_information2 = p_leg_emp_id
232: and rownum=1),

Line 233: (select eei_information1 from pay_element_type_extra_info petei

229: where petei.information_type='NO_ELEMENT_CODES'
230: and element_type_id = p_ele_type_id
231: and petei.eei_information2 = p_leg_emp_id
232: and rownum=1),
233: (select eei_information1 from pay_element_type_extra_info petei
234: where petei.information_type='NO_ELEMENT_CODES'
235: and element_type_id = p_ele_type_id
236: and eei_information2 is null
237: and rownum=1)) from dual;