APPS.OKL_PAY_INVOICES_CONS_PVT dependencies on OKL_CNSLD_AP_INVS_ALL

Line 538: l_invoice_date okl_cnsld_ap_invs_all.date_invoiced%type := p_transaction_date;

534: ,p_stream_type_purpose IN VARCHAR2
535: ,p_adv_grouping_flag IN VARCHAR2 -- reserved for future use
536: ) RETURN DATE IS
537:
538: l_invoice_date okl_cnsld_ap_invs_all.date_invoiced%type := p_transaction_date;
539: l_disb_rules disb_rules_type;
540: lx_rule_found BOOLEAN := FALSE;
541: lx_return_status VARCHAR2(30) := G_RET_STS_SUCCESS;
542:

Line 2362: CURSOR c_no_adv_grp(p_cnsld_ap_invs_id okl_cnsld_ap_invs_all.cnsld_ap_inv_id%type) IS

2358: i NUMBER;
2359:
2360: /*
2361: -- find existing 'no further processing" flag
2362: CURSOR c_no_adv_grp(p_cnsld_ap_invs_id okl_cnsld_ap_invs_all.cnsld_ap_inv_id%type) IS
2363: SELECT 1
2364: FROM OKL_TRX_AP_INVS_ALL_B TAP
2365: where NVL(TAP.ADV_GROUPING_FLAG, 'Y') = 'N'
2366: and tap.id in

Line 2369: okl_cnsld_ap_invs_all cin

2365: where NVL(TAP.ADV_GROUPING_FLAG, 'Y') = 'N'
2366: and tap.id in
2367: (select txl.tap_id
2368: from okl_txl_ap_invs_all_b txl,
2369: okl_cnsld_ap_invs_all cin
2370: where txl.cnsld_ap_inv_id = tap.cnsld_ap_inv_id
2371: and txl.tap_id = tap.id);
2372: */
2373:

Line 2376: FROM OKL_CNSLD_AP_INVS_ALL

2372: */
2373:
2374: CURSOR c_cnsld_hdr IS
2375: SELECT *
2376: FROM OKL_CNSLD_AP_INVS_ALL
2377: WHERE trx_status_code = 'ENTERED';
2378:
2379: l_row_found BOOLEAN;
2380: -- r_no_adv_grp c_no_adv_grp%ROWTYPE;

Line 2593: FROM OKL_CNSLD_AP_INVS_ALL

2589: -- CURSOR c_cnsld_hdr(p_date_from IN DATE,
2590: -- p_to_date IN DATE) IS
2591: CURSOR c_cnsld_hdr IS
2592: SELECT *
2593: FROM OKL_CNSLD_AP_INVS_ALL
2594: WHERE trx_status_code = 'ENTERED';
2595: --start: 24-APR-2007 cklee -- Disbursement changes for R12B, bug fixed: |
2596: -- AND date_invoiced BETWEEN
2597: -- p_from_date AND p_to_date;