2195: cursor c_footnote_info(p_balance_name varchar2) is
2196: select distinct pet.element_information19,
2197: pbt1.balance_name
2198: from pay_balance_feeds_f pbf,
2199: pay_balance_types pbt,
2200: pay_balance_types pbt1,
2201: pay_input_values_f piv,
2202: pay_element_types_f pet,
2203: fnd_lookup_values flv
2196: select distinct pet.element_information19,
2197: pbt1.balance_name
2198: from pay_balance_feeds_f pbf,
2199: pay_balance_types pbt,
2200: pay_balance_types pbt1,
2201: pay_input_values_f piv,
2202: pay_element_types_f pet,
2203: fnd_lookup_values flv
2204: where pbt.balance_name = p_balance_name