DBA Data[Home] [Help]

APPS.JAI_AP_STND_TAX_PROCESS dependencies on JAI_INTERFACE_LINES_ALL

Line 4857: jai_interface_lines_all intfs

4853: ------------------------------------------------------------------------------
4854: CURSOR get_external_flag_cur(pn_invoice_id NUMBER, pn_line_number NUMBER) IS
4855: SELECT COUNT(lines.invoice_id)
4856: FROM ap_invoice_lines_all lines,
4857: jai_interface_lines_all intfs
4858: WHERE lines.line_number = intfs.internal_trx_line_id
4859: AND lines.invoice_id = intfs.internal_trx_id
4860: AND lines.line_number = pn_line_number
4861: AND lines.invoice_id = pn_invoice_id

Line 4868: jai_interface_lines_all intfs

4864:
4865: CURSOR get_open_source_cur(pn_invoice_id NUMBER, pn_line_number NUMBER) IS
4866: SELECT COUNT(lines.invoice_id)
4867: FROM ap_invoice_lines_all lines,
4868: jai_interface_lines_all intfs
4869: WHERE lines.line_number = intfs.internal_trx_line_id
4870: AND lines.invoice_id = intfs.internal_trx_id
4871: AND lines.line_number = pn_line_number
4872: AND lines.invoice_id = pn_invoice_id