DBA Data[Home] [Help]

APPS.JAI_PA_TAX_PKG dependencies on PA_CUST_REV_DIST_LINES_ALL

Line 722: from pa_cust_rev_dist_lines_all pdida

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
724: pdida.draft_invoice_num = pn_draft_invoice_num and
725: pdida.draft_invoice_item_line_num = pn_line_num
726: );

Line 733: from pa_cust_rev_dist_lines_all pdida

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
735: pdida.draft_invoice_num = pn_draft_invoice_num and
736: pdida.draft_invoice_item_line_num = pn_line_num
737: );