[Home] [Help]
1011: AND je.reference_1 = cdl.batch_name
1012: AND cdl.expenditure_item_id = ei.expenditure_item_id
1013: AND ei.expenditure_id = e.expenditure_id;
1014: -- Variables for Dynamic Cursor
1015: l_recipient_name po_vendors.vendor_name%type ;
1016: l_elim_dept VARCHAR2(7);
1017: l_govt_non_govt_ind VARCHAR2(1);
1018: --l_reference_2 gl_je_lines.reference_1%TYPE;
1019: --l_reference_5 gl_je_lines.reference_1%TYPE;
1076: l_vendor_type ,
1077: l_elim_dept ,
1078: l_recipient_name
1079: FROM ap_invoices_all i,
1080: po_vendors v
1081: WHERE i.invoice_id = to_number(p_reference_2)
1082: AND i.vendor_id = v.vendor_id;
1083:
1084: l_cust_vend_type := 'V';
1129: l_vendor_type ,
1130: l_elim_dept ,
1131: l_recipient_name
1132: FROM rcv_transactions rt,
1133: po_vendors v ,
1134: po_headers_all ph
1135: WHERE rt.po_header_id = to_number(p_reference_2)
1136: AND rt.transaction_id = to_number(p_reference_5)
1137: AND rt.po_header_id = ph.po_header_id
1180: INTO l_vendor_id,
1181: l_vendor_type ,
1182: l_elim_dept ,
1183: l_recipient_name
1184: FROM po_vendors v,
1185: po_headers_all poh
1186: WHERE poh.po_header_id = to_number(p_reference_2)
1187: AND v.vendor_id = poh.vendor_id;
1188:
1288: INTO l_vendor_id,
1289: l_vendor_type ,
1290: l_elim_dept ,
1291: l_recipient_name
1292: FROM po_vendors v
1293: WHERE v.vendor_id=l_vendor_id;
1294:
1295: l_cust_vend_type := 'V';
1296: END IF;
1333: l_vendor_type ,
1334: l_elim_dept ,
1335: l_recipient_name
1336: FROM ap_checks_all apc,
1337: po_vendors v
1338: WHERE apc.vendor_id = v.vendor_id
1339: AND apc.check_id = to_number(p_reference_3);
1340:
1341: l_cust_vend_type := 'V';