eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_LA_SALES_TAX_PVT dependencies on OKC_K_HEADERS_B

Line 20: CURSOR Product_csr (p_contract_id OKC_K_HEADERS_B.ID%TYPE)

16:
17: -- R12 - START
18:
19: -- Global Cursor to get contract header linformation
20: CURSOR Product_csr (p_contract_id OKC_K_HEADERS_B.ID%TYPE)
21: IS
22: SELECT khr.pdt_id product_id
23: ,NULL product_name
24: ,khr.sts_code contract_status

Line 259: l_chr_id okc_k_headers_b.id%TYPE;

255: l_rulv_rec rulv_rec_type;
256: lx_rgpv_rec rgpv_rec_type;
257: lx_rulv_rec rulv_rec_type;
258:
259: l_chr_id okc_k_headers_b.id%TYPE;
260: l_cle_id okc_k_lines_v.id%TYPE;
261: l_rgp_id NUMBER;
262:
263: lv_k_rule_information1 okc_rules_v.rule_information1%TYPE;

Line 270: CURSOR get_contract_deal_type(p_chr_id okc_k_headers_b.id%TYPE) IS

266: lv_k_rule_information5 okc_rules_v.rule_information5%TYPE;
267: lv_k_rule_information6 okc_rules_v.rule_information6%TYPE;
268: lv_k_rule_information7 okc_rules_v.rule_information7%TYPE;
269:
270: CURSOR get_contract_deal_type(p_chr_id okc_k_headers_b.id%TYPE) IS
271: select deal_type
272: from okl_k_headers
273: where deal_type = 'LOAN'
274: and id = p_chr_id;

Line 276: CURSOR get_contract_sales_tax_info(p_chr_id okc_k_headers_b.id%TYPE) IS

272: from okl_k_headers
273: where deal_type = 'LOAN'
274: and id = p_chr_id;
275:
276: CURSOR get_contract_sales_tax_info(p_chr_id okc_k_headers_b.id%TYPE) IS
277: SELECT rul.rule_information1, rul.rule_information3, rul.rule_information4,
278: rul.rule_information5, rul.rule_information6, rul.rule_information7
279: FROM OKC_RULES_V rul,
280: OKC_RULE_GROUPS_V rgp

Line 287: CURSOR l_hdr_upfront_tax(p_chr_id okc_k_headers_b.id%TYPE) IS

283: AND rgp.cle_id is NULL
284: AND rgp.rgd_code = 'LAHDTX'
285: AND rul.rule_information_category = 'LASTCL';
286:
287: CURSOR l_hdr_upfront_tax(p_chr_id okc_k_headers_b.id%TYPE) IS
288: SELECT rul.rule_information1
289: FROM OKC_RULES_V rul,
290: OKC_RULE_GROUPS_V rgp
291: WHERE rul.rgp_id = rgp.id

Line 297: CURSOR l_asset_tax_rule_group(p_chr_id okc_k_headers_b.id%TYPE,

293: AND rgp.cle_id is NULL
294: AND rgp.rgd_code = 'LAHDTX'
295: AND rul.rule_information_category = 'LASTPR';
296:
297: CURSOR l_asset_tax_rule_group(p_chr_id okc_k_headers_b.id%TYPE,
298: p_cle_id NUMBER) IS -- 5179119
299: SELECT id
300: FROM OKC_RULE_GROUPS_B rgp
301: WHERE rgp.dnz_chr_id = p_chr_id

Line 312: l_orig_system_source_code okc_k_headers_b.orig_system_source_code%type;

308: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_SALES_TAX_RULES';
309:
310: l_flag VARCHAR2(30) := 'XXXX';
311: l_deal_type okl_k_headers.deal_type%type;
312: l_orig_system_source_code okc_k_headers_b.orig_system_source_code%type;
313: l_header_upfront_tax okc_rules_v.rule_information1%TYPE;
314:
315: BEGIN
316:

Line 550: CURSOR get_contract_sales_tax_info(p_chr_id okc_k_headers_b.id%TYPE) IS

546: l_header_upfront_tax okc_rules_v.rule_information1%TYPE;
547:
548: l_api_name CONSTANT VARCHAR2(30) := 'SYNC_CONTRACT_SALES_TAX';
549:
550: CURSOR get_contract_sales_tax_info(p_chr_id okc_k_headers_b.id%TYPE) IS
551: SELECT rul.rule_information1, rul.rule_information3, rul.rule_information4,
552: rul.rule_information5, rul.rule_information6, rul.rule_information7
553: FROM OKC_RULES_V rul,
554: OKC_RULE_GROUPS_V rgp

Line 561: CURSOR get_contract_lines(p_chr_id okc_k_headers_b.id%TYPE) IS

557: AND rgp.cle_id is NULL
558: AND rgp.rgd_code = 'LAHDTX'
559: AND rul.rule_information_category = 'LASTCL';
560:
561: CURSOR get_contract_lines(p_chr_id okc_k_headers_b.id%TYPE) IS
562: SELECT cle.id
563: FROM OKC_K_LINES_V cle,
564: OKC_LINE_STYLES_V lse
565: WHERE cle.lse_id = lse.id

Line 571: CURSOR get_rebook_contract_csr(p_chr_id okc_k_headers_b.id%TYPE) IS

567: AND lse.lse_type = 'TLS'
568: AND cle.dnz_chr_id = p_chr_id;
569: -- AND cle.orig_system_id1 IS NULL; -- for rebook check
570:
571: CURSOR get_rebook_contract_csr(p_chr_id okc_k_headers_b.id%TYPE) IS
572: select 'Y'
573: from okc_k_headers_b
574: where id = p_chr_id
575: and nvl(orig_system_source_code,'XXX')='OKL_REBOOK';

Line 573: from okc_k_headers_b

569: -- AND cle.orig_system_id1 IS NULL; -- for rebook check
570:
571: CURSOR get_rebook_contract_csr(p_chr_id okc_k_headers_b.id%TYPE) IS
572: select 'Y'
573: from okc_k_headers_b
574: where id = p_chr_id
575: and nvl(orig_system_source_code,'XXX')='OKL_REBOOK';
576:
577: CURSOR get_asset_sales_tax_info(p_chr_id okc_k_headers_b.id%TYPE,

Line 577: CURSOR get_asset_sales_tax_info(p_chr_id okc_k_headers_b.id%TYPE,

573: from okc_k_headers_b
574: where id = p_chr_id
575: and nvl(orig_system_source_code,'XXX')='OKL_REBOOK';
576:
577: CURSOR get_asset_sales_tax_info(p_chr_id okc_k_headers_b.id%TYPE,
578: p_cle_id okc_k_lines_v.id%TYPE) IS
579: SELECT rul.id, rul.rule_information5, cle.ORIG_SYSTEM_ID1
580: FROM OKC_RULES_V rul,
581: OKC_RULE_GROUPS_V rgp,

Line 591: CURSOR get_sales_tax_prc_info(p_chr_id okc_k_headers_b.id%TYPE) IS

587: AND rul.rule_information_category = 'LAASTX'
588: AND cle.id = rgp.cle_id
589: AND cle.id = p_cle_id;
590:
591: CURSOR get_sales_tax_prc_info(p_chr_id okc_k_headers_b.id%TYPE) IS
592: SELECT rul.rule_information1, rul.rule_information2,
593: rul.rule_information3, rul.rule_information4, rul.rule_information4
594: FROM OKC_RULES_V rul,
595: OKC_RULE_GROUPS_V rgp

Line 930: FROM OKC_K_HEADERS_B

926:
927: --Added by dpsingh for LE uptake
928: CURSOR contract_num_csr (p_ctr_id1 NUMBER) IS
929: SELECT contract_number
930: FROM OKC_K_HEADERS_B
931: WHERE id = p_ctr_id1;
932:
933: l_cntrct_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
934: l_legal_entity_id NUMBER;

Line 933: l_cntrct_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;

929: SELECT contract_number
930: FROM OKC_K_HEADERS_B
931: WHERE id = p_ctr_id1;
932:
933: l_cntrct_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
934: l_legal_entity_id NUMBER;
935:
936: -- R12 - START
937:

Line 2352: FROM okc_k_headers_b

2348:
2349: -- Get contract dates
2350: CURSOR contract_dates_csr IS
2351: SELECT start_date, end_date
2352: FROM okc_k_headers_b
2353: WHERE id = p_contract_id;
2354:
2355: -- Cursor to get assets for financed fee association
2356: -- Bug# 6512668: Exclude asset lines in Abandoned status

Line 3005: okc_k_headers_b chr

3001: ,chr.scs_code scs_code
3002: FROM okc_contacts ct,
3003: okc_contact_sources csrc,
3004: okc_k_party_roles_b pty,
3005: okc_k_headers_b chr
3006: WHERE ct.cpl_id = pty.id
3007: AND ct.cro_code = csrc.cro_code
3008: AND ct.jtot_object1_code = csrc.jtot_object_code
3009: AND ct.dnz_chr_id = chr.id

Line 3023: FROM okc_k_headers_b

3019:
3020: CURSOR custBillTo_csr
3021: IS
3022: SELECT bill_to_site_use_id cust_acct_site_id
3023: FROM okc_k_headers_b
3024: WHERE id = p_trxh_out_rec.khr_id;
3025:
3026: l_custBillTo_rec custBillTo_csr%ROWTYPE;
3027:

Line 4588: FROM okc_k_headers_b

4584:
4585: -- Cursor to get contract start date for billing
4586: CURSOR contract_csr IS
4587: SELECT start_date
4588: FROM okc_k_headers_b
4589: WHERE id = p_contract_id;
4590:
4591: rule_info_csr_rec rule_info_csr%ROWTYPE;
4592: l_ST_params_exist VARCHAR2(1);

Line 4599: l_contract_start_date OKC_K_HEADERS_B.START_DATE%TYPE;

4595: l_prebook_financed_tax NUMBER;
4596: l_booking_capitalized_tax NUMBER;
4597: L_prebook_capitalized_tax NUMBER;
4598: l_booking_billable_tax NUMBER;
4599: l_contract_start_date OKC_K_HEADERS_B.START_DATE%TYPE;
4600: l_source_table VARCHAR2(30) := 'OKL_TRX_CONTRACTS';
4601: l_billed_assets NUMBER :=0;
4602: l_asset_count NUMBER :=0;
4603: l_multiple_fee_type VARCHAR2(1) := Okl_Api.G_FALSE;

Line 5160: FROM OKC_K_HEADERS_B

5156: -- Bug 4748910 - START
5157:
5158: CURSOR c_currency_code(p_khr_id IN NUMBER) IS
5159: SELECT start_date, end_date, currency_code
5160: FROM OKC_K_HEADERS_B
5161: WHERE ID = p_contract_id;
5162:
5163: CURSOR c_try_type(p_name IN VARCHAR2) IS
5164: SELECT ID

Line 5653: FROM okc_k_headers_b

5649: and lookup_code = fndCode;
5650:
5651: CURSOR l_hdr_csr IS
5652: SELECT authoring_org_id
5653: FROM okc_k_headers_b
5654: WHERE id = p_chr_id;
5655: l_authoring_org_id OKC_K_HEADERS_B.AUTHORING_ORG_ID%TYPE;
5656:
5657: cursor l_hdrrl_csr( rgcode OKC_RULE_GROUPS_B.RGD_CODE%TYPE,

Line 5655: l_authoring_org_id OKC_K_HEADERS_B.AUTHORING_ORG_ID%TYPE;

5651: CURSOR l_hdr_csr IS
5652: SELECT authoring_org_id
5653: FROM okc_k_headers_b
5654: WHERE id = p_chr_id;
5655: l_authoring_org_id OKC_K_HEADERS_B.AUTHORING_ORG_ID%TYPE;
5656:
5657: cursor l_hdrrl_csr( rgcode OKC_RULE_GROUPS_B.RGD_CODE%TYPE,
5658: rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,
5659: chrId NUMBER) IS

Line 5837: CURSOR st_fee_count_csr (p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS

5833: AND txs.kle_id = p_asset_id;
5834: l_asset_tax_amount NUMBER;
5835:
5836: -- R12B Authoring OA Migration
5837: CURSOR st_fee_count_csr (p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS
5838: SELECT COUNT(cleb.id)
5839: FROM okc_k_lines_b cleb,
5840: okl_k_lines kle,
5841: okc_line_styles_b sty,

Line 6469: CURSOR l_fn_top_fee_ln_csr (p_chr_id IN OKC_K_HEADERS_B.ID%TYPE) IS

6465: l_api_name CONSTANT VARCHAR2(30) := 'VALIDATE_UPFRONT_TAX_FEE';
6466: l_api_version CONSTANT NUMBER := 1.0;
6467:
6468: /* Cursor to get the top fee line for Sales Tax financed fee of a given contract. */
6469: CURSOR l_fn_top_fee_ln_csr (p_chr_id IN OKC_K_HEADERS_B.ID%TYPE) IS
6470: SELECT kle.id,
6471: kle.amount,
6472: clev.name,
6473: lsev.name line_type

Line 6489: CURSOR l_fn_sub_ln_fee_csr ( p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,

6485: AND okcsts.ste_code NOT IN ('EXPIRED','HOLD','CANCELLED','TERMINATED', 'ABANDONED');
6486:
6487: /* Cursor to get the financed fee sub-lines (applied to assets) for a
6488: given contract. */
6489: CURSOR l_fn_sub_ln_fee_csr ( p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,
6490: p_fee_line_id IN OKL_K_LINES.ID%TYPE) IS
6491: SELECT kle.id,
6492: kle.amount,
6493: cleb.end_date,

Line 6506: CURSOR l_fn_fee_pmt_csr (p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,

6502: AND okcsts.ste_code NOT IN ('EXPIRED','HOLD','CANCELLED','ABANDONED');
6503:
6504: /* Cursor to get the financed fee top/sub-line payments for a
6505: given contract. */
6506: CURSOR l_fn_fee_pmt_csr (p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,
6507: p_fee_line_id IN OKL_K_LINES.ID%TYPE) IS
6508: SELECT Fnd_Date.canonical_to_date(sll.rule_information2) start_date,
6509: SLL.rule_information3 periods,
6510: DECODE(sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12) mpp,

Line 6532: CURSOR l_fn_fee_pmtH_csr (p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,

6528: AND sll.rule_information_category = 'LASLL';
6529:
6530: /* Cursor to get the financed fee top/sub-line payments HEADER for a
6531: given contract. */
6532: CURSOR l_fn_fee_pmtH_csr (p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,
6533: p_fee_line_id IN OKL_K_LINES.ID%TYPE) IS
6534:
6535: SELECT slh.id
6536: FROM okc_rules_b slh,

Line 6549: CURSOR l_strm_slh_csr (p_khr_id OKC_K_HEADERS_B.ID%TYPE,

6545: AND slh.object1_id1 = TO_CHAR(sty.id)
6546: AND styt.language = USERENV('LANG')
6547: AND sty.id = styt.id;
6548:
6549: CURSOR l_strm_slh_csr (p_khr_id OKC_K_HEADERS_B.ID%TYPE,
6550: p_kle_id OKC_K_LINES_B.ID%TYPE) IS
6551: SELECT styt.name stream_type,
6552: rule.id rule_id,
6553: rgp.id rgp_id