APPS.OKL_STREAM_MIGRATION_PVT dependencies on OKL_PRODUCTS_V

Line 2214: okl_products_v p,

2210: DISTINCT
2211: q1.value deal_type,
2212: q2.value tax_owner
2213: FROM
2214: okl_products_v p,
2215: okl_pdt_pqy_vals_uv q1,
2216: okl_pdt_pqy_vals_uv q2
2217: WHERE
2218: p.id = q1.pdt_id AND q1.name = 'LEASE' AND q1.value IS NOT NULL AND

Line 2226: okl_products_v p,

2222: DISTINCT
2223: q1.value deal_type,
2224: 'LESSEE' tax_owner
2225: FROM
2226: okl_products_v p,
2227: okl_pdt_pqy_vals_uv q1
2228: WHERE
2229: p.id = q1.pdt_id AND q1.name = 'INVESTOR' AND q1.value IS NOT NULL;
2230:

Line 2275: okl_products_v p,

2271: CURSOR org_csr (l_deal_type IN VARCHAR2, l_tax_owner IN VARCHAR2) IS
2272: SELECT
2273: DISTINCT aes.org_id
2274: FROM
2275: okl_products_v p,
2276: okl_ae_tmpt_sets aes,
2277: okl_pdt_pqy_vals_uv q1,
2278: okl_pdt_pqy_vals_uv q2
2279: WHERE

Line 2287: okl_products_v p,

2283: UNION
2284: SELECT
2285: DISTINCT aes.org_id
2286: FROM
2287: okl_products_v p,
2288: okl_pdt_pqy_vals_uv q1,
2289: okl_ae_tmpt_sets aes
2290: WHERE
2291: p.aes_id = aes.id AND

Line 2684: okl_products_v p,

2680: q1.value deal_type,
2681: q2.value tax_owner,
2682: aes.name aes_name
2683: FROM
2684: okl_products_v p,
2685: okl_ae_tmpt_sets_v aes,
2686: okl_pdt_pqy_vals_uv q1,
2687: okl_pdt_pqy_vals_uv q2
2688: WHERE

Line 2703: okl_products_v p,

2699: q1.value deal_type,
2700: 'LESSEE' tax_owner,
2701: aes.name aes_name
2702: FROM
2703: okl_products_v p,
2704: okl_ae_tmpt_sets_v aes,
2705: okl_pdt_pqy_vals_uv q1
2706: WHERE
2707: p.aes_id = aes.id AND

Line 2855: l_product_name okl_products_v.name%TYPE;

2851: x_msg_count NUMBER;
2852: x_msg_data VARCHAR2(2000);
2853: l_org_name VARCHAR2(150);
2854:
2855: l_product_name okl_products_v.name%TYPE;
2856: l_product_id okl_products_v.id%TYPE;
2857: l_ptl_id okl_products_v.ptl_id%TYPE;
2858: l_aes_id okl_ae_tmpt_sets.id%TYPE;
2859: l_deal_type okl_pdt_pqy_vals_uv.value%TYPE;

Line 2856: l_product_id okl_products_v.id%TYPE;

2852: x_msg_data VARCHAR2(2000);
2853: l_org_name VARCHAR2(150);
2854:
2855: l_product_name okl_products_v.name%TYPE;
2856: l_product_id okl_products_v.id%TYPE;
2857: l_ptl_id okl_products_v.ptl_id%TYPE;
2858: l_aes_id okl_ae_tmpt_sets.id%TYPE;
2859: l_deal_type okl_pdt_pqy_vals_uv.value%TYPE;
2860: l_tax_owner okl_pdt_pqy_vals_uv.value%TYPE;

Line 2857: l_ptl_id okl_products_v.ptl_id%TYPE;

2853: l_org_name VARCHAR2(150);
2854:
2855: l_product_name okl_products_v.name%TYPE;
2856: l_product_id okl_products_v.id%TYPE;
2857: l_ptl_id okl_products_v.ptl_id%TYPE;
2858: l_aes_id okl_ae_tmpt_sets.id%TYPE;
2859: l_deal_type okl_pdt_pqy_vals_uv.value%TYPE;
2860: l_tax_owner okl_pdt_pqy_vals_uv.value%TYPE;
2861: