APPS.IGI_SIA dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 110: From AP_INVOICE_DISTRIBUTIONS_ALL

106: -- Added cancellation functionality, check sum(amount) = 0 for all dist. lines
107:
108: CURSOR c IS
109: Select 1
110: From AP_INVOICE_DISTRIBUTIONS_ALL
111: Where Invoice_id = p_inv_id
112: AND NVL(match_status_flag,'N') <> 'A';
113:
114: CURSOR c1(p_hold VARCHAR2) IS

Line 123: From AP_INVOICE_DISTRIBUTIONS_ALL

119: And release_lookup_code is null;
120:
121: CURSOR c2 IS
122: Select sum(nvl(amount,0))
123: From AP_INVOICE_DISTRIBUTIONS_ALL
124: Where Invoice_id = p_inv_id;
125:
126: CURSOR c3 IS
127: Select hold_lookup_code

Line 134: From AP_INVOICE_DISTRIBUTIONS_ALL

130: And hold_lookup_code = 'AWAIT_PAY_APP';
131:
132: CURSOR c4 IS
133: Select COUNT(1)
134: From AP_INVOICE_DISTRIBUTIONS_ALL
135: Where Invoice_id = p_inv_id
136: and reversal_flag = 'Y';
137:
138: l_hold_lookup_code AP_HOLDS.hold_lookup_code%TYPE;