DBA Data[Home] [Help]

APPS.JAI_PA_TAX_PKG dependencies on PA_EXPENDITURE_ITEMS_ALL

Line 753: from pa_expenditure_items_all peia

749: ----------------cursor declarations------------------------------
750: -- count different types of expenditure defined in invoices lines
751: cursor cur_count_expend_type is
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

Line 764: from pa_expenditure_items_all peia

760: );
761: -- find out expenditure type if invoice lines contains same type of expenditure type
762: cursor cur_expend_type is
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