DBA Data[Home] [Help]

APPS.HRI_PARAMETERS dependencies on HR_LOOKUPS

Line 975: from hr_lookups

971:
972: cursor c_frequency is
973: select lookup_code
974: ,meaning
975: from hr_lookups
976: where lookup_type = 'PROC_PERIOD_TYPE'
977: and lookup_code in ('CM','BM','Q','SY','Y')
978: order by decode(lookup_code, 'CM',1, 'BM',2, 'Q',3, 'SY',6, 'Y',12, 99);
979:

Line 1440: from hr_lookups

1436: --
1437:
1438: cursor c_lookup is
1439: select meaning, lookup_code
1440: from hr_lookups
1441: where lookup_type = 'YES_NO'
1442: and lookup_code IN ('Y', 'N');
1443:
1444: lookup_yes varchar2(80);

Line 1595: from hr_lookups /* bug fix 3323544*/

1591: -- it is passed in here, otherwise this must be empty - i.e. ''
1592:
1593: cursor c_lookup(p_lookup_type in varchar2) is
1594: select lookup_code,meaning
1595: from hr_lookups /* bug fix 3323544*/
1596: where lookup_type = p_lookup_type
1597: and enabled_flag = 'Y' /* bug fix 1608726 */
1598: order by 2;
1599: