DBA Data[Home] [Help]

APPS.PER_ZA_EMPLOYMENT_EQUITY_PKG dependencies on PER_ASSIGNMENT_EXTRA_INFO

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

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

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

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

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

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

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

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

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

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

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

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

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

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: