DBA Data[Home] [Help]

APPS.JL_ZZ_TAX dependencies on AR_MEMO_LINES

Line 540: FROM ar_memo_lines ml

536: CURSOR c_memo_line IS
537: SELECT ml.tax_code,
538: NULL,
539: ml.memo_line_id
540: FROM ar_memo_lines ml
541: WHERE ml.memo_line_id = p_memo_line_id
542: AND exists (select 1
543: from ar_vat_tax vt
544: WHERE ml.tax_code = vt.tax_code

Line 558: FROM ar_memo_lines ml

554: UNION
555: SELECT tg.tax_code,
556: NULL,
557: ml.memo_line_id
558: FROM ar_memo_lines ml
559: ,ar_vat_tax vt
560: ,jl_zz_ar_tx_groups tg
561: ,ar_vat_tax vt1
562: WHERE memo_line_id = p_memo_line_id