APPS.JAI_AP_OI_PROCESSING_PKG dependencies on JAI_CMN_VENDOR_SITES

Line 18: from JAI_CMN_VENDOR_SITES

14: where invoice_id = p_invoice_id;
15:
16: cursor c_ja_in_po_vendor_sites(p_vendor_id number, p_vendor_site_id number) is
17: select nvl( approved_tds_flag, 'N' ) approved_invoice_flag
18: from JAI_CMN_VENDOR_SITES
19: where vendor_id = p_vendor_id
20: and vendor_site_id = p_vendor_site_id;
21:
22: r_ap_invoices_all c_ap_invoices_all%rowtype;

Line 23: lv_approved_invoice_flag JAI_CMN_VENDOR_SITES.approved_tds_flag%type;

19: where vendor_id = p_vendor_id
20: and vendor_site_id = p_vendor_site_id;
21:
22: r_ap_invoices_all c_ap_invoices_all%rowtype;
23: lv_approved_invoice_flag JAI_CMN_VENDOR_SITES.approved_tds_flag%type;
24: begin
25:
26: open c_ap_invoices_all(p_invoice_id);
27: fetch c_ap_invoices_all into r_ap_invoices_all;