DBA Data[Home] [Help]

APPS.JL_ZZ_AP_LIBRARY_1_PKG dependencies on AP_INVOICE_DISTRIBUTIONS

Line 257: from ap_invoice_distributions

253: Begin
254: errcd := 0;
255: select nvl(max(distribution_line_number),0)
256: into max_dist_line_num
257: from ap_invoice_distributions
258: where invoice_id = invoiceid
259: -- Commented out as unnecessary - iswillia (08-OCT-1999)
260: --and rownum = row_number
261: -- End of Commented out portion - iswillia (08-OCT-1999)

Line 293: SELECT ap_invoice_distributions_s.nextval

289:
290: BEGIN
291:
292: Begin
293: SELECT ap_invoice_distributions_s.nextval
294: INTO l_invoice_distribution_id
295: FROM dual;
296:
297: Exception

Line 397: FROM ap_invoice_distributions

393: Begin
394: errcd := 0;
395: SELECT count(*)
396: Into tot_rec
397: FROM ap_invoice_distributions
398: WHERE invoice_id = invoiceid
399: AND line_type_lookup_code IN ('ICMS','IPI');
400: Exception
401: When Others Then

Line 545: FROM ap_invoice_distributions

541: Begin
542: errcd := 0;
543: SELECT count(*)
544: Into tot_rec
545: FROM ap_invoice_distributions
546: WHERE invoice_id = invoiceid
547: AND line_type_lookup_code = 'ITEM';
548: Exception
549: When Others Then

Line 591: from ap_invoice_distributions

587: Begin
588: errcd := 0;
589: select count(*)
590: into tot_rec
591: from ap_invoice_distributions
592: where invoice_id = invoiceid
593: and awt_invoice_id is not null;
594: Exception
595: When Others Then

Line 710: from jl_br_ap_tax_calendar_lines j, ap_invoice_distributions a

706: Begin
707: errcd := 0;
708: select j.due_date
709: into duedt
710: from jl_br_ap_tax_calendar_lines j, ap_invoice_distributions a
711: where a.invoice_id = invoiceid
712: and j.tax_calendar_name = taxcal_name
713: and a.accounting_date between j.start_date and j.end_date
714: and sysdate < nvl(j.inactive_date,sysdate+1) and rownum = row_number;