DBA Data[Home] [Help]

APPS.JL_ZZ_TAX dependencies on AR_MEMO_LINES

Line 546: FROM ar_memo_lines ml

542: CURSOR c_memo_line IS
543: SELECT ml.tax_code,
544: NULL,
545: ml.memo_line_id
546: FROM ar_memo_lines ml
547: WHERE ml.memo_line_id = p_memo_line_id
548: AND exists (select 1
549: from ar_vat_tax vt
550: WHERE ml.tax_code = vt.tax_code

Line 565: FROM ar_memo_lines ml

561: UNION
562: SELECT tg.tax_code,
563: NULL,
564: ml.memo_line_id
565: FROM ar_memo_lines ml
566: ,ar_vat_tax vt
567: ,jl_zz_ar_tx_groups tg
568: ,ar_vat_tax vt1
569: WHERE memo_line_id = p_memo_line_id