APPS.OKL_PROCESS_SALES_TAX_PVT dependencies on OKL_STRM_TYPE_B

Line 6732: FROM okl_strm_type_b a, fnd_lookups b

6728:
6729: -- get all the Billable, enabled streams of purpose FEE_PAYMENT
6730: CURSOR l_strmtype_csr(cp_sty_code IN VARCHAR2) IS
6731: SELECT a.id, a.code, a.stream_type_purpose, b.meaning
6732: FROM okl_strm_type_b a, fnd_lookups b
6733: WHERE a.stream_type_purpose = 'FEE_PAYMENT'
6734: AND a.billable_yn = 'Y'
6735: AND a.stream_type_purpose = b.lookup_code
6736: AND b.lookup_type = 'OKL_STREAM_TYPE_PURPOSE'

Line 8192: FROM okl_strm_type_b typ,

8188: NULL tax_sources_id,
8189: NULL asset_line_id,
8190: NULL ship_to_siteuseid,
8191: NULL inventory_item_id
8192: FROM okl_strm_type_b typ,
8193: okl_streams strm,
8194: okl_strm_elements selm,
8195: okc_k_lines_b lines,
8196: okc_line_styles_b lse

Line 8228: FROM okl_strm_type_b typ,

8224: selm.stream_element_date stream_element_date,
8225: cnsld.customer_trx_id,
8226: cnsld.customer_trx_line_id,
8227: selm.amount --SECHAWLA 22-APR-08 6975983 : added
8228: FROM okl_strm_type_b typ,
8229: okl_streams strm,
8230: okl_strm_elements selm,
8231: okc_k_lines_b lines,
8232: okc_line_styles_b lse,

Line 8262: FROM okl_strm_type_b typ,

8258:
8259: -- get all the financial asset lines for the contract
8260: CURSOR l_finassets_csr(CP_KHR_ID IN NUMBER) IS
8261: SELECT DISTINCT strm.kle_id fin_asset_id -- is DISTINCT req ? can an asset line have more than one stream types ?
8262: FROM okl_strm_type_b typ,
8263: okl_streams strm,
8264: okc_k_lines_b lines,
8265: okc_line_styles_b sty
8266: WHERE strm.sty_id = typ.id

Line 8289: FROM okl_strm_type_b typ,

8285: strm.id stream_id,
8286: strm.kle_id line_id,
8287: strm.sty_id stream_type_id,
8288: sty.lty_code
8289: FROM okl_strm_type_b typ,
8290: okl_streams strm,
8291: okc_k_lines_b lines,
8292: okc_line_styles_b sty
8293: WHERE strm.sty_id = typ.id

Line 10968: FROM okl_strm_type_b typ,

10964: SELECT typ.code Stream_Type,
10965: strm.id stream_id,
10966: strm.kle_id line_id,
10967: strm.sty_id stream_type_id
10968: FROM okl_strm_type_b typ,
10969: okl_streams strm
10970: WHERE strm.sty_id = typ.id
10971: AND typ.billable_yn = 'Y'
10972: AND strm.say_code ='CURR'

Line 11031: FROM okl_strm_type_b typ,

11027: AND lse.lty_code = 'FREE_FORM2';
11028:
11029: CURSOR c_get_streams_count(cp_khr_id IN NUMBER, cp_kle_id IN NUMBER) IS
11030: SELECT count(*)
11031: FROM okl_strm_type_b typ,
11032: okl_streams strm
11033: WHERE strm.sty_id = typ.id
11034: AND typ.billable_yn = 'Y'
11035: AND strm.say_code ='CURR'

Line 13240: okl_strm_type_b styb

13236: FROM
13237: okc_rule_groups_b rgpb,
13238: okc_rules_b rulb,
13239: okc_rules_b rulb2,
13240: okl_strm_type_b styb
13241: WHERE rgpb.dnz_chr_id = cp_chr_id
13242: AND rgpb.chr_id = cp_chr_id
13243: AND rgpb.cle_id IS NULL
13244: AND rgpb.rgd_code = 'LALEVL'

Line 13262: okl_strm_type_b styb

13258: FROM okc_k_lines_b cleb,
13259: okc_rule_groups_b rgpb,
13260: okc_rules_b rulb,
13261: okc_rules_b rulb2,
13262: okl_strm_type_b styb
13263: WHERE rgpb.dnz_chr_id = cp_chr_id
13264: AND rgpb.chr_id IS NULL
13265: AND rgpb.cle_id = cleb.id
13266: AND cleb.dnz_chr_id = cp_chr_id

Line 18952: FROM okl_strm_type_b

18948:
18949: -- Get stream type purpose for a given stream type id
18950: CURSOR l_strmtype_csr(cp_sty_id IN NUMBER) IS
18951: SELECT stream_type_purpose
18952: FROM okl_strm_type_b
18953: WHERE id = cp_sty_id;
18954:
18955: -- Get the line type
18956: CURSOR l_okclinestyle_csr(cp_kle_id IN NUMBER) IS

Line 19039: l_purpose_code okl_strm_type_b.stream_type_purpose%TYPE;

19035:
19036: l_qtp_code okl_trx_quotes_b.qtp_code%TYPE;
19037: l_qte_reason okl_trx_quotes_b.qrs_code%TYPE;
19038: l_early_term_yn okl_trx_quotes_b.early_termination_yn%TYPE;
19039: l_purpose_code okl_strm_type_b.stream_type_purpose%TYPE;
19040: l_product_type VARCHAR2(30);
19041: l_def_tax_country VARCHAR2(2);
19042: l_reporting_flag VARCHAR2(1);
19043: