DBA Data[Home] [Help]

APPS.HR_PARAMETER_HRMNPSUM dependencies on HR_LOOKUPS

Line 99: from hr_lookups

95:
96: cursor c_incl_subord is
97: select 'SIRO' lookup_code
98: , meaning
99: from hr_lookups
100: where lookup_type = 'YES_NO'
101: and lookup_code = 'Y'
102: UNION
103: select 'SINR' lookup_code

Line 105: from hr_lookups

101: and lookup_code = 'Y'
102: UNION
103: select 'SINR' lookup_code
104: , meaning
105: from hr_lookups
106: where lookup_type = 'YES_NO'
107: and lookup_code = 'N'
108: order by 1 desc;
109:

Line 310: from hr_lookups

306:
307: cursor c_bgttyp is
308: select lookup_code
309: , meaning
310: from hr_lookups
311: where lookup_type = 'BUDGET_MEASUREMENT_TYPE'
312: order by meaning;
313:
314: BEGIN

Line 375: from hr_lookups

371: i IN Number) IS
372:
373: cursor c_frequency is
374: select lookup_code,meaning
375: from hr_lookups
376: where lookup_type = 'PROC_PERIOD_TYPE'
377: and lookup_code in ('CM','BM','Q','SY','Y')
378: order by decode(lookup_code, 'CM',1, 'BM',2, 'Q',3, 'SY',6, 'Y',12, 99);
379: