eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_KR_FF_FUNCTIONS_PKG dependencies on PER_CONTACT_RELATIONSHIPS

Line 727: per_contact_relationships ctr,

723: cursor csr_new_born is
724: select
725: nvl(cei.cei_information13, 'N')
726: from per_people_f per,
727: per_contact_relationships ctr,
728: per_assignments_f asg,
729: per_contact_extra_info_f cei
730: where asg.assignment_id = p_assignment_id
731: and p_date_earned

Line 839: per_contact_relationships ctr,

835: decode(ctr.cont_information7, 'Y', child_flag(per.national_identifier, p_date_earned), 'N') CHILD_FLAG,
836: -- Bug 6784288 Bug 6825145
837: decode(ctr.cont_information2, 'Y', decode(ctr.cont_information11,'4',underaged_dpnt_flag(ctr.contact_type, per.national_identifier, p_date_earned),addtl_child_flag(ctr.contact_type, per.national_identifier, p_date_earned)), 'N') ADDTL_CHILD
838: from per_people_f per,
839: per_contact_relationships ctr,
840: per_assignments_f asg
841: where asg.assignment_id = p_assignment_id
842: and p_date_earned
843: between asg.effective_start_date and asg.effective_end_date

Line 1115: p_cont_type in per_contact_relationships.contact_type%type,

1111: -- for any basic or additional exemption,
1112: -- 'N' otherwise.
1113: --
1114: function is_exempted_dependent(
1115: p_cont_type in per_contact_relationships.contact_type%type,
1116: p_ni in per_people_f.national_identifier%type,
1117: p_itax_dpnt_flag in per_contact_relationships.cont_information2%type,
1118: p_addl_tax_exem_flag in per_contact_relationships.cont_information3%type,
1119: p_addl_disabled_flag in per_contact_relationships.cont_information4%type,

Line 1117: p_itax_dpnt_flag in per_contact_relationships.cont_information2%type,

1113: --
1114: function is_exempted_dependent(
1115: p_cont_type in per_contact_relationships.contact_type%type,
1116: p_ni in per_people_f.national_identifier%type,
1117: p_itax_dpnt_flag in per_contact_relationships.cont_information2%type,
1118: p_addl_tax_exem_flag in per_contact_relationships.cont_information3%type,
1119: p_addl_disabled_flag in per_contact_relationships.cont_information4%type,
1120: p_addl_exem_flag_child in per_contact_relationships.cont_information7%type,
1121: p_age_ckh_exp_flag in per_contact_relationships.cont_information8%type,

Line 1118: p_addl_tax_exem_flag in per_contact_relationships.cont_information3%type,

1114: function is_exempted_dependent(
1115: p_cont_type in per_contact_relationships.contact_type%type,
1116: p_ni in per_people_f.national_identifier%type,
1117: p_itax_dpnt_flag in per_contact_relationships.cont_information2%type,
1118: p_addl_tax_exem_flag in per_contact_relationships.cont_information3%type,
1119: p_addl_disabled_flag in per_contact_relationships.cont_information4%type,
1120: p_addl_exem_flag_child in per_contact_relationships.cont_information7%type,
1121: p_age_ckh_exp_flag in per_contact_relationships.cont_information8%type,
1122: p_eff_date in pay_payroll_actions.effective_date%type,

Line 1119: p_addl_disabled_flag in per_contact_relationships.cont_information4%type,

1115: p_cont_type in per_contact_relationships.contact_type%type,
1116: p_ni in per_people_f.national_identifier%type,
1117: p_itax_dpnt_flag in per_contact_relationships.cont_information2%type,
1118: p_addl_tax_exem_flag in per_contact_relationships.cont_information3%type,
1119: p_addl_disabled_flag in per_contact_relationships.cont_information4%type,
1120: p_addl_exem_flag_child in per_contact_relationships.cont_information7%type,
1121: p_age_ckh_exp_flag in per_contact_relationships.cont_information8%type,
1122: p_eff_date in pay_payroll_actions.effective_date%type,
1123: p_ins_prem_exem_incl_flag in per_contact_relationships.cont_information10%type, -- Bug 4931542

Line 1120: p_addl_exem_flag_child in per_contact_relationships.cont_information7%type,

1116: p_ni in per_people_f.national_identifier%type,
1117: p_itax_dpnt_flag in per_contact_relationships.cont_information2%type,
1118: p_addl_tax_exem_flag in per_contact_relationships.cont_information3%type,
1119: p_addl_disabled_flag in per_contact_relationships.cont_information4%type,
1120: p_addl_exem_flag_child in per_contact_relationships.cont_information7%type,
1121: p_age_ckh_exp_flag in per_contact_relationships.cont_information8%type,
1122: p_eff_date in pay_payroll_actions.effective_date%type,
1123: p_ins_prem_exem_incl_flag in per_contact_relationships.cont_information10%type, -- Bug 4931542
1124: p_med_exp_exem_incl_flag in per_contact_relationships.cont_information12%type, -- Bug 4931542

Line 1121: p_age_ckh_exp_flag in per_contact_relationships.cont_information8%type,

1117: p_itax_dpnt_flag in per_contact_relationships.cont_information2%type,
1118: p_addl_tax_exem_flag in per_contact_relationships.cont_information3%type,
1119: p_addl_disabled_flag in per_contact_relationships.cont_information4%type,
1120: p_addl_exem_flag_child in per_contact_relationships.cont_information7%type,
1121: p_age_ckh_exp_flag in per_contact_relationships.cont_information8%type,
1122: p_eff_date in pay_payroll_actions.effective_date%type,
1123: p_ins_prem_exem_incl_flag in per_contact_relationships.cont_information10%type, -- Bug 4931542
1124: p_med_exp_exem_incl_flag in per_contact_relationships.cont_information12%type, -- Bug 4931542
1125: p_edu_exp_exem_incl_flag in per_contact_relationships.cont_information13%type, -- Bug 4931542

Line 1123: p_ins_prem_exem_incl_flag in per_contact_relationships.cont_information10%type, -- Bug 4931542

1119: p_addl_disabled_flag in per_contact_relationships.cont_information4%type,
1120: p_addl_exem_flag_child in per_contact_relationships.cont_information7%type,
1121: p_age_ckh_exp_flag in per_contact_relationships.cont_information8%type,
1122: p_eff_date in pay_payroll_actions.effective_date%type,
1123: p_ins_prem_exem_incl_flag in per_contact_relationships.cont_information10%type, -- Bug 4931542
1124: p_med_exp_exem_incl_flag in per_contact_relationships.cont_information12%type, -- Bug 4931542
1125: p_edu_exp_exem_incl_flag in per_contact_relationships.cont_information13%type, -- Bug 4931542
1126: p_card_exp_exem_incl_flag in per_contact_relationships.cont_information14%type, -- Bug 4931542
1127: p_contact_extra_info_id in per_contact_extra_info_f.contact_extra_info_id%type -- Bug 5879106

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

1120: p_addl_exem_flag_child in per_contact_relationships.cont_information7%type,
1121: p_age_ckh_exp_flag in per_contact_relationships.cont_information8%type,
1122: p_eff_date in pay_payroll_actions.effective_date%type,
1123: p_ins_prem_exem_incl_flag in per_contact_relationships.cont_information10%type, -- Bug 4931542
1124: p_med_exp_exem_incl_flag in per_contact_relationships.cont_information12%type, -- Bug 4931542
1125: p_edu_exp_exem_incl_flag in per_contact_relationships.cont_information13%type, -- Bug 4931542
1126: p_card_exp_exem_incl_flag in per_contact_relationships.cont_information14%type, -- Bug 4931542
1127: p_contact_extra_info_id in per_contact_extra_info_f.contact_extra_info_id%type -- Bug 5879106
1128: ) return varchar2 is

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

1121: p_age_ckh_exp_flag in per_contact_relationships.cont_information8%type,
1122: p_eff_date in pay_payroll_actions.effective_date%type,
1123: p_ins_prem_exem_incl_flag in per_contact_relationships.cont_information10%type, -- Bug 4931542
1124: p_med_exp_exem_incl_flag in per_contact_relationships.cont_information12%type, -- Bug 4931542
1125: p_edu_exp_exem_incl_flag in per_contact_relationships.cont_information13%type, -- Bug 4931542
1126: p_card_exp_exem_incl_flag in per_contact_relationships.cont_information14%type, -- Bug 4931542
1127: p_contact_extra_info_id in per_contact_extra_info_f.contact_extra_info_id%type -- Bug 5879106
1128: ) return varchar2 is
1129: --

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

1122: p_eff_date in pay_payroll_actions.effective_date%type,
1123: p_ins_prem_exem_incl_flag in per_contact_relationships.cont_information10%type, -- Bug 4931542
1124: p_med_exp_exem_incl_flag in per_contact_relationships.cont_information12%type, -- Bug 4931542
1125: p_edu_exp_exem_incl_flag in per_contact_relationships.cont_information13%type, -- Bug 4931542
1126: p_card_exp_exem_incl_flag in per_contact_relationships.cont_information14%type, -- Bug 4931542
1127: p_contact_extra_info_id in per_contact_extra_info_f.contact_extra_info_id%type -- Bug 5879106
1128: ) return varchar2 is
1129: --
1130: cursor csr_contact_extra_info(p_cont_extra_info_id number) is

Line 1261: p_cont_type in per_contact_relationships.contact_type%type,

1257: --
1258:
1259:
1260: function dpnt_eligible_for_basic_exem(
1261: p_cont_type in per_contact_relationships.contact_type%type,
1262: p_ni in per_people_f.national_identifier%type,
1263: p_itax_dpnt_flag in per_contact_relationships.cont_information2%type,
1264: p_addl_disabled_flag in per_contact_relationships.cont_information4%type,
1265: p_age_ckh_exp_flag in per_contact_relationships.cont_information8%type,

Line 1263: p_itax_dpnt_flag in per_contact_relationships.cont_information2%type,

1259:
1260: function dpnt_eligible_for_basic_exem(
1261: p_cont_type in per_contact_relationships.contact_type%type,
1262: p_ni in per_people_f.national_identifier%type,
1263: p_itax_dpnt_flag in per_contact_relationships.cont_information2%type,
1264: p_addl_disabled_flag in per_contact_relationships.cont_information4%type,
1265: p_age_ckh_exp_flag in per_contact_relationships.cont_information8%type,
1266: p_eff_date in pay_payroll_actions.effective_date%type
1267: ) return varchar2

Line 1264: p_addl_disabled_flag in per_contact_relationships.cont_information4%type,

1260: function dpnt_eligible_for_basic_exem(
1261: p_cont_type in per_contact_relationships.contact_type%type,
1262: p_ni in per_people_f.national_identifier%type,
1263: p_itax_dpnt_flag in per_contact_relationships.cont_information2%type,
1264: p_addl_disabled_flag in per_contact_relationships.cont_information4%type,
1265: p_age_ckh_exp_flag in per_contact_relationships.cont_information8%type,
1266: p_eff_date in pay_payroll_actions.effective_date%type
1267: ) return varchar2
1268: is

Line 1265: p_age_ckh_exp_flag in per_contact_relationships.cont_information8%type,

1261: p_cont_type in per_contact_relationships.contact_type%type,
1262: p_ni in per_people_f.national_identifier%type,
1263: p_itax_dpnt_flag in per_contact_relationships.cont_information2%type,
1264: p_addl_disabled_flag in per_contact_relationships.cont_information4%type,
1265: p_age_ckh_exp_flag in per_contact_relationships.cont_information8%type,
1266: p_eff_date in pay_payroll_actions.effective_date%type
1267: ) return varchar2
1268: is
1269: begin

Line 1395: per_contact_relationships ctr

1391: ctr.cont_information2 itax_law,
1392: nvl(ctr.cont_information11, '0') kr_cont_type,
1393: decode(ctr.contact_type, 'P', '1', 'S', '3', 'A', '4', 'C', '4', 'R', '4', 'O', '4', 'T', '4', '6') cont_type
1394: from
1395: per_contact_relationships ctr
1396: where
1397: ctr.person_id = p_person_id
1398: and ctr.cont_information_category = 'KR'
1399: and ctr.cont_information1 = 'Y'