DBA Data[Home] [Help]

APPS.AP_ACCOUNTING_EVENTS_PKG dependencies on AP_HOLDS

Line 4062: FROM ap_holds H, ap_hold_codes C

4058: IF p_doc_type = INVOICES_ENTITY THEN -- Bug3343314
4059: BEGIN
4060: SELECT count(*)
4061: INTO l_count
4062: FROM ap_holds H, ap_hold_codes C
4063: WHERE H.invoice_id = p_source_id
4064: AND H.hold_lookup_code = C.hold_lookup_code
4065: AND ((H.release_lookup_code IS NULL)
4066: AND (C.postable_flag = 'N'

Line 4079: FROM ap_holds H, ap_hold_codes C

4075: BEGIN
4076:
4077: SELECT count(*)
4078: INTO l_count
4079: FROM ap_holds H, ap_hold_codes C
4080: WHERE H.invoice_id in (SELECT invoice_id
4081: FROM ap_invoice_payments
4082: WHERE check_id = p_source_id)
4083: AND H.hold_lookup_code = C.hold_lookup_code