DBA Data[Home] [Help]

APPS.PAY_KR_FF_FUNCTIONS_PKG dependencies on PER_CONTACT_RELATIONSHIPS

Line 250: p_cont_type in per_contact_relationships.contact_type%type,

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,

Line 251: p_kr_cont_typ in per_contact_relationships.cont_information11%type, -- Bug 7661820

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,

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

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

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

Line 256: p_addl_exem_flag_child in per_contact_relationships.cont_information7%type,

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

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

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

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

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 ;

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

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

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

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(

Line 267: p_cont_type in per_contact_relationships.contact_type%type,

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,

Line 268: p_kr_cont_typ in per_contact_relationships.cont_information11%type, -- Bug 7661820

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,

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

Line 271: p_addl_disabled_flag in per_contact_relationships.cont_information4%type,

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

Line 272: p_age_ckh_exp_flag in per_contact_relationships.cont_information8%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: --------------------------------------------------------------------------------
276: function dpnt_addl_child_exempted(