36: function get_action_type( p_action_type_code varchar2) return varchar2 is
37:
38: cursor c_action_type_meaning(c_action_type_code varchar2) is
39: select meaning
40: from hr_lookups
41: where lookup_type = 'ACTION_TYPE'
42: and lookup_code = c_action_type_code ;
43:
44: l_action_type_meaning VARCHAR2(80);
370: from per_business_groups
371: where business_group_id = c_business_group_id;
372:
373:
374: cursor c_report_mode(c_mode hr_lookups.lookup_code%type) is
375: select h.meaning from hr_lookups h
376: where h.lookup_type = 'PAY_ACTIONS_NOT_PROCESSED'
377: and h.lookup_code = c_mode
378: and h.enabled_flag = 'Y';
371: where business_group_id = c_business_group_id;
372:
373:
374: cursor c_report_mode(c_mode hr_lookups.lookup_code%type) is
375: select h.meaning from hr_lookups h
376: where h.lookup_type = 'PAY_ACTIONS_NOT_PROCESSED'
377: and h.lookup_code = c_mode
378: and h.enabled_flag = 'Y';
379: