DBA Data[Home] [Help]

APPS.JAI_PA_TAX_PKG dependencies on PA_EXPENDITURE_ITEMS_ALL

Line 719: from pa_expenditure_items_all peia

715: ----------------cursor declarations------------------------------
716: -- count different types of expenditure defined in invoices lines
717: cursor cur_count_expend_type is
718: select count(distinct expenditure_type)
719: from pa_expenditure_items_all peia
720: where peia.expenditure_item_id in
721: ( select expenditure_item_id
722: from pa_cust_rev_dist_lines_all pdida
723: where pdida.project_id = pn_project_id and

Line 730: from pa_expenditure_items_all peia

726: );
727: -- find out expenditure type if invoice lines contains same type of expenditure type
728: cursor cur_expend_type is
729: select distinct expenditure_type
730: from pa_expenditure_items_all peia
731: where peia.expenditure_item_id in
732: ( select expenditure_item_id
733: from pa_cust_rev_dist_lines_all pdida
734: where pdida.project_id = pn_project_id and