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 74: p_occupational_level_cat in hr_lookups.meaning%type,

70: p_report_date in per_all_assignments_f.effective_end_date%type,
71: p_business_group_id in per_all_assignments_f.business_group_id%type,
72: p_legent_param in per_assignment_extra_info.aei_information7%type := null,
73: p_legal_entity_id in per_assignment_extra_info.aei_information7%type := null,
74: p_occupational_level_cat in hr_lookups.meaning%type,
75: p_lookup_code in hr_lookups.lookup_code%type,
76: p_occupational_type in varchar2, -- CAT = Occupational Category , LEV = Occupational Level
77: p_salary_method in varchar2 -- SAL = Salary Basis Method, BAL = Payroll Balances Method
78: ) return number;

Line 75: p_lookup_code in hr_lookups.lookup_code%type,

71: p_business_group_id in per_all_assignments_f.business_group_id%type,
72: p_legent_param in per_assignment_extra_info.aei_information7%type := null,
73: p_legal_entity_id in per_assignment_extra_info.aei_information7%type := null,
74: p_occupational_level_cat in hr_lookups.meaning%type,
75: p_lookup_code in hr_lookups.lookup_code%type,
76: p_occupational_type in varchar2, -- CAT = Occupational Category , LEV = Occupational Level
77: p_salary_method in varchar2 -- SAL = Salary Basis Method, BAL = Payroll Balances Method
78: ) return number;
79:

Line 87: p_occupational_level_cat in hr_lookups.meaning%type,

83: p_report_date in per_all_assignments_f.effective_end_date%type,
84: p_business_group_id in per_all_assignments_f.business_group_id%type,
85: p_legent_param in per_assignment_extra_info.aei_information7%type := null,
86: p_legal_entity_id in per_assignment_extra_info.aei_information7%type := null,
87: p_occupational_level_cat in hr_lookups.meaning%type,
88: p_lookup_code in hr_lookups.lookup_code%type,
89: p_occupational_type in varchar2, -- CAT = Occupational Category , LEV = Occupational Level
90: p_salary_method in varchar2 -- SAL = Salary Basis Method, BAL = Payroll Balances Method
91: ) return number;

Line 88: p_lookup_code in hr_lookups.lookup_code%type,

84: p_business_group_id in per_all_assignments_f.business_group_id%type,
85: p_legent_param in per_assignment_extra_info.aei_information7%type := null,
86: p_legal_entity_id in per_assignment_extra_info.aei_information7%type := null,
87: p_occupational_level_cat in hr_lookups.meaning%type,
88: p_lookup_code in hr_lookups.lookup_code%type,
89: p_occupational_type in varchar2, -- CAT = Occupational Category , LEV = Occupational Level
90: p_salary_method in varchar2 -- SAL = Salary Basis Method, BAL = Payroll Balances Method
91: ) return number;
92:

Line 145: p_meaning in hr_lookups.meaning%type

141:
142: -- This function returns the lookup_code from the user tables.
143: function get_lookup_code
144: (
145: p_meaning in hr_lookups.meaning%type
146: ) return varchar2;
147:
148: -- This function populates an entity's sex and race and category matches.
149: procedure populate_ee_table

Line 209: , p_occupational_level IN hr_lookups.meaning%type

205: , p_total IN number
206: , p_cat_index IN number
207: , p_lev_index IN number
208: , p_legal_entity_id IN hr_all_organization_units.organization_id%type
209: , p_occupational_level IN hr_lookups.meaning%type
210: , p_occupational_category IN hr_lookups.meaning%type
211: , p_occupational_level_id IN hr_lookups.lookup_code%type
212: , p_occupational_category_id IN hr_lookups.lookup_code%type
213: );

Line 210: , p_occupational_category IN hr_lookups.meaning%type

206: , p_cat_index IN number
207: , p_lev_index IN number
208: , p_legal_entity_id IN hr_all_organization_units.organization_id%type
209: , p_occupational_level IN hr_lookups.meaning%type
210: , p_occupational_category IN hr_lookups.meaning%type
211: , p_occupational_level_id IN hr_lookups.lookup_code%type
212: , p_occupational_category_id IN hr_lookups.lookup_code%type
213: );
214:

Line 211: , p_occupational_level_id IN hr_lookups.lookup_code%type

207: , p_lev_index IN number
208: , p_legal_entity_id IN hr_all_organization_units.organization_id%type
209: , p_occupational_level IN hr_lookups.meaning%type
210: , p_occupational_category IN hr_lookups.meaning%type
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 cat_lev_data ( p_legal_entity_id IN hr_all_organization_units.organization_id%type

Line 212: , p_occupational_category_id IN hr_lookups.lookup_code%type

208: , p_legal_entity_id IN hr_all_organization_units.organization_id%type
209: , p_occupational_level IN hr_lookups.meaning%type
210: , p_occupational_category IN hr_lookups.meaning%type
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 cat_lev_data ( p_legal_entity_id IN hr_all_organization_units.organization_id%type
216: , p_occupational_level IN hr_lookups.meaning%type

Line 216: , p_occupational_level IN hr_lookups.meaning%type

212: , p_occupational_category_id IN hr_lookups.lookup_code%type
213: );
214:
215: Procedure cat_lev_data ( p_legal_entity_id IN hr_all_organization_units.organization_id%type
216: , p_occupational_level IN hr_lookups.meaning%type
217: , p_occupational_category IN hr_lookups.meaning%type
218: , p_race IN per_all_people_f.per_information4%type
219: , p_sex IN per_all_people_f.sex%type
220: , p_income IN number

Line 217: , p_occupational_category IN hr_lookups.meaning%type

213: );
214:
215: Procedure cat_lev_data ( p_legal_entity_id IN hr_all_organization_units.organization_id%type
216: , p_occupational_level IN hr_lookups.meaning%type
217: , p_occupational_category IN hr_lookups.meaning%type
218: , p_race IN per_all_people_f.per_information4%type
219: , p_sex IN per_all_people_f.sex%type
220: , p_income IN number
221: , p_occupational_level_id IN hr_lookups.lookup_code%type

Line 221: , p_occupational_level_id IN hr_lookups.lookup_code%type

217: , p_occupational_category IN hr_lookups.meaning%type
218: , p_race IN per_all_people_f.per_information4%type
219: , p_sex IN per_all_people_f.sex%type
220: , p_income IN number
221: , p_occupational_level_id IN hr_lookups.lookup_code%type
222: , p_occupational_category_id IN hr_lookups.lookup_code%type
223: ) ;
224:
225: procedure init_g_cat_lev_table

Line 222: , p_occupational_category_id IN hr_lookups.lookup_code%type

218: , p_race IN per_all_people_f.per_information4%type
219: , p_sex IN per_all_people_f.sex%type
220: , p_income IN number
221: , p_occupational_level_id IN hr_lookups.lookup_code%type
222: , p_occupational_category_id IN hr_lookups.lookup_code%type
223: ) ;
224:
225: procedure init_g_cat_lev_table
226: (