APPS.AP_IAW_PKG dependencies on AP_HOLDS_ALL

Line 3494: INSERT INTO AP_HOLDS_all(

3490:
3491:
3492: begin
3493: --Bug5148334 added select list
3494: INSERT INTO AP_HOLDS_all(
3495: INVOICE_ID,
3496: LINE_LOCATION_ID,
3497: HOLD_LOOKUP_CODE,
3498: LAST_UPDATE_DATE,

Line 3776: from ap_holds_all h

3772: -- po_matched: driven by line_location_id
3773: and ( il.po_line_location_id is null
3774: or (exists
3775: (select h.line_location_id
3776: from ap_holds_all h
3777: where h.invoice_id = l_invoice_id
3778: and h.org_id = l_org_id
3779: and il.po_line_location_id = h.line_location_id
3780: and h.status_flag = 'S'

Line 3817: from ap_holds_all

3813: itemkey,
3814: 'INVOICE_ID');
3815: select count(*)
3816: into l_num
3817: from ap_holds_all
3818: where invoice_id = l_invoice_id
3819: and org_id = l_org_id
3820: and hold_lookup_code in ('QTY REC', 'AMT REC');
3821:

Line 5196: UPDATE ap_holds_all

5192: l_release_lookup_code := 'NEGOTIATION AND APPROVED';
5193: END IF;
5194:
5195: IF ( l_release_lookup_code is not null ) THEN
5196: UPDATE ap_holds_all
5197: SET release_lookup_code = l_release_lookup_code,
5198: release_reason = (SELECT description
5199: FROM ap_lookup_codes
5200: WHERE lookup_code = l_release_lookup_code