92:
93: -- This function returns the person's legislated employment type (permanent or non-permanent)
94: function get_ee_employment_type_name
95: (
96: p_report_date in per_all_people_f.start_date%type,
97: p_period_of_service_id in per_all_assignments_f.period_of_service_id%type
98: ) return varchar2;
99:
100: -- This function returns the occupational categories from the user tables.
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
222: , p_occupational_category_id IN hr_lookups.lookup_code%type
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
222: , p_occupational_category_id IN hr_lookups.lookup_code%type
223: ) ;