APPS.JAI_AP_DTC_GENERATION_PKG dependencies on JAI_CMN_VENDOR_SITES

Line 7976: from JAI_CMN_VENDOR_SITES

7972: where invoice_id = p_invoice_id;
7973:
7974: cursor c_ja_in_po_vendor_sites(p_vendor_id number, p_vendor_site_id number) is
7975: select nvl( approved_invoice_flag, 'N' ) approved_invoice_flag
7976: from JAI_CMN_VENDOR_SITES
7977: where vendor_id = p_vendor_id
7978: and vendor_site_id = p_vendor_site_id;
7979:
7980:

Line 7986: lv_approved_invoice_flag JAI_CMN_VENDOR_SITES.approved_invoice_flag%type;

7982:
7983: lb_result boolean;
7984: ln_import_request_id number;
7985: ln_approve_request_id number;
7986: lv_approved_invoice_flag JAI_CMN_VENDOR_SITES.approved_invoice_flag%type;
7987: lv_batch_name ap_batches_all.batch_name%TYPE; --added by Ramananda for Bug#4584221
7988: lv_group_id VARCHAR2(80); --Added by Sanjikum for Bug#5131075(4722011)
7989: l_api_name CONSTANT VARCHAR2(50) := 'import_and_approve()';
7990: