DBA Data[Home] [Help]

APPS.PER_ZA_EMPLOYMENT_EQUITY_PKG dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 72: p_legent_param in per_assignment_extra_info.aei_information7%type := null,

68: function get_avg_5_highest_salary
69: (
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

Line 73: p_legal_entity_id in per_assignment_extra_info.aei_information7%type := null,

69: (
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

Line 85: p_legent_param in per_assignment_extra_info.aei_information7%type := null,

81: function get_avg_5_lowest_salary
82: (
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

Line 86: p_legal_entity_id in per_assignment_extra_info.aei_information7%type := null,

82: (
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

Line 154: p_legal_entity_id in per_assignment_extra_info.aei_information7%type := null

150: (
151: p_report_code in varchar2,
152: p_report_date in per_all_assignments_f.effective_end_date%type,
153: p_business_group_id in per_all_assignments_f.business_group_id%type,
154: p_legal_entity_id in per_assignment_extra_info.aei_information7%type := null
155: );
156:
157: -- This function retrieves the functional data via dynamic sql from the appropriate flexfield segment
158: function get_functional_data

Line 184: p_legal_entity_id in per_assignment_extra_info.aei_information7%type := null

180: procedure populate_ee_table_EEWF
181: (
182: p_report_date in per_all_assignments_f.effective_end_date%type,
183: p_business_group_id in per_all_assignments_f.business_group_id%type,
184: p_legal_entity_id in per_assignment_extra_info.aei_information7%type := null
185: );
186:
187:
188: PROCEDURE ins_g_Enc_Diff_table(p_mi_inc IN number

Line 229: p_legal_entity_id in per_assignment_extra_info.aei_information7%type := null,

225: procedure init_g_cat_lev_table
226: (
227: p_report_date in per_all_assignments_f.effective_end_date%type,
228: p_business_group_id in per_all_assignments_f.business_group_id%type,
229: p_legal_entity_id in per_assignment_extra_info.aei_information7%type := null,
230: p_salary_method in varchar2 -- SAL = Salary Basis Method, BAL = Payroll Balances Method
231: );
232:
233: procedure init_g_cat_lev_new_table

Line 237: p_legal_entity_id in per_assignment_extra_info.aei_information7%type := null,

233: procedure init_g_cat_lev_new_table
234: (
235: p_report_date in per_all_assignments_f.effective_end_date%type,
236: p_business_group_id in per_all_assignments_f.business_group_id%type,
237: p_legal_entity_id in per_assignment_extra_info.aei_information7%type := null,
238: p_salary_method in varchar2 -- SAL = Salary Basis Method, BAL = Payroll Balances Method
239: );
240:
241: function get_termination_reason_new

Line 253: p_legal_entity_id in per_assignment_extra_info.aei_information7%type := null

249: (
250: p_report_code in varchar2,
251: p_report_date in per_all_assignments_f.effective_end_date%type,
252: p_business_group_id in per_all_assignments_f.business_group_id%type,
253: p_legal_entity_id in per_assignment_extra_info.aei_information7%type := null
254: );
255:
256: procedure populate_ee_table_EEWF_new
257: (

Line 260: p_legal_entity_id in per_assignment_extra_info.aei_information7%type := null

256: procedure populate_ee_table_EEWF_new
257: (
258: p_report_date in per_all_assignments_f.effective_end_date%type,
259: p_business_group_id in per_all_assignments_f.business_group_id%type,
260: p_legal_entity_id in per_assignment_extra_info.aei_information7%type := null
261: );
262:
263: end per_za_employment_equity_pkg;