752: select count(distinct expenditure_type)
753: from pa_expenditure_items_all peia
754: where peia.expenditure_item_id in
755: ( select expenditure_item_id
756: from pa_cust_rev_dist_lines_all pdida
757: where pdida.project_id = pn_project_id and
758: pdida.draft_invoice_num = pn_draft_invoice_num and
759: pdida.draft_invoice_item_line_num = pn_line_num
760: );
763: select distinct expenditure_type
764: from pa_expenditure_items_all peia
765: where peia.expenditure_item_id in
766: ( select expenditure_item_id
767: from pa_cust_rev_dist_lines_all pdida
768: where pdida.project_id = pn_project_id and
769: pdida.draft_invoice_num = pn_draft_invoice_num and
770: pdida.draft_invoice_item_line_num = pn_line_num
771: );