DBA Data[Home] [Help]

APPS.PAY_KR_FF_FUNCTIONS_PKG dependencies on PER_CONTACT_RELATIONSHIPS

Line 171: p_cont_type in per_contact_relationships.contact_type%type,

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,

Line 173: p_itax_dpnt_flag in per_contact_relationships.cont_information2%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,

Line 174: p_addl_tax_exem_flag in per_contact_relationships.cont_information3%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,

Line 175: p_addl_disabled_flag in per_contact_relationships.cont_information4%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

Line 176: p_addl_exem_flag_child in per_contact_relationships.cont_information7%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
180: p_med_exp_exem_incl_flag in per_contact_relationships.cont_information12%type, -- Bug 4931542

Line 177: p_age_ckh_exp_flag in per_contact_relationships.cont_information8%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
181: p_edu_exp_exem_incl_flag in per_contact_relationships.cont_information13%type, -- Bug 4931542

Line 179: p_ins_prem_exem_incl_flag in per_contact_relationships.cont_information10%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

Line 180: p_med_exp_exem_incl_flag in per_contact_relationships.cont_information12%type, -- Bug 4931542

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 ;

Line 181: p_edu_exp_exem_incl_flag in per_contact_relationships.cont_information13%type, -- Bug 4931542

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

Line 182: p_card_exp_exem_incl_flag in per_contact_relationships.cont_information14%type, -- Bug 4931542

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(

Line 187: p_cont_type in per_contact_relationships.contact_type%type,

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,

Line 189: p_itax_dpnt_flag in per_contact_relationships.cont_information2%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 ;

Line 190: p_addl_disabled_flag in per_contact_relationships.cont_information4%type,

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

Line 191: p_age_ckh_exp_flag in per_contact_relationships.cont_information8%type,

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(