APPS.ARP_REVERSE_RECEIPT dependencies on AR_MEMO_LINES_B

Line 1753: /* Bug 4684829 Changing AR_MEMO_LINES to AR_MEMO_LINES_B and AR_MEMO_LINES_TL

1749: --
1750: -- Get description to be used during RA_CUSTOMER_TRX_LINES insertion
1751: --
1752:
1753: /* Bug 4684829 Changing AR_MEMO_LINES to AR_MEMO_LINES_B and AR_MEMO_LINES_TL
1754: We can directly use ar_memo_lines_vl too but case bug for a bug in
1755: ar_memo_lines_vl is dtill pending. */
1756:
1757: SELECT REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(replace(T.description,

Line 1771: FROM ar_memo_lines_b B ,ar_memo_lines_tl T

1767: l_receipt_method_name ),
1768: '&'||'PAYMENT_METHOD'||'&',
1769: l_receipt_method_name )
1770: INTO l_description
1771: FROM ar_memo_lines_b B ,ar_memo_lines_tl T
1772: WHERE B.MEMO_LINE_ID = T.MEMO_LINE_ID
1773: AND NVL(B.ORG_ID, -99) = NVL(T.ORG_ID, -99)
1774: AND T.LANGUAGE = userenv('LANG')
1775: AND mo_global.check_access(B.ORG_ID) = 'Y'