DBA Data[Home] [Help]

APPS.PAY_PAYRPANP_XML_PKG dependencies on HR_LOOKUPS

Line 40: from hr_lookups

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);

Line 381: cursor c_report_mode(c_mode hr_lookups.lookup_code%type) is

377: from per_business_groups
378: where business_group_id = c_business_group_id;
379:
380:
381: cursor c_report_mode(c_mode hr_lookups.lookup_code%type) is
382: select h.meaning from hr_lookups h
383: where h.lookup_type = 'PAY_ACTIONS_NOT_PROCESSED'
384: and h.lookup_code = c_mode
385: and h.enabled_flag = 'Y';

Line 382: select h.meaning from hr_lookups h

378: where business_group_id = c_business_group_id;
379:
380:
381: cursor c_report_mode(c_mode hr_lookups.lookup_code%type) is
382: select h.meaning from hr_lookups h
383: where h.lookup_type = 'PAY_ACTIONS_NOT_PROCESSED'
384: and h.lookup_code = c_mode
385: and h.enabled_flag = 'Y';
386: