DBA Data[Home] [Help]

APPS.AP_ACCOUNTING_EVENTS_PKG dependencies on AP_HOLDS

Line 4632: FROM ap_holds H, ap_hold_codes C

4628: IF p_doc_type = INVOICES_ENTITY THEN -- Bug3343314
4629: BEGIN
4630: SELECT count(*)
4631: INTO l_count
4632: FROM ap_holds H, ap_hold_codes C
4633: WHERE H.invoice_id = p_source_id
4634: AND H.hold_lookup_code = C.hold_lookup_code
4635: AND ((H.release_lookup_code IS NULL)
4636: AND (C.postable_flag = 'N'

Line 4649: FROM ap_holds H, ap_hold_codes C

4645: BEGIN
4646:
4647: SELECT count(*)
4648: INTO l_count
4649: FROM ap_holds H, ap_hold_codes C
4650: WHERE H.invoice_id in (SELECT invoice_id
4651: FROM ap_invoice_payments
4652: WHERE check_id = p_source_id)
4653: AND H.hold_lookup_code = C.hold_lookup_code