APPS.OKL_CURE_CALC_PVT dependencies on OKC_K_HEADERS_B

Line 501: l_contract_number okc_k_headers_b.contract_number%TYPE;

497: select refund_amount_due
498: from okl_cure_refunds_dtls_uv
499: where contract_id =p_contract_id;
500:
501: l_contract_number okc_k_headers_b.contract_number%TYPE;
502:
503:
504: -- ASHIM CHANGE - START
505:

Line 683: l_contract_number okc_k_headers_b.contract_number%TYPE;

679:
680: -- ASHIM CHANGE - END
681:
682:
683: l_contract_number okc_k_headers_b.contract_number%TYPE;
684: l_rule_name VARCHAR2(200);
685: l_rule_value VARCHAR2(2000);
686: l_return_Status VARCHAR2(1):=FND_Api.G_RET_STS_SUCCESS;
687: l_id1 VARCHAR2(40);

Line 833: FROM okc_k_headers_b

829:
830: --dkagrawa added following cursor to get the org_id MOAC Issue
831: CURSOR c_get_org_id (p_contract_id IN NUMBER) IS
832: SELECT org_id
833: FROM okc_k_headers_b
834: WHERE id = p_contract_id;
835:
836: l_qte_id okl_cure_amounts.qte_id%TYPE;
837:

Line 1289: FROM okc_k_headers_b prog,

1285: ,prog.contract_number program_number
1286: ,lease.id contract_id
1287: ,lease.contract_number contract_number
1288: ,rgp.rgd_code
1289: FROM okc_k_headers_b prog,
1290: okc_k_headers_b lease,
1291: okl_k_headers khr,
1292: okc_rule_groups_b rgp
1293: WHERE khr.id = lease.id

Line 1290: okc_k_headers_b lease,

1286: ,lease.id contract_id
1287: ,lease.contract_number contract_number
1288: ,rgp.rgd_code
1289: FROM okc_k_headers_b prog,
1290: okc_k_headers_b lease,
1291: okl_k_headers khr,
1292: okc_rule_groups_b rgp
1293: WHERE khr.id = lease.id
1294: AND khr.khr_id = prog.id

Line 1361: ,okc_k_headers_b chr

1357: /*cursor l_days_past_due_cur (p_contract_id IN NUMBER) is
1358: SELECT min(aps.due_date)
1359: FROM okl_cnsld_ar_strms_b ocas
1360: ,ar_payment_schedules aps
1361: ,okc_k_headers_b chr
1362: ,OKL_STRM_TYPE_TL SM
1363: WHERE
1364: ocas.khr_id = p_contract_id
1365: AND ocas.receivables_invoice_id = aps.customer_trx_id

Line 1377: ,okc_k_headers_b chr

1373: is
1374: SELECT min(aps.due_date)
1375: FROM okl_bpd_tld_ar_lines_v ocas
1376: ,ar_payment_schedules aps
1377: ,okc_k_headers_b chr
1378: ,OKL_STRM_TYPE_TL SM
1379: WHERE ocas.khr_id = p_contract_id
1380: AND ocas.customer_trx_id = aps.customer_trx_id
1381: AND aps.class = 'INV'

Line 1391: x_contract_number okc_k_headers_b.contract_number%TYPE;

1387: -- ASHIM CHANGE - END
1388:
1389:
1390:
1391: x_contract_number okc_k_headers_b.contract_number%TYPE;
1392:
1393: l_default_date DATE :=TRUNC(SYSDATE);
1394: l_days_past DATE ;
1395: