DBA Data[Home] [Help]

APPS.AP_FUNDS_CONTROL_PKG dependencies on AP_HOLD_CODES

Line 608: ap_hold_codes C

604: AND D.po_distribution_id is NULL
605: AND (( D.match_status_flag = 'S')
606: AND (NOT EXISTS (SELECT 'X'
607: FROM ap_holds H,
608: ap_hold_codes C
609: WHERE H.invoice_id = D.invoice_id
610: AND H.line_location_id is null
611: AND H.hold_lookup_code = C.hold_lookup_code
612: AND ((H.release_lookup_code IS NULL)

Line 657: ap_hold_codes C

653: AND I.invoice_id = p_invoice_id
654: AND (( D.match_status_flag = 'S')
655: AND (NOT EXISTS (SELECT 'X'
656: FROM ap_holds H,
657: ap_hold_codes C
658: WHERE H.invoice_id = D.invoice_id
659: AND H.line_location_id is null
660: AND H.hold_lookup_code = C.hold_lookup_code
661: AND ((H.release_lookup_code IS NULL)

Line 715: ap_hold_codes C

711: AND T.po_distribution_id is NULL
712: AND (( T.match_status_flag = 'S')
713: AND (NOT EXISTS (SELECT 'X'
714: FROM ap_holds H,
715: ap_hold_codes C
716: WHERE H.invoice_id = T.invoice_id
717: AND H.line_location_id is null
718: AND H.hold_lookup_code = C.hold_lookup_code
719: AND ((H.release_lookup_code IS NULL)

Line 754: ap_hold_codes C

750: AND I.invoice_id = p_invoice_id
751: AND (( T.match_status_flag = 'S')
752: AND (NOT EXISTS (SELECT 'X'
753: FROM ap_holds H,
754: ap_hold_codes C
755: WHERE H.invoice_id = T.invoice_id
756: AND H.line_location_id is null
757: AND H.hold_lookup_code = C.hold_lookup_code
758: AND ((H.release_lookup_code IS NULL)