APPS.OKS_MASSCHANGE_PVT dependencies on FND_LOOKUPS

Line 7595: SELECT meaning FROM fnd_lookups

7591:
7592: FUNCTION Get_lookup_value(p_lookup_code IN Varchar2)
7593: RETURN Varchar2 IS
7594: CURSOR Cur_lookup IS
7595: SELECT meaning FROM fnd_lookups
7596: WHERE lookup_type like 'OKS_MSCHG_LEVEL%'
7597: AND lookup_code = p_lookup_code
7598: AND rownum =1;
7599: l_meaning Varchar2(100);

Line 13392: From fnd_lookups

13388: --- Cursor for new ATTRIBUTES
13389:
13390: CURSOR get_YN_meaning(p_attr_id IN Varchar2) IS
13391: Select meaning
13392: From fnd_lookups
13393: Where lookup_code = p_attr_id
13394: And lookup_type = 'OKS_SC_YES_NO' ;
13395:
13396: CURSOR get_Renewal_type(p_attr_id IN Varchar2) IS

Line 13398: From fnd_lookups

13394: And lookup_type = 'OKS_SC_YES_NO' ;
13395:
13396: CURSOR get_Renewal_type(p_attr_id IN Varchar2) IS
13397: Select meaning
13398: From fnd_lookups
13399: Where lookup_code = p_attr_id
13400: And lookup_type in( 'OKC_RENEWAL_TYPE','OKS_RENEWAL_TYPE') ;
13401:
13402: CURSOR get_price_list(p_attr_id IN Varchar2) IS

Line 13416: SELECT meaning FROM fnd_lookups

13412: FUNCTION Get_attribute(p_lookup_code IN Varchar2)
13413: RETURN Varchar2 IS
13414:
13415: CURSOR Cur_lookup IS
13416: SELECT meaning FROM fnd_lookups
13417: WHERE lookup_type = 'OKS_MASS_CHANGE_ATTRIBUTE'
13418: AND lookup_code = p_lookup_code;
13419: l_meaning Varchar2(100);
13420:

Line 13437: FROM FND_LOOKUPS

13433: l_meaning VARCHAR2(90);
13434:
13435: Cursor l_lookup_csr is
13436: SELECT MEANING
13437: FROM FND_LOOKUPS
13438: WHERE LOOKUP_TYPE = p_type
13439: AND LOOKUP_CODE = p_code ;
13440:
13441: BEGIN