DBA Data[Home] [Help]

APPS.JAI_AP_TDS_GENERATION_PKG dependencies on JAI_CMN_VENDOR_SITES

Line 2099: from JAI_CMN_VENDOR_SITES

2095: where invoice_id = p_invoice_id;
2096:
2097: cursor c_ja_in_po_vendor_sites(p_vendor_id number, p_vendor_site_id number) is
2098: select nvl( approved_invoice_flag, 'N' ) approved_invoice_flag
2099: from JAI_CMN_VENDOR_SITES
2100: where vendor_id = p_vendor_id
2101: and vendor_site_id = p_vendor_site_id;
2102:
2103:

Line 2109: lv_approved_invoice_flag JAI_CMN_VENDOR_SITES.approved_invoice_flag%type;

2105:
2106: lb_result boolean;
2107: ln_import_request_id number;
2108: ln_approve_request_id number;
2109: lv_approved_invoice_flag JAI_CMN_VENDOR_SITES.approved_invoice_flag%type;
2110: lv_batch_name ap_batches_all.batch_name%TYPE; --added by Ramananda for Bug#4584221
2111: lv_group_id VARCHAR2(80); --Added by Sanjikum for Bug#5131075(4722011)
2112:
2113: begin