APPS.IGI_SIA dependencies on AP_INVOICES

Line 17: from ap_invoices

13: /* bug # 5905278 start R12 uptake of SIA - query to fetch the org_id */
14: begin
15: select org_id
16: into v_org_id
17: from ap_invoices
18: where invoice_id = p_InvoiceId;
19: exception
20: when others then
21: null;

Line 232: -- AP_INVOICES_ALL calling REVERSE_HOLDS.

228: release_holds(p_inv_id,p_upd_by);
229: insert_sec_hold(p_inv_id,p_upd_by);
230: END IF;
231: END IF; -- If invoice is cancelled i.e sum = 0 then handle in trigger on
232: -- AP_INVOICES_ALL calling REVERSE_HOLDS.
233:
234: END IF; -- Bug 3409394 Start (2) Only END IF Condition
235:
236: -- if only secondary exists or any other hold exists don't do anything