111: CURSOR get_wps_element_name
112: (p_element_type_id IN NUMBER
113: )
114: IS
115: SELECT element_name FROM pay_element_types_f
116: WHERE element_type_id = p_element_type_id
117: AND rownum=1;
118:
119: TYPE t_number IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
191: ,p_scheme_name IN VARCHAR2
192: )
193: IS
194: SELECT peev.screen_entry_value
195: FROM pay_element_types_f pet
196: ,pay_element_entries_f pee
197: ,pay_element_type_extra_info pete
198: ,pay_element_entry_values_f peev
199: ,pay_input_values_f piv