61: function get_avg_5_highest_salary
62: (
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
62: (
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
74: function get_avg_5_lowest_salary
75: (
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
75: (
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
141: (
142: p_report_code in varchar2,
143: p_report_date in per_all_assignments_f.effective_end_date%type,
144: p_business_group_id in per_all_assignments_f.business_group_id%type,
145: p_legal_entity_id in per_assignment_extra_info.aei_information7%type := null
146: );
147:
148: -- This function retrieves the functional data via dynamic sql from the appropriate flexfield segment
149: function get_functional_data
170: procedure populate_ee_table_EEWF
171: (
172: p_report_date in per_all_assignments_f.effective_end_date%type,
173: p_business_group_id in per_all_assignments_f.business_group_id%type,
174: p_legal_entity_id in per_assignment_extra_info.aei_information7%type := null
175: );
176:
177:
178: PROCEDURE ins_g_Enc_Diff_table(p_mi_inc IN number
215: procedure init_g_cat_lev_table
216: (
217: p_report_date in per_all_assignments_f.effective_end_date%type,
218: p_business_group_id in per_all_assignments_f.business_group_id%type,
219: p_legal_entity_id in per_assignment_extra_info.aei_information7%type := null,
220: p_salary_method in varchar2 -- SAL = Salary Basis Method, BAL = Payroll Balances Method
221: );
222:
223: