APPS.OKL_LOSS_PROV_PVT dependencies on OKL_PRODUCTS

Line 1017: l_product_name OKL_PRODUCTS_V.NAME%TYPE;

1013: l_sob_name VARCHAR2(2000);
1014: l_org_id NUMBER;
1015: l_org_name VARCHAR2(2000);
1016: l_product_id OKL_TRX_CONTRACTS.PDT_ID%TYPE := to_number(p_product_id);
1017: l_product_name OKL_PRODUCTS_V.NAME%TYPE;
1018: l_bucket_id OKX_AGING_BUCKETS_V.AGING_BUCKET_ID%TYPE := to_number(p_bucket_id);
1019: l_entry_date DATE := FND_DATE.CANONICAL_TO_DATE(p_entry_date);
1020: l_cntrct_id OKL_K_HEADERS_FULL_V.ID%TYPE;
1021: l_cntrct_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;

Line 1152: FROM okl_products pdt,

1148: -- cursor to get product name
1149: --Used base tables in query for performance by dkagrawa
1150: CURSOR pdt_csr IS
1151: SELECT pdt.name name, pqy.name product_subclass
1152: FROM okl_products pdt,
1153: okl_pdt_pqy_vals pqv,
1154: okl_pdt_qualitys pqy,
1155: okl_pqy_values qve
1156: WHERE pdt.id = pqv.pdt_id