DBA Data[Home] [Help]

APPS.OKL_STREAM_BILLING_PVT dependencies on OKL_K_HEADERS_FULL_V

Line 115: l_product_id okl_k_headers_full_v.pdt_id%TYPE;

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

Line 1483: FROM okl_k_headers_full_v

1479: SELECT currency_code
1480: ,currency_conversion_type
1481: ,currency_conversion_rate
1482: ,currency_conversion_date
1483: FROM okl_k_headers_full_v
1484: WHERE id = cp_khr_id;
1485:
1486: -- nikshah -- Bug # 5484903 Fixed,
1487: -- Changed CURSOR std_terms_csr SQL definition

Line 1499: FROM okl_k_headers_full_v

1495:
1496: --Get product Id
1497: CURSOR pdt_id_csr( p_khr_id NUMBER ) IS
1498: SELECT pdt_id
1499: FROM okl_k_headers_full_v
1500: WHERE id = p_khr_id;
1501: -- Variables for XTD Accounting Distributions
1502:
1503: l_esd_acc_cc_id OKL_AE_TMPT_LNES.code_combination_id%TYPE;