DBA Data[Home] [Help]

APPS.JL_ZZ_SH_LIBRARY_1_PKG dependencies on AP_LOOKUP_CODES

Line 12: from ap_lookup_codes lc,ap_tax_codes tc

8: Begin
9: errcd := 0;
10: select count(*)
11: into tot_rec
12: from ap_lookup_codes lc,ap_tax_codes tc
13: where lc.lookup_type = 'TAX TYPE'
14: and tc.tax_type = 'ICMS'
15: and lc.lookup_code = tc.tax_type
16: and sysdate < nvl(lc.inactive_date, sysdate+1)