DBA Data[Home] [Help]

APPS.JA_ZZ_VALIDATE_INVOICE_GDF dependencies on RA_CUSTOMER_TRX_LINES

Line 687: ra_customer_trx_lines tl

683: CURSOR c_cnt_tax_codes_tx(x_customer_trx_id NUMBER) IS
684: SELECT
685: COUNT(DISTINCT tl.vat_tax_id)
686: FROM
687: ra_customer_trx_lines tl
688: WHERE
689: tl.customer_trx_id = x_customer_trx_id
690: AND tl.line_type = 'TAX'; -- Bug 2753541
691: BEGIN

Line 985: FROM ra_customer_trx_lines l,

981:
982: IF p_created_from = 'ARXTWMAI' THEN
983: SELECT count(l.customer_trx_line_id)
984: INTO n
985: FROM ra_customer_trx_lines l,
986: -- Bug 4756219
987: -- Changing reference to ar vat tax to zx_mco_rates
988: zx_mco_rates v,
989: zx_accounts a