DBA Data[Home] [Help]

APPS.OKL_STREAM_BILLING_PVT dependencies on OKL_K_HEADERS_FULL_V

Line 113: l_product_id okl_k_headers_full_v.pdt_id%TYPE;

109: l_bank_id1 OKC_RULES_B.OBJECT1_ID1%TYPE;
110: l_rct_method_code AR_RECEIPT_CLASSES.CREATION_METHOD_CODE%TYPE;
111: l_asst_tax OKC_RULES_B.rule_information1%TYPE;
112: l_asst_line_tax OKC_RULES_B.rule_information1%TYPE;
113: l_product_id okl_k_headers_full_v.pdt_id%TYPE;
114:
115: -- Multi Currency Compliance
116: l_currency_code OKL_EXT_SELL_INVS_B.currency_code%TYPE;
117: l_currency_conversion_type OKL_EXT_SELL_INVS_B.currency_conversion_type%TYPE;

Line 1421: FROM okl_k_headers_full_v

1417: SELECT currency_code
1418: ,currency_conversion_type
1419: ,currency_conversion_rate
1420: ,currency_conversion_date
1421: FROM okl_k_headers_full_v
1422: WHERE id = cp_khr_id;
1423:
1424: -- nikshah -- Bug # 5484903 Fixed,
1425: -- Changed CURSOR std_terms_csr SQL definition

Line 1437: FROM okl_k_headers_full_v

1433:
1434: --Get product Id
1435: CURSOR pdt_id_csr( p_khr_id NUMBER ) IS
1436: SELECT pdt_id
1437: FROM okl_k_headers_full_v
1438: WHERE id = p_khr_id;
1439: -- Variables for XTD Accounting Distributions
1440:
1441: l_esd_acc_cc_id OKL_AE_TMPT_LNES.code_combination_id%TYPE;