DBA Data[Home] [Help]

APPS.PER_DIF_STMT_REPORT dependencies on HR_LOOKUPS

Line 42: from hr_lookups

38: --
39: -- Cursor for fetching field names
40: cursor csr_get_lookup is
41: select lookup_code,meaning
42: from hr_lookups
43: where lookup_type='FR_DIF_STMT_LOOKUP_CODE'
44: and lookup_code <> 'TOTAL'; -- added for 5111065
45: --
46: -- Cursor to specifically fetch the code and meaning

Line 51: from hr_lookups

47: -- of 'TOTAL' from name_translations
48: -- added for 5111065
49: cursor csr_get_lookup_total is
50: select lookup_code,meaning
51: from hr_lookups
52: where lookup_type='NAME_TRANSLATIONS'
53: and lookup_code = 'TOTAL';
54: --
55: BEGIN

Line 199: from hr_lookups

195: --
196: -- Cursor for accrual and adjustment field label
197: cursor csr_get_repeat_lookup(c_lookup_code varchar2) is
198: select lookup_code,meaning
199: from hr_lookups
200: where lookup_type='FR_DIF_STMT_LOOKUP_CODE'
201: and lookup_code = c_lookup_code;
202: --
203: -- Cursor for establishment details in header