APPS.OKL_SEEDED_FUNCTIONS_PVT dependencies on OKL_TRX_AP_INVOICES_B

Line 2718: FROM okl_trx_ap_invoices_b A

2714: /*
2715: CURSOR C (p_contract_id NUMBER)
2716: IS
2717: SELECT NVL(SUM(A.amount),0)
2718: FROM okl_trx_ap_invoices_b A
2719: ,okl_txl_ap_inv_lns_all_b B
2720: WHERE A.id = B.tap_id
2721: AND B.khr_id = p_contract_id
2722: AND A.funding_type_code = 'PREFUNDING'

Line 2781: FROM okl_trx_ap_invoices_b A

2777: /*
2778: CURSOR C (p_contract_id NUMBER)
2779: IS
2780: SELECT NVL(SUM(A.amount),0)
2781: FROM okl_trx_ap_invoices_b A
2782: ,okl_Txl_ap_inv_lns_all_b B
2783: WHERE A.id = B.tap_id
2784: AND B.khr_id = p_contract_id
2785: AND A.funding_type_code = 'PREFUNDING'

Line 2842: FROM okl_trx_ap_invoices_b A

2838: /*
2839: CURSOR C (p_contract_id NUMBER)
2840: IS
2841: SELECT NVL(SUM(A.amount),0)
2842: FROM okl_trx_ap_invoices_b A
2843: ,okl_txl_ap_inv_lns_all_b B
2844: WHERE A.id = B.TAP_ID
2845: AND A.khr_id = p_contract_id
2846: AND A.funding_type_code NOT IN ('SUPPLIER_RETENTION', 'MANUAL_DISB')

Line 2901: FROM okl_trx_ap_invoices_b A,

2897: /*
2898: CURSOR C (p_contract_id NUMBER)
2899: IS
2900: SELECT NVL(SUM(B.amount),0)
2901: FROM okl_trx_ap_invoices_b A,
2902: okl_txl_ap_inv_lns_all_b B
2903: WHERE A.id = B.tap_id
2904: AND B.khr_id = p_contract_id
2905: AND A.trx_status_code IN ('APPROVED', 'PROCESSED')

Line 11333: FROM OKL_TRX_AP_INVOICES_B TAP

11329:
11330: CURSOR c_disb_tot IS
11331: SELECT TAP.AMOUNT,
11332: TAP.KHR_ID
11333: FROM OKL_TRX_AP_INVOICES_B TAP
11334: WHERE TAP.TRX_STATUS_CODE IN ('APPROVED','PROCESSED') -- push to AP
11335: AND TAP.FUNDING_TYPE_CODE IS NOT NULL
11336: -- start: cklee - okl.h ER 05/25/2005
11337: AND NOT EXISTS (SELECT 1

Line 11424: FROM OKL_TRX_AP_INVOICES_B TAP,

11420: -- 2. the modified code will multiply the header amount if mutliple lines found
11421:
11422: CURSOR c_disb_tot(p_credit_id number) IS
11423: SELECT NVL(SUM(TAP.AMOUNT),0)
11424: FROM OKL_TRX_AP_INVOICES_B TAP,
11425: -- okl_txl_ap_inv_lns_all_b tpl,
11426: (
11427: select gov.dnz_chr_id chr_id,
11428: crd.ID credit_id

Line 11557: FROM OKL_TRX_AP_INVOICES_B TAP

11553: /*
11554: CURSOR c_disb_tot IS
11555: SELECT TAP.AMOUNT,
11556: TPL.KHR_ID
11557: FROM OKL_TRX_AP_INVOICES_B TAP
11558: ,OKL_TXL_AP_INV_LNS_ALL_B TPL
11559: WHERE TAP.ID = TPL.TAP_ID
11560: AND TAP.TRX_STATUS_CODE IN ('APPROVED','PROCESSED') -- push to AP
11561: AND TAP.FUNDING_TYPE_CODE IS NOT NULL

Line 11577: FROM OKL_TRX_AP_INVOICES_B TAP

11573:
11574: CURSOR c_disb_tot IS
11575: SELECT TAP.AMOUNT,
11576: TAP.KHR_ID
11577: FROM OKL_TRX_AP_INVOICES_B TAP
11578: where TAP.TRX_STATUS_CODE IN ('APPROVED','PROCESSED') -- push to AP
11579: AND TAP.FUNDING_TYPE_CODE IS NOT NULL
11580: -- start: cklee - okl.h ER 05/25/2005
11581: AND NOT EXISTS (SELECT 1

Line 14969: FROM okl_trx_ap_invoices_b

14965: AND primary_quote = 'Y';
14966:
14967: CURSOR c_get_fund_amount(p_contract_line_id IN NUMBER) IS
14968: SELECT nvl(amount, 0)
14969: FROM okl_trx_ap_invoices_b
14970: WHERE id = p_contract_line_id;
14971: --AND trx_status_code = 'ENTERED'
14972: --AND FUNDING_TYPE_CODE IN ('PREFUNDING', 'ASSET', 'EXPENSE');
14973:

Line 15190: FROM okl_trx_ap_invoices_b a

15186: -- sjalasut, modified the cursor to have p_contract_id mapped to okl_txl_ap_inv_lns_all_b
15187: -- changes made as part of OKLR12B disbursements project.
15188: CURSOR c_k_funding_date IS
15189: SELECT a.date_invoiced
15190: FROM okl_trx_ap_invoices_b a
15191: -- ,okl_txl_ap_inv_lns_all_b b --cklee 09/21/07
15192: -- WHERE a.id = b.tap_id
15193: where a.khr_id = p_contract_id;
15194: