246: ) return number;
247: --------------------------------------------------------------------------------
248: -- Bug 4674552
249: function is_exempted_dependent(
250: p_cont_type in per_contact_relationships.contact_type%type,
251: p_kr_cont_typ in per_contact_relationships.cont_information11%type, -- Bug 7661820
252: p_ni in per_people_f.national_identifier%type,
253: p_itax_dpnt_flag in per_contact_relationships.cont_information2%type,
254: p_addl_tax_exem_flag in per_contact_relationships.cont_information3%type,
247: --------------------------------------------------------------------------------
248: -- Bug 4674552
249: function is_exempted_dependent(
250: p_cont_type in per_contact_relationships.contact_type%type,
251: p_kr_cont_typ in per_contact_relationships.cont_information11%type, -- Bug 7661820
252: p_ni in per_people_f.national_identifier%type,
253: p_itax_dpnt_flag in per_contact_relationships.cont_information2%type,
254: p_addl_tax_exem_flag in per_contact_relationships.cont_information3%type,
255: p_addl_disabled_flag in per_contact_relationships.cont_information4%type,
249: function is_exempted_dependent(
250: p_cont_type in per_contact_relationships.contact_type%type,
251: p_kr_cont_typ in per_contact_relationships.cont_information11%type, -- Bug 7661820
252: p_ni in per_people_f.national_identifier%type,
253: p_itax_dpnt_flag in per_contact_relationships.cont_information2%type,
254: p_addl_tax_exem_flag in per_contact_relationships.cont_information3%type,
255: p_addl_disabled_flag in per_contact_relationships.cont_information4%type,
256: p_addl_exem_flag_child in per_contact_relationships.cont_information7%type,
257: p_age_ckh_exp_flag in per_contact_relationships.cont_information8%type,
250: p_cont_type in per_contact_relationships.contact_type%type,
251: p_kr_cont_typ in per_contact_relationships.cont_information11%type, -- Bug 7661820
252: p_ni in per_people_f.national_identifier%type,
253: p_itax_dpnt_flag in per_contact_relationships.cont_information2%type,
254: p_addl_tax_exem_flag in per_contact_relationships.cont_information3%type,
255: p_addl_disabled_flag in per_contact_relationships.cont_information4%type,
256: p_addl_exem_flag_child in per_contact_relationships.cont_information7%type,
257: p_age_ckh_exp_flag in per_contact_relationships.cont_information8%type,
258: p_eff_date in pay_payroll_actions.effective_date%type,
251: p_kr_cont_typ in per_contact_relationships.cont_information11%type, -- Bug 7661820
252: p_ni in per_people_f.national_identifier%type,
253: p_itax_dpnt_flag in per_contact_relationships.cont_information2%type,
254: p_addl_tax_exem_flag in per_contact_relationships.cont_information3%type,
255: p_addl_disabled_flag in per_contact_relationships.cont_information4%type,
256: p_addl_exem_flag_child in per_contact_relationships.cont_information7%type,
257: p_age_ckh_exp_flag in per_contact_relationships.cont_information8%type,
258: p_eff_date in pay_payroll_actions.effective_date%type,
259: p_ins_prem_exem_incl_flag in per_contact_relationships.cont_information10%type, -- Bug 4931542
252: p_ni in per_people_f.national_identifier%type,
253: p_itax_dpnt_flag in per_contact_relationships.cont_information2%type,
254: p_addl_tax_exem_flag in per_contact_relationships.cont_information3%type,
255: p_addl_disabled_flag in per_contact_relationships.cont_information4%type,
256: p_addl_exem_flag_child in per_contact_relationships.cont_information7%type,
257: p_age_ckh_exp_flag in per_contact_relationships.cont_information8%type,
258: p_eff_date in pay_payroll_actions.effective_date%type,
259: p_ins_prem_exem_incl_flag in per_contact_relationships.cont_information10%type, -- Bug 4931542
260: p_med_exp_exem_incl_flag in per_contact_relationships.cont_information12%type, -- Bug 4931542
253: p_itax_dpnt_flag in per_contact_relationships.cont_information2%type,
254: p_addl_tax_exem_flag in per_contact_relationships.cont_information3%type,
255: p_addl_disabled_flag in per_contact_relationships.cont_information4%type,
256: p_addl_exem_flag_child in per_contact_relationships.cont_information7%type,
257: p_age_ckh_exp_flag in per_contact_relationships.cont_information8%type,
258: p_eff_date in pay_payroll_actions.effective_date%type,
259: p_ins_prem_exem_incl_flag in per_contact_relationships.cont_information10%type, -- Bug 4931542
260: p_med_exp_exem_incl_flag in per_contact_relationships.cont_information12%type, -- Bug 4931542
261: p_edu_exp_exem_incl_flag in per_contact_relationships.cont_information13%type, -- Bug 4931542
255: p_addl_disabled_flag in per_contact_relationships.cont_information4%type,
256: p_addl_exem_flag_child in per_contact_relationships.cont_information7%type,
257: p_age_ckh_exp_flag in per_contact_relationships.cont_information8%type,
258: p_eff_date in pay_payroll_actions.effective_date%type,
259: p_ins_prem_exem_incl_flag in per_contact_relationships.cont_information10%type, -- Bug 4931542
260: p_med_exp_exem_incl_flag in per_contact_relationships.cont_information12%type, -- Bug 4931542
261: p_edu_exp_exem_incl_flag in per_contact_relationships.cont_information13%type, -- Bug 4931542
262: p_card_exp_exem_incl_flag in per_contact_relationships.cont_information14%type, -- Bug 4931542
263: p_contact_extra_info_id in per_contact_extra_info_f.contact_extra_info_id%type -- Bug 5879106
256: p_addl_exem_flag_child in per_contact_relationships.cont_information7%type,
257: p_age_ckh_exp_flag in per_contact_relationships.cont_information8%type,
258: p_eff_date in pay_payroll_actions.effective_date%type,
259: p_ins_prem_exem_incl_flag in per_contact_relationships.cont_information10%type, -- Bug 4931542
260: p_med_exp_exem_incl_flag in per_contact_relationships.cont_information12%type, -- Bug 4931542
261: p_edu_exp_exem_incl_flag in per_contact_relationships.cont_information13%type, -- Bug 4931542
262: p_card_exp_exem_incl_flag in per_contact_relationships.cont_information14%type, -- Bug 4931542
263: p_contact_extra_info_id in per_contact_extra_info_f.contact_extra_info_id%type -- Bug 5879106
264: ) return varchar2 ;
257: p_age_ckh_exp_flag in per_contact_relationships.cont_information8%type,
258: p_eff_date in pay_payroll_actions.effective_date%type,
259: p_ins_prem_exem_incl_flag in per_contact_relationships.cont_information10%type, -- Bug 4931542
260: p_med_exp_exem_incl_flag in per_contact_relationships.cont_information12%type, -- Bug 4931542
261: p_edu_exp_exem_incl_flag in per_contact_relationships.cont_information13%type, -- Bug 4931542
262: p_card_exp_exem_incl_flag in per_contact_relationships.cont_information14%type, -- Bug 4931542
263: p_contact_extra_info_id in per_contact_extra_info_f.contact_extra_info_id%type -- Bug 5879106
264: ) return varchar2 ;
265: --------------------------------------------------------------------------------
258: p_eff_date in pay_payroll_actions.effective_date%type,
259: p_ins_prem_exem_incl_flag in per_contact_relationships.cont_information10%type, -- Bug 4931542
260: p_med_exp_exem_incl_flag in per_contact_relationships.cont_information12%type, -- Bug 4931542
261: p_edu_exp_exem_incl_flag in per_contact_relationships.cont_information13%type, -- Bug 4931542
262: p_card_exp_exem_incl_flag in per_contact_relationships.cont_information14%type, -- Bug 4931542
263: p_contact_extra_info_id in per_contact_extra_info_f.contact_extra_info_id%type -- Bug 5879106
264: ) return varchar2 ;
265: --------------------------------------------------------------------------------
266: function dpnt_eligible_for_basic_exem(
263: p_contact_extra_info_id in per_contact_extra_info_f.contact_extra_info_id%type -- Bug 5879106
264: ) return varchar2 ;
265: --------------------------------------------------------------------------------
266: function dpnt_eligible_for_basic_exem(
267: p_cont_type in per_contact_relationships.contact_type%type,
268: p_kr_cont_typ in per_contact_relationships.cont_information11%type, -- Bug 7661820
269: p_ni in per_people_f.national_identifier%type,
270: p_itax_dpnt_flag in per_contact_relationships.cont_information2%type,
271: p_addl_disabled_flag in per_contact_relationships.cont_information4%type,
264: ) return varchar2 ;
265: --------------------------------------------------------------------------------
266: function dpnt_eligible_for_basic_exem(
267: p_cont_type in per_contact_relationships.contact_type%type,
268: p_kr_cont_typ in per_contact_relationships.cont_information11%type, -- Bug 7661820
269: p_ni in per_people_f.national_identifier%type,
270: p_itax_dpnt_flag in per_contact_relationships.cont_information2%type,
271: p_addl_disabled_flag in per_contact_relationships.cont_information4%type,
272: p_age_ckh_exp_flag in per_contact_relationships.cont_information8%type,
266: function dpnt_eligible_for_basic_exem(
267: p_cont_type in per_contact_relationships.contact_type%type,
268: p_kr_cont_typ in per_contact_relationships.cont_information11%type, -- Bug 7661820
269: p_ni in per_people_f.national_identifier%type,
270: p_itax_dpnt_flag in per_contact_relationships.cont_information2%type,
271: p_addl_disabled_flag in per_contact_relationships.cont_information4%type,
272: p_age_ckh_exp_flag in per_contact_relationships.cont_information8%type,
273: p_eff_date in pay_payroll_actions.effective_date%type
274: ) return varchar2 ;
267: p_cont_type in per_contact_relationships.contact_type%type,
268: p_kr_cont_typ in per_contact_relationships.cont_information11%type, -- Bug 7661820
269: p_ni in per_people_f.national_identifier%type,
270: p_itax_dpnt_flag in per_contact_relationships.cont_information2%type,
271: p_addl_disabled_flag in per_contact_relationships.cont_information4%type,
272: p_age_ckh_exp_flag in per_contact_relationships.cont_information8%type,
273: p_eff_date in pay_payroll_actions.effective_date%type
274: ) return varchar2 ;
275: --------------------------------------------------------------------------------
268: p_kr_cont_typ in per_contact_relationships.cont_information11%type, -- Bug 7661820
269: p_ni in per_people_f.national_identifier%type,
270: p_itax_dpnt_flag in per_contact_relationships.cont_information2%type,
271: p_addl_disabled_flag in per_contact_relationships.cont_information4%type,
272: p_age_ckh_exp_flag in per_contact_relationships.cont_information8%type,
273: p_eff_date in pay_payroll_actions.effective_date%type
274: ) return varchar2 ;
275: --------------------------------------------------------------------------------
276: function dpnt_addl_child_exempted(