167: ) return number;
168: --------------------------------------------------------------------------------
169: -- Bug 4674552
170: function is_exempted_dependent(
171: p_cont_type in per_contact_relationships.contact_type%type,
172: p_ni in per_people_f.national_identifier%type,
173: p_itax_dpnt_flag in per_contact_relationships.cont_information2%type,
174: p_addl_tax_exem_flag in per_contact_relationships.cont_information3%type,
175: p_addl_disabled_flag in per_contact_relationships.cont_information4%type,
169: -- Bug 4674552
170: function is_exempted_dependent(
171: p_cont_type in per_contact_relationships.contact_type%type,
172: p_ni in per_people_f.national_identifier%type,
173: p_itax_dpnt_flag in per_contact_relationships.cont_information2%type,
174: p_addl_tax_exem_flag in per_contact_relationships.cont_information3%type,
175: p_addl_disabled_flag in per_contact_relationships.cont_information4%type,
176: p_addl_exem_flag_child in per_contact_relationships.cont_information7%type,
177: p_age_ckh_exp_flag in per_contact_relationships.cont_information8%type,
170: function is_exempted_dependent(
171: p_cont_type in per_contact_relationships.contact_type%type,
172: p_ni in per_people_f.national_identifier%type,
173: p_itax_dpnt_flag in per_contact_relationships.cont_information2%type,
174: p_addl_tax_exem_flag in per_contact_relationships.cont_information3%type,
175: p_addl_disabled_flag in per_contact_relationships.cont_information4%type,
176: p_addl_exem_flag_child in per_contact_relationships.cont_information7%type,
177: p_age_ckh_exp_flag in per_contact_relationships.cont_information8%type,
178: p_eff_date in pay_payroll_actions.effective_date%type,
171: p_cont_type in per_contact_relationships.contact_type%type,
172: p_ni in per_people_f.national_identifier%type,
173: p_itax_dpnt_flag in per_contact_relationships.cont_information2%type,
174: p_addl_tax_exem_flag in per_contact_relationships.cont_information3%type,
175: p_addl_disabled_flag in per_contact_relationships.cont_information4%type,
176: p_addl_exem_flag_child in per_contact_relationships.cont_information7%type,
177: p_age_ckh_exp_flag in per_contact_relationships.cont_information8%type,
178: p_eff_date in pay_payroll_actions.effective_date%type,
179: p_ins_prem_exem_incl_flag in per_contact_relationships.cont_information10%type, -- Bug 4931542
172: p_ni in per_people_f.national_identifier%type,
173: p_itax_dpnt_flag in per_contact_relationships.cont_information2%type,
174: p_addl_tax_exem_flag in per_contact_relationships.cont_information3%type,
175: p_addl_disabled_flag in per_contact_relationships.cont_information4%type,
176: p_addl_exem_flag_child in per_contact_relationships.cont_information7%type,
177: p_age_ckh_exp_flag in per_contact_relationships.cont_information8%type,
178: p_eff_date in pay_payroll_actions.effective_date%type,
179: p_ins_prem_exem_incl_flag in per_contact_relationships.cont_information10%type, -- Bug 4931542
180: p_med_exp_exem_incl_flag in per_contact_relationships.cont_information12%type, -- Bug 4931542
173: p_itax_dpnt_flag in per_contact_relationships.cont_information2%type,
174: p_addl_tax_exem_flag in per_contact_relationships.cont_information3%type,
175: p_addl_disabled_flag in per_contact_relationships.cont_information4%type,
176: p_addl_exem_flag_child in per_contact_relationships.cont_information7%type,
177: p_age_ckh_exp_flag in per_contact_relationships.cont_information8%type,
178: p_eff_date in pay_payroll_actions.effective_date%type,
179: p_ins_prem_exem_incl_flag in per_contact_relationships.cont_information10%type, -- Bug 4931542
180: p_med_exp_exem_incl_flag in per_contact_relationships.cont_information12%type, -- Bug 4931542
181: p_edu_exp_exem_incl_flag in per_contact_relationships.cont_information13%type, -- Bug 4931542
175: p_addl_disabled_flag in per_contact_relationships.cont_information4%type,
176: p_addl_exem_flag_child in per_contact_relationships.cont_information7%type,
177: p_age_ckh_exp_flag in per_contact_relationships.cont_information8%type,
178: p_eff_date in pay_payroll_actions.effective_date%type,
179: p_ins_prem_exem_incl_flag in per_contact_relationships.cont_information10%type, -- Bug 4931542
180: p_med_exp_exem_incl_flag in per_contact_relationships.cont_information12%type, -- Bug 4931542
181: p_edu_exp_exem_incl_flag in per_contact_relationships.cont_information13%type, -- Bug 4931542
182: p_card_exp_exem_incl_flag in per_contact_relationships.cont_information14%type, -- Bug 4931542
183: p_contact_extra_info_id in per_contact_extra_info_f.contact_extra_info_id%type -- Bug 5879106
176: p_addl_exem_flag_child in per_contact_relationships.cont_information7%type,
177: p_age_ckh_exp_flag in per_contact_relationships.cont_information8%type,
178: p_eff_date in pay_payroll_actions.effective_date%type,
179: p_ins_prem_exem_incl_flag in per_contact_relationships.cont_information10%type, -- Bug 4931542
180: p_med_exp_exem_incl_flag in per_contact_relationships.cont_information12%type, -- Bug 4931542
181: p_edu_exp_exem_incl_flag in per_contact_relationships.cont_information13%type, -- Bug 4931542
182: p_card_exp_exem_incl_flag in per_contact_relationships.cont_information14%type, -- Bug 4931542
183: p_contact_extra_info_id in per_contact_extra_info_f.contact_extra_info_id%type -- Bug 5879106
184: ) return varchar2 ;
177: p_age_ckh_exp_flag in per_contact_relationships.cont_information8%type,
178: p_eff_date in pay_payroll_actions.effective_date%type,
179: p_ins_prem_exem_incl_flag in per_contact_relationships.cont_information10%type, -- Bug 4931542
180: p_med_exp_exem_incl_flag in per_contact_relationships.cont_information12%type, -- Bug 4931542
181: p_edu_exp_exem_incl_flag in per_contact_relationships.cont_information13%type, -- Bug 4931542
182: p_card_exp_exem_incl_flag in per_contact_relationships.cont_information14%type, -- Bug 4931542
183: p_contact_extra_info_id in per_contact_extra_info_f.contact_extra_info_id%type -- Bug 5879106
184: ) return varchar2 ;
185: --------------------------------------------------------------------------------
178: p_eff_date in pay_payroll_actions.effective_date%type,
179: p_ins_prem_exem_incl_flag in per_contact_relationships.cont_information10%type, -- Bug 4931542
180: p_med_exp_exem_incl_flag in per_contact_relationships.cont_information12%type, -- Bug 4931542
181: p_edu_exp_exem_incl_flag in per_contact_relationships.cont_information13%type, -- Bug 4931542
182: p_card_exp_exem_incl_flag in per_contact_relationships.cont_information14%type, -- Bug 4931542
183: p_contact_extra_info_id in per_contact_extra_info_f.contact_extra_info_id%type -- Bug 5879106
184: ) return varchar2 ;
185: --------------------------------------------------------------------------------
186: function dpnt_eligible_for_basic_exem(
183: p_contact_extra_info_id in per_contact_extra_info_f.contact_extra_info_id%type -- Bug 5879106
184: ) return varchar2 ;
185: --------------------------------------------------------------------------------
186: function dpnt_eligible_for_basic_exem(
187: p_cont_type in per_contact_relationships.contact_type%type,
188: p_ni in per_people_f.national_identifier%type,
189: p_itax_dpnt_flag in per_contact_relationships.cont_information2%type,
190: p_addl_disabled_flag in per_contact_relationships.cont_information4%type,
191: p_age_ckh_exp_flag in per_contact_relationships.cont_information8%type,
185: --------------------------------------------------------------------------------
186: function dpnt_eligible_for_basic_exem(
187: p_cont_type in per_contact_relationships.contact_type%type,
188: p_ni in per_people_f.national_identifier%type,
189: p_itax_dpnt_flag in per_contact_relationships.cont_information2%type,
190: p_addl_disabled_flag in per_contact_relationships.cont_information4%type,
191: p_age_ckh_exp_flag in per_contact_relationships.cont_information8%type,
192: p_eff_date in pay_payroll_actions.effective_date%type
193: ) return varchar2 ;
186: function dpnt_eligible_for_basic_exem(
187: p_cont_type in per_contact_relationships.contact_type%type,
188: p_ni in per_people_f.national_identifier%type,
189: p_itax_dpnt_flag in per_contact_relationships.cont_information2%type,
190: p_addl_disabled_flag in per_contact_relationships.cont_information4%type,
191: p_age_ckh_exp_flag in per_contact_relationships.cont_information8%type,
192: p_eff_date in pay_payroll_actions.effective_date%type
193: ) return varchar2 ;
194: --------------------------------------------------------------------------------
187: p_cont_type in per_contact_relationships.contact_type%type,
188: p_ni in per_people_f.national_identifier%type,
189: p_itax_dpnt_flag in per_contact_relationships.cont_information2%type,
190: p_addl_disabled_flag in per_contact_relationships.cont_information4%type,
191: p_age_ckh_exp_flag in per_contact_relationships.cont_information8%type,
192: p_eff_date in pay_payroll_actions.effective_date%type
193: ) return varchar2 ;
194: --------------------------------------------------------------------------------
195: function dpnt_addl_child_exempted(