APPS.OKL_JTOT_CONTACT_EXTRACT_PUB dependencies on FND_LOOKUP_VALUES

Line 88: fnd_lookup_values fnd

84: IS
85: select fnd.meaning
86: from okc_subclass_roles sur,
87: okc_k_headers_b chr,
88: fnd_lookup_values fnd
89: where fnd.lookup_code = sur.rle_code
90: and sur.rle_code = p_rle_code
91: and fnd.lookup_type = 'OKC_ROLE'
92: and fnd.language = userenv('LANG')

Line 98: l_rle_code_meaning fnd_lookup_values.meaning%TYPE;

94: and chr.id = p_chr_id
95: and nvl(sur.start_date,sysdate) <= sysdate
96: and nvl(sur.end_date,sysdate+1) > sysdate;
97:
98: l_rle_code_meaning fnd_lookup_values.meaning%TYPE;
99: BEGIN
100: OPEN l_rle_code_meaning_csr;
101: FETCH l_rle_code_meaning_csr INTO l_rle_code_meaning;
102: CLOSE l_rle_code_meaning_csr;

Line 1250: l_rle_code_meaning fnd_lookup_values.meaning%type;

1246:
1247: l_api_name VARCHAR2(30) := 'Validate_Party';
1248: l_api_version CONSTANT NUMBER := 1.0;
1249: l_chr_id NUMBER;
1250: l_rle_code_meaning fnd_lookup_values.meaning%type;
1251:
1252: row_count number;
1253:
1254: l_k_vendor_id1 okc_k_party_roles_v.object1_id1%type;