DBA Data[Home] [Help]

APPS.HR_DTY_BUS dependencies on FND_LOOKUP_VALUES

Line 137: FROM FND_LOOKUP_VALUES FLV

133:
134: cursor csr_valid_category_code(p_category_cd varchar2,p_legislation_code varchar2)
135: is
136: SELECT 'X'
137: FROM FND_LOOKUP_VALUES FLV
138: WHERE FLV.lookup_type = 'DOCUMENT_CATEGORY'
139: and FLV.lookup_code = p_category_cd
140: AND FLV.LANGUAGE = userenv('LANG')
141: and FLV.VIEW_APPLICATION_ID = 3

Line 168: hr_utility.set_message_token('TABLE', 'FND_LOOKUP_VALUES');

164: if csr_valid_category_code%notfound then
165: close csr_valid_category_code;
166: hr_utility.set_message(800, 'HR_449711_DOR_INVL_COND_VAL');
167: hr_utility.set_message_token('OBJECT', 'CATEGORY_CODE');
168: hr_utility.set_message_token('TABLE', 'FND_LOOKUP_VALUES');
169: hr_utility.set_message_token('CONDITION', 'lookup type "DOCUMENT CATEGORY"');
170: hr_utility.raise_error;
171: hr_utility.set_location(l_proc, 10);
172: --