APPS.OKL_PROCESS_SALES_TAX_PVT dependencies on OKL_STRM_TYPE_B

Line 6763: FROM okl_strm_type_b a, fnd_lookups b

6759:
6760: -- get all the Billable, enabled streams of purpose FEE_PAYMENT
6761: CURSOR l_strmtype_csr(cp_sty_code IN VARCHAR2) IS
6762: SELECT a.id, a.code, a.stream_type_purpose, b.meaning
6763: FROM okl_strm_type_b a, fnd_lookups b
6764: WHERE a.stream_type_purpose = 'FEE_PAYMENT'
6765: AND a.billable_yn = 'Y'
6766: AND a.stream_type_purpose = b.lookup_code
6767: AND b.lookup_type = 'OKL_STREAM_TYPE_PURPOSE'

Line 8223: FROM okl_strm_type_b typ,

8219: NULL tax_sources_id,
8220: NULL asset_line_id,
8221: NULL ship_to_siteuseid,
8222: NULL inventory_item_id
8223: FROM okl_strm_type_b typ,
8224: okl_streams strm,
8225: okl_strm_elements selm,
8226: okc_k_lines_b lines,
8227: okc_line_styles_b lse

Line 8259: FROM okl_strm_type_b typ,

8255: selm.stream_element_date stream_element_date,
8256: cnsld.customer_trx_id,
8257: cnsld.customer_trx_line_id,
8258: selm.amount --SECHAWLA 22-APR-08 6975983 : added
8259: FROM okl_strm_type_b typ,
8260: okl_streams strm,
8261: okl_strm_elements selm,
8262: okc_k_lines_b lines,
8263: okc_line_styles_b lse,

Line 8293: FROM okl_strm_type_b typ,

8289:
8290: -- get all the financial asset lines for the contract
8291: CURSOR l_finassets_csr(CP_KHR_ID IN NUMBER) IS
8292: SELECT DISTINCT strm.kle_id fin_asset_id -- is DISTINCT req ? can an asset line have more than one stream types ?
8293: FROM okl_strm_type_b typ,
8294: okl_streams strm,
8295: okc_k_lines_b lines,
8296: okc_line_styles_b sty
8297: WHERE strm.sty_id = typ.id

Line 8320: FROM okl_strm_type_b typ,

8316: strm.id stream_id,
8317: strm.kle_id line_id,
8318: strm.sty_id stream_type_id,
8319: sty.lty_code
8320: FROM okl_strm_type_b typ,
8321: okl_streams strm,
8322: okc_k_lines_b lines,
8323: okc_line_styles_b sty
8324: WHERE strm.sty_id = typ.id

Line 11003: FROM okl_strm_type_b typ,

10999: SELECT typ.code Stream_Type,
11000: strm.id stream_id,
11001: strm.kle_id line_id,
11002: strm.sty_id stream_type_id
11003: FROM okl_strm_type_b typ,
11004: okl_streams strm
11005: WHERE strm.sty_id = typ.id
11006: AND typ.billable_yn = 'Y'
11007: AND strm.say_code ='CURR'

Line 11066: FROM okl_strm_type_b typ,

11062: AND lse.lty_code = 'FREE_FORM2';
11063:
11064: CURSOR c_get_streams_count(cp_khr_id IN NUMBER, cp_kle_id IN NUMBER) IS
11065: SELECT count(*)
11066: FROM okl_strm_type_b typ,
11067: okl_streams strm
11068: WHERE strm.sty_id = typ.id
11069: AND typ.billable_yn = 'Y'
11070: AND strm.say_code ='CURR'

Line 13290: okl_strm_type_b styb

13286: FROM
13287: okc_rule_groups_b rgpb,
13288: okc_rules_b rulb,
13289: okc_rules_b rulb2,
13290: okl_strm_type_b styb
13291: WHERE rgpb.dnz_chr_id = cp_chr_id
13292: AND rgpb.chr_id = cp_chr_id
13293: AND rgpb.cle_id IS NULL
13294: AND rgpb.rgd_code = 'LALEVL'

Line 13322: okl_strm_type_b styb

13318: FROM okc_k_lines_b cleb,
13319: okc_rule_groups_b rgpb,
13320: okc_rules_b rulb,
13321: okc_rules_b rulb2,
13322: okl_strm_type_b styb
13323: WHERE rgpb.dnz_chr_id = cp_chr_id
13324: AND rgpb.chr_id IS NULL
13325: AND rgpb.cle_id = cleb.id
13326: AND cleb.dnz_chr_id = cp_chr_id

Line 19119: FROM okl_strm_type_b

19115:
19116: -- Get stream type purpose for a given stream type id
19117: CURSOR l_strmtype_csr(cp_sty_id IN NUMBER) IS
19118: SELECT stream_type_purpose
19119: FROM okl_strm_type_b
19120: WHERE id = cp_sty_id;
19121:
19122: -- Get the line type
19123: CURSOR l_okclinestyle_csr(cp_kle_id IN NUMBER) IS

Line 19206: l_purpose_code okl_strm_type_b.stream_type_purpose%TYPE;

19202:
19203: l_qtp_code okl_trx_quotes_b.qtp_code%TYPE;
19204: l_qte_reason okl_trx_quotes_b.qrs_code%TYPE;
19205: l_early_term_yn okl_trx_quotes_b.early_termination_yn%TYPE;
19206: l_purpose_code okl_strm_type_b.stream_type_purpose%TYPE;
19207: l_product_type VARCHAR2(30);
19208: l_def_tax_country VARCHAR2(2);
19209: l_reporting_flag VARCHAR2(1);
19210: