DBA Data[Home] [Help]

APPS.PAY_NO_SUPPORT_ORDER dependencies on PAY_ELEMENT_TYPES_F

Line 157: FROM pay_element_types_f

153:
154: -- cursor to get the element name
155: CURSOR csr_element_name (l_ele_type_id NUMBER) IS
156: SELECT element_name
157: FROM pay_element_types_f
158: WHERE ELEMENT_TYPE_ID = l_ele_type_id ;
159: --AND LEGISLATION_CODE = 'NO' ;
160:
161: /* Bug Fix 5110016 : New cursor csr_reporting_name added for getting the reporting name of the element */

Line 166: FROM pay_element_types_f

162:
163: -- cursor to get the reporting name for element
164: CURSOR csr_reporting_name (l_ele_type_id NUMBER) IS
165: SELECT nvl(REPORTING_NAME , ELEMENT_NAME)
166: FROM pay_element_types_f
167: WHERE ELEMENT_TYPE_ID = l_ele_type_id ;
168:
169:
170: /* Bug Fix 5110016 : Added INFORMATION_TYPE check in the cursor csr_element_info_iv. */

Line 206: from pay_element_types_f ele

202: ,ipv2.INPUT_VALUE_ID ipv2_id -- Pay Value
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: