APPS.OKL_SEEDED_FUNCTIONS_PVT dependencies on OKL_TRX_AP_INVOICES_B

Line 2254: FROM okl_trx_ap_invoices_b A

2250: /*
2251: CURSOR C (p_contract_id NUMBER)
2252: IS
2253: SELECT NVL(SUM(A.amount),0)
2254: FROM okl_trx_ap_invoices_b A
2255: ,okl_txl_ap_inv_lns_all_b B
2256: WHERE A.id = B.tap_id
2257: AND B.khr_id = p_contract_id
2258: AND A.funding_type_code = 'PREFUNDING'

Line 2317: FROM okl_trx_ap_invoices_b A

2313: /*
2314: CURSOR C (p_contract_id NUMBER)
2315: IS
2316: SELECT NVL(SUM(A.amount),0)
2317: FROM okl_trx_ap_invoices_b A
2318: ,okl_Txl_ap_inv_lns_all_b B
2319: WHERE A.id = B.tap_id
2320: AND B.khr_id = p_contract_id
2321: AND A.funding_type_code = 'PREFUNDING'

Line 2378: FROM okl_trx_ap_invoices_b A

2374: /*
2375: CURSOR C (p_contract_id NUMBER)
2376: IS
2377: SELECT NVL(SUM(A.amount),0)
2378: FROM okl_trx_ap_invoices_b A
2379: ,okl_txl_ap_inv_lns_all_b B
2380: WHERE A.id = B.TAP_ID
2381: AND A.khr_id = p_contract_id
2382: AND A.funding_type_code NOT IN ('SUPPLIER_RETENTION', 'MANUAL_DISB')

Line 2437: FROM okl_trx_ap_invoices_b A,

2433: /*
2434: CURSOR C (p_contract_id NUMBER)
2435: IS
2436: SELECT NVL(SUM(B.amount),0)
2437: FROM okl_trx_ap_invoices_b A,
2438: okl_txl_ap_inv_lns_all_b B
2439: WHERE A.id = B.tap_id
2440: AND B.khr_id = p_contract_id
2441: AND A.trx_status_code IN ('APPROVED', 'PROCESSED')

Line 10396: FROM OKL_TRX_AP_INVOICES_B TAP

10392:
10393: CURSOR c_disb_tot IS
10394: SELECT TAP.AMOUNT,
10395: TAP.KHR_ID
10396: FROM OKL_TRX_AP_INVOICES_B TAP
10397: WHERE TAP.TRX_STATUS_CODE IN ('APPROVED','PROCESSED') -- push to AP
10398: AND TAP.FUNDING_TYPE_CODE IS NOT NULL
10399: -- start: cklee - okl.h ER 05/25/2005
10400: AND NOT EXISTS (SELECT 1

Line 10487: FROM OKL_TRX_AP_INVOICES_B TAP,

10483: -- 2. the modified code will multiply the header amount if mutliple lines found
10484:
10485: CURSOR c_disb_tot(p_credit_id number) IS
10486: SELECT NVL(SUM(TAP.AMOUNT),0)
10487: FROM OKL_TRX_AP_INVOICES_B TAP,
10488: -- okl_txl_ap_inv_lns_all_b tpl,
10489: (
10490: select gov.dnz_chr_id chr_id,
10491: crd.ID credit_id

Line 10618: FROM OKL_TRX_AP_INVOICES_B TAP

10614: /*
10615: CURSOR c_disb_tot IS
10616: SELECT TAP.AMOUNT,
10617: TPL.KHR_ID
10618: FROM OKL_TRX_AP_INVOICES_B TAP
10619: ,OKL_TXL_AP_INV_LNS_ALL_B TPL
10620: WHERE TAP.ID = TPL.TAP_ID
10621: AND TAP.TRX_STATUS_CODE IN ('APPROVED','PROCESSED') -- push to AP
10622: AND TAP.FUNDING_TYPE_CODE IS NOT NULL

Line 10638: FROM OKL_TRX_AP_INVOICES_B TAP

10634:
10635: CURSOR c_disb_tot IS
10636: SELECT TAP.AMOUNT,
10637: TAP.KHR_ID
10638: FROM OKL_TRX_AP_INVOICES_B TAP
10639: where TAP.TRX_STATUS_CODE IN ('APPROVED','PROCESSED') -- push to AP
10640: AND TAP.FUNDING_TYPE_CODE IS NOT NULL
10641: -- start: cklee - okl.h ER 05/25/2005
10642: AND NOT EXISTS (SELECT 1

Line 13737: FROM okl_trx_ap_invoices_b

13733: AND primary_quote = 'Y';
13734:
13735: CURSOR c_get_fund_amount(p_contract_line_id IN NUMBER) IS
13736: SELECT nvl(amount, 0)
13737: FROM okl_trx_ap_invoices_b
13738: WHERE id = p_contract_line_id;
13739: --AND trx_status_code = 'ENTERED'
13740: --AND FUNDING_TYPE_CODE IN ('PREFUNDING', 'ASSET', 'EXPENSE');
13741:

Line 13958: FROM okl_trx_ap_invoices_b a

13954: -- sjalasut, modified the cursor to have p_contract_id mapped to okl_txl_ap_inv_lns_all_b
13955: -- changes made as part of OKLR12B disbursements project.
13956: CURSOR c_k_funding_date IS
13957: SELECT a.date_invoiced
13958: FROM okl_trx_ap_invoices_b a
13959: -- ,okl_txl_ap_inv_lns_all_b b --cklee 09/21/07
13960: -- WHERE a.id = b.tap_id
13961: where a.khr_id = p_contract_id;
13962: