46: );
47:
48: function get_occupational_category
49: (
50: p_report_date in per_all_assignments_f.effective_end_date%type,
51: p_assignment_id in per_all_assignments_f.assignment_id%type,
52: p_job_id in per_all_assignments_f.job_id%type,
53: p_grade_id in per_all_assignments_f.grade_id%type,
54: p_position_id in per_all_assignments_f.position_id%type,
47:
48: function get_occupational_category
49: (
50: p_report_date in per_all_assignments_f.effective_end_date%type,
51: p_assignment_id in per_all_assignments_f.assignment_id%type,
52: p_job_id in per_all_assignments_f.job_id%type,
53: p_grade_id in per_all_assignments_f.grade_id%type,
54: p_position_id in per_all_assignments_f.position_id%type,
55: p_business_group_id in per_all_assignments_f.business_group_id%type
48: function get_occupational_category
49: (
50: p_report_date in per_all_assignments_f.effective_end_date%type,
51: p_assignment_id in per_all_assignments_f.assignment_id%type,
52: p_job_id in per_all_assignments_f.job_id%type,
53: p_grade_id in per_all_assignments_f.grade_id%type,
54: p_position_id in per_all_assignments_f.position_id%type,
55: p_business_group_id in per_all_assignments_f.business_group_id%type
56: ) return varchar2 ;
49: (
50: p_report_date in per_all_assignments_f.effective_end_date%type,
51: p_assignment_id in per_all_assignments_f.assignment_id%type,
52: p_job_id in per_all_assignments_f.job_id%type,
53: p_grade_id in per_all_assignments_f.grade_id%type,
54: p_position_id in per_all_assignments_f.position_id%type,
55: p_business_group_id in per_all_assignments_f.business_group_id%type
56: ) return varchar2 ;
57:
50: p_report_date in per_all_assignments_f.effective_end_date%type,
51: p_assignment_id in per_all_assignments_f.assignment_id%type,
52: p_job_id in per_all_assignments_f.job_id%type,
53: p_grade_id in per_all_assignments_f.grade_id%type,
54: p_position_id in per_all_assignments_f.position_id%type,
55: p_business_group_id in per_all_assignments_f.business_group_id%type
56: ) return varchar2 ;
57:
58: function get_parameter
51: p_assignment_id in per_all_assignments_f.assignment_id%type,
52: p_job_id in per_all_assignments_f.job_id%type,
53: p_grade_id in per_all_assignments_f.grade_id%type,
54: p_position_id in per_all_assignments_f.position_id%type,
55: p_business_group_id in per_all_assignments_f.business_group_id%type
56: ) return varchar2 ;
57:
58: function get_parameter
59: (