APPS.OKL_UTIL dependencies on OKX_COUNTRIES_V

Line 23: OKX_COUNTRIES_V OKX_COUNTRY

19: OKC_K_LINES_B INSTITEM_CLE,
20: OKC_LINE_STYLES_B INSTITEM_LSE,
21: OKL_TXL_ITM_INSTS OTITM ,
22: OKX_PARTY_SITE_USES_V PARTY_SITE_USES,
23: OKX_COUNTRIES_V OKX_COUNTRY
24: WHERE party_site_uses.country = okx_country.id1
25: AND party_site_uses.site_use_type = 'INSTALL_AT'
26: AND PARTY_SITE_USES.ID1 = OTITM.object_id1_new -- location
27: AND OTITM.OBJECT_ID2_NEW = PARTY_SITE_USES.ID2

Line 38: l_country_code OKX_COUNTRIES_V.id1%TYPE;

34: AND FREEFORM2_CLE.LSE_ID = FREEFORM2_LSE.ID
35: AND FREEFORM2_LSE.lty_code = 'FREE_FORM2' ;
36:
37:
38: l_country_code OKX_COUNTRIES_V.id1%TYPE;
39:
40: BEGIN
41:
42:

Line 111: l_country_code OKX_COUNTRIES_V.id1%TYPE;

107: AND instance_LS.ID = instance_CLE.LSE_ID
108: AND instance_CLE.cle_id = p_k_financial_line ;
109:
110:
111: l_country_code OKX_COUNTRIES_V.id1%TYPE;
112:
113:
114:
115: BEGIN