APPS.OKL_OPEN_INTERFACE_PVT dependencies on OKL_FRENCH_TAX_V

Line 5583: l_french_tax_code OKL_FRENCH_TAX_V.CODE%TYPE;

5579: lp_rulv_rec rulv_rec_type;
5580: xp_rulv_rec rulv_rec_type;
5581:
5582: l_progress VARCHAR2(10) := '1.0';
5583: l_french_tax_code OKL_FRENCH_TAX_V.CODE%TYPE;
5584:
5585: CURSOR french_tax_csr (p_tax_code okl_french_tax_v.code%TYPE,
5586: p_tax_name okl_french_tax_v.name%TYPE) IS
5587: SELECT code

Line 5585: CURSOR french_tax_csr (p_tax_code okl_french_tax_v.code%TYPE,

5581:
5582: l_progress VARCHAR2(10) := '1.0';
5583: l_french_tax_code OKL_FRENCH_TAX_V.CODE%TYPE;
5584:
5585: CURSOR french_tax_csr (p_tax_code okl_french_tax_v.code%TYPE,
5586: p_tax_name okl_french_tax_v.name%TYPE) IS
5587: SELECT code
5588: FROM okl_french_tax_v
5589: WHERE ( code = p_tax_code

Line 5586: p_tax_name okl_french_tax_v.name%TYPE) IS

5582: l_progress VARCHAR2(10) := '1.0';
5583: l_french_tax_code OKL_FRENCH_TAX_V.CODE%TYPE;
5584:
5585: CURSOR french_tax_csr (p_tax_code okl_french_tax_v.code%TYPE,
5586: p_tax_name okl_french_tax_v.name%TYPE) IS
5587: SELECT code
5588: FROM okl_french_tax_v
5589: WHERE ( code = p_tax_code
5590: AND

Line 5588: FROM okl_french_tax_v

5584:
5585: CURSOR french_tax_csr (p_tax_code okl_french_tax_v.code%TYPE,
5586: p_tax_name okl_french_tax_v.name%TYPE) IS
5587: SELECT code
5588: FROM okl_french_tax_v
5589: WHERE ( code = p_tax_code
5590: AND
5591: p_tax_code IS NOT NULL)
5592: OR ( name = p_tax_name

Line 6146: l_french_tax_code OKL_FRENCH_TAX_V.CODE%TYPE;

6142: l_rulv_rec rulv_rec_type;
6143: x_rulv_rec rulv_rec_type;
6144:
6145: l_progress VARCHAR2(10) := '1.0';
6146: l_french_tax_code OKL_FRENCH_TAX_V.CODE%TYPE;
6147:
6148: CURSOR french_tax_csr (p_tax_code okl_french_tax_v.code%TYPE,
6149: p_tax_name okl_french_tax_v.name%TYPE) IS
6150: SELECT code

Line 6148: CURSOR french_tax_csr (p_tax_code okl_french_tax_v.code%TYPE,

6144:
6145: l_progress VARCHAR2(10) := '1.0';
6146: l_french_tax_code OKL_FRENCH_TAX_V.CODE%TYPE;
6147:
6148: CURSOR french_tax_csr (p_tax_code okl_french_tax_v.code%TYPE,
6149: p_tax_name okl_french_tax_v.name%TYPE) IS
6150: SELECT code
6151: FROM okl_french_tax_v
6152: WHERE ( code = p_tax_code

Line 6149: p_tax_name okl_french_tax_v.name%TYPE) IS

6145: l_progress VARCHAR2(10) := '1.0';
6146: l_french_tax_code OKL_FRENCH_TAX_V.CODE%TYPE;
6147:
6148: CURSOR french_tax_csr (p_tax_code okl_french_tax_v.code%TYPE,
6149: p_tax_name okl_french_tax_v.name%TYPE) IS
6150: SELECT code
6151: FROM okl_french_tax_v
6152: WHERE ( code = p_tax_code
6153: AND

Line 6151: FROM okl_french_tax_v

6147:
6148: CURSOR french_tax_csr (p_tax_code okl_french_tax_v.code%TYPE,
6149: p_tax_name okl_french_tax_v.name%TYPE) IS
6150: SELECT code
6151: FROM okl_french_tax_v
6152: WHERE ( code = p_tax_code
6153: AND
6154: p_tax_code IS NOT NULL)
6155: OR ( name = p_tax_name