APPS.OKL_BPD_ADVANCED_BILLING_PVT dependencies on OKC_K_HEADERS_B

Line 314: FROM okc_k_headers_b

310: IS
311: --modified by pgomes on 21-aug-2003 for rules migration
312: CURSOR get_khr_id_csr ( p_contract_number VARCHAR2 ) IS
313: SELECT cust_acct_id
314: FROM okc_k_headers_b
315: where contract_number = p_contract_number;
316:
317: --commented out by pgomes on 21-aug-2003 for rules migration
318: BEGIN

Line 450: FROM OKC_K_HEADERS_B CHR,

446: where id = p_cle_id;
447:
448: CURSOR derive_top_line_id (p_lsm_id NUMBER) IS
449: SELECT FA.ID
450: FROM OKC_K_HEADERS_B CHR,
451: OKC_K_LINES_B TOP_CLE,
452: OKC_LINE_STYLES_b TOP_LSE,
453: OKC_K_LINES_B SUB_CLE,
454: OKC_LINE_STYLES_b SUB_LSE,

Line 522: CURSOR get_sales_rep(p_contract_number okc_k_headers_b.contract_number%TYPE) IS

518: FROM ra_salesreps
519: WHERE SALESREP_ID = p_salesrep_id;
520:
521: --cursor to fetch the sales rep for the contract.
522: CURSOR get_sales_rep(p_contract_number okc_k_headers_b.contract_number%TYPE) IS
523: SELECT contact.object1_id1
524: FROM okc_k_headers_b hdr, okc_contacts contact
525: WHERE contact.dnz_chr_id = hdr.id
526: AND hdr.contract_number = p_contract_number

Line 524: FROM okc_k_headers_b hdr, okc_contacts contact

520:
521: --cursor to fetch the sales rep for the contract.
522: CURSOR get_sales_rep(p_contract_number okc_k_headers_b.contract_number%TYPE) IS
523: SELECT contact.object1_id1
524: FROM okc_k_headers_b hdr, okc_contacts contact
525: WHERE contact.dnz_chr_id = hdr.id
526: AND hdr.contract_number = p_contract_number
527: AND contact.cro_code = 'SALESPERSON';
528:

Line 910: l_khr_id okc_k_headers_b.id%type;

906: l_group_by_contract_yn okl_invoice_types_v.group_by_contract_yn%type;
907: l_group_asset_yn okl_invoice_types_v.group_asset_yn%type;
908: l_contract_level_yn okl_invoice_formats_v.contract_level_yn%type;
909: l_invoice_group okl_invoice_formats_v.name%type;
910: l_khr_id okc_k_headers_b.id%type;
911: x_tax_det_rec OKL_PROCESS_SALES_TAX_PVT.tax_det_rec_type;
912: l_api_version NUMBER := 1.0;
913: x_msg_count NUMBER;
914: x_msg_data VARCHAR2(4000);

Line 940: FROM OKC_K_HEADERS_B CHR,

936: where id = p_cle_id;
937:
938: CURSOR derive_top_line_id (p_lsm_id NUMBER) IS
939: SELECT FA.ID
940: FROM OKC_K_HEADERS_B CHR,
941: OKC_K_LINES_B TOP_CLE,
942: OKC_LINE_STYLES_b TOP_LSE,
943: OKC_K_LINES_B SUB_CLE,
944: OKC_LINE_STYLES_b SUB_LSE,

Line 1643: okc_k_headers_b c

1639: --gkhuntet - FP Bug 5516814..start
1640: CURSOR c_get_adv_rcpt_for_cont(cp_cont_number IN VARCHAR2) IS
1641: SELECT DISTINCT c.contract_number
1642: FROM okl_trx_csh_rcpt_all_b a, okl_txl_rcpt_apps_b b,
1643: okc_k_headers_b c
1644: WHERE a.FULLY_APPLIED_FLAG = 'N'
1645: AND a.receipt_type = 'ADV'
1646: AND a.id = b.rct_id_details
1647: AND b.khr_id = c.id

Line 1670: l_khr_id okc_k_headers_b.id%type;

1666: l_group_by_contract_yn okl_invoice_types_v.group_by_contract_yn%type;
1667: l_group_asset_yn okl_invoice_types_v.group_asset_yn%type;
1668: l_contract_level_yn okl_invoice_formats_v.contract_level_yn%type;
1669: l_invoice_group okl_invoice_formats_v.name%type;
1670: l_khr_id okc_k_headers_b.id%type;
1671:
1672: CURSOR acc_sys_option is
1673: select account_derivation
1674: from okl_sys_acct_opts;

Line 2074: FROM okc_k_headers_b

2070: l_bkr_khr_id NUMBER;
2071:
2072: CURSOR c_get_khr_id(p_contract_nbr VARCHAR2) IS
2073: SELECT id
2074: FROM okc_k_headers_b
2075: WHERE contract_number = p_contract_nbr;
2076:
2077: BEGIN
2078: