APPS.FV_1219_TRANSACTIONS dependencies on AP_CHECKS_ALL

Line 2350: FROM ap_checks_all

2346: ELSE
2347: BEGIN
2348: SELECT 'Y'
2349: INTO l_exists
2350: FROM ap_checks_all
2351: WHERE check_id = to_number(l_REFERENCE_3)
2352: AND org_id = p_def_org_id;
2353:
2354: EXCEPTION

Line 2360: 'FROM AP_CHECKS_ALL WITH REF_3, HENCE MANUAL');

2356: l_name := 'MANUAL';
2357: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2358: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
2359: ' NO_DATA_FOUND WHEN SELECTING '||
2360: 'FROM AP_CHECKS_ALL WITH REF_3, HENCE MANUAL');
2361: END IF;
2362:
2363: WHEN INVALID_NUMBER OR VALUE_ERROR THEN
2364: l_name := 'MANUAL';

Line 2463: FROM ap_checks_all

2459: ELSE
2460: BEGIN
2461: SELECT 'Y'
2462: INTO l_exists
2463: FROM ap_checks_all
2464: WHERE check_id = to_number(l_REFERENCE_3)
2465: AND org_id = p_def_org_id;
2466:
2467: EXCEPTION

Line 2475: ' SELECTING FROM AP_CHECKS_ALL '||

2471: FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2472: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
2473: l_module_name,
2474: ' NO_DATA_FOUND WHEN '||
2475: ' SELECTING FROM AP_CHECKS_ALL '||
2476: ' WITH REF_3, HENCE MANUAL');
2477: END IF;
2478:
2479: WHEN INVALID_NUMBER OR VALUE_ERROR THEN

Line 3063: FROM ap_checks_all apc,

3059: INTO l_invoice_id ,
3060: l_vendor_id,
3061: l_inv_amount,
3062: l_check_date
3063: FROM ap_checks_all apc,
3064: ap_invoices_all api
3065: WHERE api.invoice_id = NVL(l_reference, 0)
3066: AND apc.check_id = to_number(l_reference_3)
3067: AND l_payables_ia_paygroup = api.pay_group_lookup_code

Line 3106: ap_checks_all aca,

3102: BEGIN
3103: SELECT cba.agency_location_code
3104: INTO l_temp_alc_code
3105: FROM ap_invoice_payments_all aip,
3106: ap_checks_all aca,
3107: ce_bank_accounts cba,
3108: ce_bank_acct_uses_all cbau
3109: WHERE TO_CHAR(aip.invoice_id) = l_reference_2
3110: AND aca.check_id = l_reference_3

Line 3501: FROM ap_checks_all apc,

3497: SELECT nvl(apc.treasury_pay_date,apc.check_date),
3498: apc.void_date
3499: INTO l_accomplish_date,
3500: l_void_date
3501: FROM ap_checks_all apc,
3502: ap_invoices_all api
3503: WHERE api.invoice_id = Nvl(l_reference, 0)
3504: AND apc.check_id = nvl(l_reference_3,0)
3505: AND apc.org_id = p_def_org_id

Line 3675: FROM ap_checks_all

3671: BEGIN
3672:
3673: SELECT void_date
3674: INTO l_accomplish_date
3675: FROM ap_checks_all
3676: WHERE TO_CHAR(check_id) = NVL(l_reference_3,'0')
3677: ANd org_id = p_def_org_id;
3678:
3679: SELECT invoice_date into l_invoice_date