eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_ZA_EMPLOYMENT_EQUITY_PKG dependencies on HR_LOOKUPS

Line 67: p_occupational_level_cat in hr_lookups.meaning%type,

63: p_report_date in per_all_assignments_f.effective_end_date%type,
64: p_business_group_id in per_all_assignments_f.business_group_id%type,
65: p_legent_param in per_assignment_extra_info.aei_information7%type := null,
66: p_legal_entity_id in per_assignment_extra_info.aei_information7%type := null,
67: p_occupational_level_cat in hr_lookups.meaning%type,
68: p_lookup_code in hr_lookups.lookup_code%type,
69: p_occupational_type in varchar2, -- CAT = Occupational Category , LEV = Occupational Level
70: p_salary_method in varchar2 -- SAL = Salary Basis Method, BAL = Payroll Balances Method
71: ) return number;

Line 68: p_lookup_code in hr_lookups.lookup_code%type,

64: p_business_group_id in per_all_assignments_f.business_group_id%type,
65: p_legent_param in per_assignment_extra_info.aei_information7%type := null,
66: p_legal_entity_id in per_assignment_extra_info.aei_information7%type := null,
67: p_occupational_level_cat in hr_lookups.meaning%type,
68: p_lookup_code in hr_lookups.lookup_code%type,
69: p_occupational_type in varchar2, -- CAT = Occupational Category , LEV = Occupational Level
70: p_salary_method in varchar2 -- SAL = Salary Basis Method, BAL = Payroll Balances Method
71: ) return number;
72:

Line 80: p_occupational_level_cat in hr_lookups.meaning%type,

76: p_report_date in per_all_assignments_f.effective_end_date%type,
77: p_business_group_id in per_all_assignments_f.business_group_id%type,
78: p_legent_param in per_assignment_extra_info.aei_information7%type := null,
79: p_legal_entity_id in per_assignment_extra_info.aei_information7%type := null,
80: p_occupational_level_cat in hr_lookups.meaning%type,
81: p_lookup_code in hr_lookups.lookup_code%type,
82: p_occupational_type in varchar2, -- CAT = Occupational Category , LEV = Occupational Level
83: p_salary_method in varchar2 -- SAL = Salary Basis Method, BAL = Payroll Balances Method
84: ) return number;

Line 81: p_lookup_code in hr_lookups.lookup_code%type,

77: p_business_group_id in per_all_assignments_f.business_group_id%type,
78: p_legent_param in per_assignment_extra_info.aei_information7%type := null,
79: p_legal_entity_id in per_assignment_extra_info.aei_information7%type := null,
80: p_occupational_level_cat in hr_lookups.meaning%type,
81: p_lookup_code in hr_lookups.lookup_code%type,
82: p_occupational_type in varchar2, -- CAT = Occupational Category , LEV = Occupational Level
83: p_salary_method in varchar2 -- SAL = Salary Basis Method, BAL = Payroll Balances Method
84: ) return number;
85:

Line 136: p_meaning in hr_lookups.meaning%type

132:
133: -- This function returns the lookup_code from the user tables.
134: function get_lookup_code
135: (
136: p_meaning in hr_lookups.meaning%type
137: ) return varchar2;
138:
139: -- This function populates an entity's sex and race and category matches.
140: procedure populate_ee_table

Line 199: , p_occupational_level IN hr_lookups.meaning%type

195: , p_total IN number
196: , p_cat_index IN number
197: , p_lev_index IN number
198: , p_legal_entity_id IN hr_all_organization_units.organization_id%type
199: , p_occupational_level IN hr_lookups.meaning%type
200: , p_occupational_category IN hr_lookups.meaning%type
201: , p_occupational_level_id IN hr_lookups.lookup_code%type
202: , p_occupational_category_id IN hr_lookups.lookup_code%type
203: );

Line 200: , p_occupational_category IN hr_lookups.meaning%type

196: , p_cat_index IN number
197: , p_lev_index IN number
198: , p_legal_entity_id IN hr_all_organization_units.organization_id%type
199: , p_occupational_level IN hr_lookups.meaning%type
200: , p_occupational_category IN hr_lookups.meaning%type
201: , p_occupational_level_id IN hr_lookups.lookup_code%type
202: , p_occupational_category_id IN hr_lookups.lookup_code%type
203: );
204:

Line 201: , p_occupational_level_id IN hr_lookups.lookup_code%type

197: , p_lev_index IN number
198: , p_legal_entity_id IN hr_all_organization_units.organization_id%type
199: , p_occupational_level IN hr_lookups.meaning%type
200: , p_occupational_category IN hr_lookups.meaning%type
201: , p_occupational_level_id IN hr_lookups.lookup_code%type
202: , p_occupational_category_id IN hr_lookups.lookup_code%type
203: );
204:
205: Procedure cat_lev_data ( p_legal_entity_id IN hr_all_organization_units.organization_id%type

Line 202: , p_occupational_category_id IN hr_lookups.lookup_code%type

198: , p_legal_entity_id IN hr_all_organization_units.organization_id%type
199: , p_occupational_level IN hr_lookups.meaning%type
200: , p_occupational_category IN hr_lookups.meaning%type
201: , p_occupational_level_id IN hr_lookups.lookup_code%type
202: , p_occupational_category_id IN hr_lookups.lookup_code%type
203: );
204:
205: Procedure cat_lev_data ( p_legal_entity_id IN hr_all_organization_units.organization_id%type
206: , p_occupational_level IN hr_lookups.meaning%type

Line 206: , p_occupational_level IN hr_lookups.meaning%type

202: , p_occupational_category_id IN hr_lookups.lookup_code%type
203: );
204:
205: Procedure cat_lev_data ( p_legal_entity_id IN hr_all_organization_units.organization_id%type
206: , p_occupational_level IN hr_lookups.meaning%type
207: , p_occupational_category IN hr_lookups.meaning%type
208: , p_race IN per_all_people_f.per_information4%type
209: , p_sex IN per_all_people_f.sex%type
210: , p_income IN number

Line 207: , p_occupational_category IN hr_lookups.meaning%type

203: );
204:
205: Procedure cat_lev_data ( p_legal_entity_id IN hr_all_organization_units.organization_id%type
206: , p_occupational_level IN hr_lookups.meaning%type
207: , p_occupational_category IN hr_lookups.meaning%type
208: , p_race IN per_all_people_f.per_information4%type
209: , p_sex IN per_all_people_f.sex%type
210: , p_income IN number
211: , p_occupational_level_id IN hr_lookups.lookup_code%type

Line 211: , p_occupational_level_id IN hr_lookups.lookup_code%type

207: , p_occupational_category IN hr_lookups.meaning%type
208: , p_race IN per_all_people_f.per_information4%type
209: , p_sex IN per_all_people_f.sex%type
210: , p_income IN number
211: , p_occupational_level_id IN hr_lookups.lookup_code%type
212: , p_occupational_category_id IN hr_lookups.lookup_code%type
213: ) ;
214:
215: procedure init_g_cat_lev_table

Line 212: , p_occupational_category_id IN hr_lookups.lookup_code%type

208: , p_race IN per_all_people_f.per_information4%type
209: , p_sex IN per_all_people_f.sex%type
210: , p_income IN number
211: , p_occupational_level_id IN hr_lookups.lookup_code%type
212: , p_occupational_category_id IN hr_lookups.lookup_code%type
213: ) ;
214:
215: procedure init_g_cat_lev_table
216: (