APPS.OKL_VENDOR_REFUND_PVT dependencies on OKC_K_HEADERS_B

Line 538: FROM okc_k_headers_b prog,

534: ,lease.id contract_id
535: ,lease.contract_number contract_number
536: ,rgp.rgd_code
537: ,pty.object1_id1 vendor_id
538: FROM okc_k_headers_b prog,
539: okc_k_headers_b lease,
540: okl_k_headers khr,
541: okc_rule_groups_b rgp,
542: okc_k_party_roles_v pty,

Line 539: okc_k_headers_b lease,

535: ,lease.contract_number contract_number
536: ,rgp.rgd_code
537: ,pty.object1_id1 vendor_id
538: FROM okc_k_headers_b prog,
539: okc_k_headers_b lease,
540: okl_k_headers khr,
541: okc_rule_groups_b rgp,
542: okc_k_party_roles_v pty,
543: OKX_VENDORS_V vnd

Line 624: ,okc_k_headers_b chr

620: /*cursor l_days_past_due_cur (p_contract_id IN NUMBER) is
621: SELECT min(aps.due_date)
622: FROM okl_cnsld_ar_strms_b ocas
623: ,ar_payment_schedules_all aps
624: ,okc_k_headers_b chr
625: WHERE
626: ocas.khr_id = p_contract_id
627: AND ocas.receivables_invoice_id = aps.customer_trx_id
628: AND aps.class = 'INV'

Line 646: ,okc_k_headers_b chr

642: cursor l_days_past_due_cur (p_contract_id IN NUMBER) is
643: SELECT min(aps.due_date)
644: FROM okl_bpd_tld_ar_lines_v ocas
645: ,ar_payment_schedules_all aps
646: ,okc_k_headers_b chr
647: WHERE
648: ocas.khr_id = p_contract_id
649: AND ocas.customer_trx_id = aps.customer_trx_id
650: AND aps.class = 'INV'

Line 672: x_contract_number okc_k_headers_b.contract_number%TYPE;

668:
669: -- ASHIM CHANGE - END
670:
671:
672: x_contract_number okc_k_headers_b.contract_number%TYPE;
673: l_default_date DATE :=TRUNC(SYSDATE);
674: l_days_past DATE ;
675: BEGIN
676: okl_debug_pub.logmessage('OKL_VENDOR_REFUND_PVT : GENERATE_VENDOR_REFUND : START ');