APPS.OKL_SUBSIDY_PROCESS_PVT dependencies on OKC_K_HEADERS_B

Line 75: from okc_k_headers_b chrb,

71:
72: --cursor to find that chr id is valid okl contract header id
73: cursor l_chr_csr (p_chr_id in number) is
74: select 'Y'
75: from okc_k_headers_b chrb,
76: okc_subclasses_b scsb
77: where chrb.id = p_chr_id
78: and scsb.code = chrb.scs_code
79: and scsb.cls_code = 'OKL';

Line 125: okc_k_headers_b chrb,

121: p_lty_code in varchar2) is
122: select 'Y'
123: from okc_k_lines_b cleb,
124: okc_line_styles_b lseb,
125: okc_k_headers_b chrb,
126: okc_subclasses_b scsb
127: where chrb.id = cleb.dnz_chr_id
128: and scsb.code = chrb.scs_code
129: and scsb.cls_code = 'OKL'

Line 1010: FROM okc_k_headers_b chr,

1006: chr.start_date,
1007: khr.deal_type,
1008: khr.term_duration,
1009: NVL(khr.generate_accrual_yn, 'Y')
1010: FROM okc_k_headers_b chr,
1011: okl_k_headers khr
1012: WHERE khr.id = p_khr_id
1013: AND chr.id = khr.id;
1014:

Line 1850: l_contract_currency okc_k_headers_b.currency_code%TYPE;

1846: p_round_yn IN VARCHAR2 DEFAULT OKL_API.G_TRUE,
1847: x_converted_amount OUT NOCOPY NUMBER,
1848: x_return_status OUT NOCOPY VARCHAR2) is
1849:
1850: l_contract_currency okc_k_headers_b.currency_code%TYPE;
1851: l_currency_conversion_type okl_k_headers.currency_conversion_type%TYPE;
1852: l_currency_conversion_rate okl_k_headers.currency_conversion_rate%TYPE;
1853: l_currency_conversion_date okl_k_headers.currency_conversion_date%TYPE;
1854: l_converted_subsidy_amount Number;

Line 4276: l_bill_to_site_use_id OKC_K_HEADERS_B.bill_to_site_use_id%TYPE;

4272: l_par_id NUMBER;
4273: l_rgd_id NUMBER;
4274: l_party_name VARCHAR2(1000);
4275:
4276: l_bill_to_site_use_id OKC_K_HEADERS_B.bill_to_site_use_id%TYPE;
4277: l_cust_acct_id OKC_K_PARTY_ROLES_B.cust_acct_id%TYPE;
4278: l_party_role FND_LOOKUPS.meaning%TYPE;
4279:
4280: ----------------------------------------------------------------------------

Line 4314: Okc_k_Headers_b Par,

4310: cPl.Bill_To_Site_Use_Id Bill_To_Site_Use_Id,
4311: -- cPl.ROLE ParACty_Role,
4312: cPl.cUst_acct_Id cUst_acct_Id
4313: FROM Okl_k_Headers khr,
4314: Okc_k_Headers_b Par,
4315: Okc_Rule_Groups_v rgd,
4316: Okc_k_Party_Roles_b cPl
4317: WHERE khr.Id = cp_khr_Id
4318: AND Par.Id = khr.khr_Id

Line 4929: l_bill_to_site_use_id OKC_K_HEADERS_B.bill_to_site_use_id%TYPE;

4925: lx_tilv_tbl okl_til_pvt.tilv_tbl_type;
4926: lx_tldv_tbl okl_tld_pvt.tldv_tbl_type;
4927:
4928: --Varangan - Billing Enhancement changes - Bug#5874824 - End
4929: l_bill_to_site_use_id OKC_K_HEADERS_B.bill_to_site_use_id%TYPE;
4930: l_cust_acct_id OKC_K_PARTY_ROLES_B.cust_acct_id%TYPE;
4931: l_payment_method_id Number;
4932: l_bank_account_id Number;
4933: l_inv_reason_for_review Varchar2(450);

Line 7293: l_bill_to_site_use_id OKC_K_HEADERS_B.bill_to_site_use_id%TYPE;

7289: lx_taiv_rec okl_trx_ar_invoices_pub.taiv_rec_type;
7290: lx_tilv_rec okl_txl_ar_inv_lns_pub.tilv_rec_type;
7291: lx_bpd_acc_rec okl_acc_call_pub.bpd_acc_rec_type;
7292:
7293: l_bill_to_site_use_id OKC_K_HEADERS_B.bill_to_site_use_id%TYPE;
7294: l_cust_acct_id OKC_K_PARTY_ROLES_B.cust_acct_id%TYPE;
7295: l_payment_method_id Number;
7296: l_bank_account_id Number;
7297: l_inv_reason_for_review Varchar2(450);

Line 7326: FROM okc_k_headers_b CHRB,

7322: cursor l_chk_rbk_csr(p_chr_id IN NUMBER) is
7323: SELECT 'Y',
7324: chrb.orig_system_id1,
7325: ktrx.date_transaction_occurred
7326: FROM okc_k_headers_b CHRB,
7327: okl_trx_contracts ktrx
7328: WHERE ktrx.khr_id_new = chrb.id
7329: AND ktrx.tsu_code = 'ENTERED'
7330: AND ktrx.rbr_code is NOT NULL

Line 7339: l_orig_chr_id okc_k_headers_b.id%TYPE;

7335: AND CHRB.id = p_chr_id
7336: AND CHRB.ORIG_SYSTEM_SOURCE_CODE = 'OKL_REBOOK';
7337:
7338: l_rebook_cpy varchar2(1) default 'N';
7339: l_orig_chr_id okc_k_headers_b.id%TYPE;
7340: l_rebook_date date;
7341:
7342: l_try_id number;
7343: