205: SELECT count(*) INTO l_count
206: FROM
207: pay_input_values_f piv,
208: pay_element_types_f pet,
209: cn_quota_pay_elements cqpe,
210: gl_sets_of_books glsob,
211: cn_repositories cnr
212: where
213: cnr.set_of_books_id = glsob.set_of_books_id
790: piv.name pay_value_name,
791: piv.display_sequence line_number,
792: cpei.quota_pay_element_id quota_pay_element_id
793: FROM cn_pay_element_inputs cpei,
794: cn_quota_pay_elements cqpe,
795: pay_input_values_f piv,
796: pay_element_types_f pet,
797: cn_objects ct,
798: cn_objects cc,
824: 0 quota_pay_element_id
825: FROM
826: pay_input_values_f piv,
827: pay_element_types_f pet,
828: cn_quota_pay_elements cqpe,
829: gl_sets_of_books glsob,
830: cn_repositories cnr
831: where
832: cnr.set_of_books_id = glsob.set_of_books_id