APPS.JL_ZZ_AP_LIBRARY_1_PKG dependencies on AP_INVOICES

Line 144: FROM ap_invoices

140: Begin
141: errcd := 0;
142: SELECT substr(global_attribute10,1,38)
143: INTO cons_inv_num
144: FROM ap_invoices
145: WHERE invoice_id = invoiceid and rownum = row_number;
146: Exception
147: When Others Then
148: errcd := sqlcode;

Line 159: from ap_invoices

155: Begin
156: errcd := 0;
157: select payment_status_flag
158: into pay_stat
159: from ap_invoices
160: where invoice_id = invoiceid and rownum = row_number;
161: Exception
162: When Others Then
163: errcd := sqlcode;

Line 364: FROM ap_invoices_v

360: l_last_Updated_By ,
361: l_last_Update_Login ,
362: l_creation_date,
363: l_created_by
364: FROM ap_invoices_v
365: where invoice_id = P_Invoice_id;
366: Exception When no_data_found then
367: null;
368: When others then

Line 607: from ap_invoices

603: Begin
604: errcd := 0;
605: select vendor_site_id
606: into vendsite_id
607: from ap_invoices
608: where invoice_id = invoiceid and rownum = row_number;
609: Exception
610: When Others Then
611: errcd := sqlcode;

Line 672: from jl_br_ap_tax_calendar_lines j, ap_invoices a

668: Begin
669: errcd := 0;
670: select j.due_date
671: into duedt
672: from jl_br_ap_tax_calendar_lines j, ap_invoices a
673: where a.invoice_id = invoiceid
674: and j.tax_calendar_name = taxcal_name
675: and a.terms_date between j.start_date and j.end_date
676: and sysdate < nvl(j.inactive_date,sysdate+1) and rownum = row_number;

Line 691: from jl_br_ap_tax_calendar_lines j, ap_invoices a

687: Begin
688: errcd := 0;
689: select j.due_date
690: into duedt
691: from jl_br_ap_tax_calendar_lines j, ap_invoices a
692: where a.invoice_id = invoiceid
693: and j.tax_calendar_name = taxcal_name
694: and a.invoice_date between j.start_date and j.end_date
695: and sysdate < nvl(j.inactive_date,sysdate+1) and rownum = row_number;

Line 903: from ap_invoices

899: Begin
900: errcd := 0;
901: select vendor_id
902: into vendor_id
903: from ap_invoices
904: where invoice_id = invoiceid and rownum = row_number;
905: Exception
906: When Others Then
907: errcd := sqlcode;