DBA Data[Home] [Help]

APPS.JAI_PA_TAX_PKG dependencies on PA_CUST_REV_DIST_LINES_ALL

Line 756: from pa_cust_rev_dist_lines_all pdida

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: );

Line 767: from pa_cust_rev_dist_lines_all pdida

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: );