DBA Data[Home] [Help]

APPS.JAI_AP_TDS_GENERATION_PKG dependencies on JAI_CMN_VENDOR_SITES

Line 3296: from JAI_CMN_VENDOR_SITES

3292: where invoice_id = p_invoice_id;
3293:
3294: cursor c_ja_in_po_vendor_sites(p_vendor_id number, p_vendor_site_id number) is
3295: select nvl( approved_invoice_flag, 'N' ) approved_invoice_flag
3296: from JAI_CMN_VENDOR_SITES
3297: where vendor_id = p_vendor_id
3298: and vendor_site_id = p_vendor_site_id;
3299:
3300:

Line 3306: lv_approved_invoice_flag JAI_CMN_VENDOR_SITES.approved_invoice_flag%type;

3302:
3303: lb_result boolean;
3304: ln_import_request_id number;
3305: ln_approve_request_id number;
3306: lv_approved_invoice_flag JAI_CMN_VENDOR_SITES.approved_invoice_flag%type;
3307: lv_batch_name ap_batches_all.batch_name%TYPE; --added by Ramananda for Bug#4584221
3308: lv_group_id VARCHAR2(80); --Added by Sanjikum for Bug#5131075(4722011)
3309:
3310: begin