DBA Data[Home] [Help]

APPS.JAI_AR_RCTA_TRIGGER_PKG dependencies on JAI_INTERFACE_LINES_ALL

Line 1486: jai_interface_lines_all intfs

1482: ------------------------------------------------------------------------------
1483: CURSOR get_external_flag_cur IS
1484: SELECT COUNT(lines.customer_trx_id)
1485: FROM jai_ar_trx_lines lines,
1486: jai_interface_lines_all intfs
1487: WHERE lines.customer_trx_line_id = intfs.internal_trx_line_id
1488: AND lines.customer_trx_id = pr_new.customer_trx_id
1489: AND lines.interface_flag = 'Y'
1490: AND intfs.taxable_event = 'EXTERNAL';

Line 1500: FROM jai_interface_lines_all

1496: AND interface_flag = 'Y';
1497:
1498: CURSOR get_vat_invoice_no_cur IS
1499: SELECT DISTINCT vat_invoice_no
1500: FROM jai_interface_lines_all
1501: WHERE internal_trx_id = pr_new.customer_trx_id;
1502:
1503:
1504: ln_open_source NUMBER;

Line 3826: jai_interface_lines_all intfs

3822: ------------------------------------------------------------------------------
3823: CURSOR get_external_flag_cur IS
3824: SELECT COUNT(lines.customer_trx_id)
3825: FROM jai_ar_trx_lines lines,
3826: jai_interface_lines_all intfs
3827: WHERE lines.customer_trx_line_id = intfs.internal_trx_line_id
3828: AND lines.customer_trx_id = v_header_id
3829: AND lines.interface_flag = 'Y'
3830: AND intfs.taxable_event = 'EXTERNAL';