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 960: per_contact_relationships ctr,

956: cursor csr_new_born is
957: select
958: nvl(cei.cei_information13, 'N')
959: from per_people_f per,
960: per_contact_relationships ctr,
961: per_assignments_f asg,
962: per_contact_extra_info_f cei
963: where asg.assignment_id = p_assignment_id
964: and p_date_earned

Line 1127: per_contact_relationships ctr,

1123: -- Bug 6784288; Bug 6825145; Bug 7615517
1124: decode(ctr.cont_information2, 'Y', decode(addtl_child_flag(ctr.contact_type, per.national_identifier, ctr.cont_information4, ctr.cont_information11, ctr.cont_information15, p_date_earned),'Y','Y','N'), 'N') ADDTL_CHILD,
1125: decode(ctr.cont_information2, 'Y', single_parent_child_flag(ctr.cont_information11,ctr.contact_type,per.national_identifier, p_date_earned), 'N') SINGLE_PARENT_CHILD_FLAG
1126: from per_people_f per,
1127: per_contact_relationships ctr,
1128: per_assignments_f asg
1129: where asg.assignment_id = p_assignment_id
1130: and p_date_earned
1131: between asg.effective_start_date and asg.effective_end_date

Line 1427: p_cont_type in per_contact_relationships.contact_type%type,

1423: -- 'N' otherwise.
1424: --
1425: --
1426: function is_exempted_dependent(
1427: p_cont_type in per_contact_relationships.contact_type%type,
1428: p_kr_cont_typ in per_contact_relationships.cont_information11%type, -- Bug 7661820
1429: p_ni in per_people_f.national_identifier%type,
1430: p_itax_dpnt_flag in per_contact_relationships.cont_information2%type,
1431: p_addl_tax_exem_flag in per_contact_relationships.cont_information3%type,

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

1424: --
1425: --
1426: function is_exempted_dependent(
1427: p_cont_type in per_contact_relationships.contact_type%type,
1428: p_kr_cont_typ in per_contact_relationships.cont_information11%type, -- Bug 7661820
1429: p_ni in per_people_f.national_identifier%type,
1430: p_itax_dpnt_flag in per_contact_relationships.cont_information2%type,
1431: p_addl_tax_exem_flag in per_contact_relationships.cont_information3%type,
1432: p_addl_disabled_flag in per_contact_relationships.cont_information4%type,

Line 1430: p_itax_dpnt_flag in per_contact_relationships.cont_information2%type,

1426: function is_exempted_dependent(
1427: p_cont_type in per_contact_relationships.contact_type%type,
1428: p_kr_cont_typ in per_contact_relationships.cont_information11%type, -- Bug 7661820
1429: p_ni in per_people_f.national_identifier%type,
1430: p_itax_dpnt_flag in per_contact_relationships.cont_information2%type,
1431: p_addl_tax_exem_flag in per_contact_relationships.cont_information3%type,
1432: p_addl_disabled_flag in per_contact_relationships.cont_information4%type,
1433: p_addl_exem_flag_child in per_contact_relationships.cont_information7%type,
1434: p_age_ckh_exp_flag in per_contact_relationships.cont_information8%type,

Line 1431: p_addl_tax_exem_flag in per_contact_relationships.cont_information3%type,

1427: p_cont_type in per_contact_relationships.contact_type%type,
1428: p_kr_cont_typ in per_contact_relationships.cont_information11%type, -- Bug 7661820
1429: p_ni in per_people_f.national_identifier%type,
1430: p_itax_dpnt_flag in per_contact_relationships.cont_information2%type,
1431: p_addl_tax_exem_flag in per_contact_relationships.cont_information3%type,
1432: p_addl_disabled_flag in per_contact_relationships.cont_information4%type,
1433: p_addl_exem_flag_child in per_contact_relationships.cont_information7%type,
1434: p_age_ckh_exp_flag in per_contact_relationships.cont_information8%type,
1435: p_eff_date in pay_payroll_actions.effective_date%type,

Line 1432: p_addl_disabled_flag in per_contact_relationships.cont_information4%type,

1428: p_kr_cont_typ in per_contact_relationships.cont_information11%type, -- Bug 7661820
1429: p_ni in per_people_f.national_identifier%type,
1430: p_itax_dpnt_flag in per_contact_relationships.cont_information2%type,
1431: p_addl_tax_exem_flag in per_contact_relationships.cont_information3%type,
1432: p_addl_disabled_flag in per_contact_relationships.cont_information4%type,
1433: p_addl_exem_flag_child in per_contact_relationships.cont_information7%type,
1434: p_age_ckh_exp_flag in per_contact_relationships.cont_information8%type,
1435: p_eff_date in pay_payroll_actions.effective_date%type,
1436: p_ins_prem_exem_incl_flag in per_contact_relationships.cont_information10%type, -- Bug 4931542

Line 1433: p_addl_exem_flag_child in per_contact_relationships.cont_information7%type,

1429: p_ni in per_people_f.national_identifier%type,
1430: p_itax_dpnt_flag in per_contact_relationships.cont_information2%type,
1431: p_addl_tax_exem_flag in per_contact_relationships.cont_information3%type,
1432: p_addl_disabled_flag in per_contact_relationships.cont_information4%type,
1433: p_addl_exem_flag_child in per_contact_relationships.cont_information7%type,
1434: p_age_ckh_exp_flag in per_contact_relationships.cont_information8%type,
1435: p_eff_date in pay_payroll_actions.effective_date%type,
1436: p_ins_prem_exem_incl_flag in per_contact_relationships.cont_information10%type, -- Bug 4931542
1437: p_med_exp_exem_incl_flag in per_contact_relationships.cont_information12%type, -- Bug 4931542

Line 1434: p_age_ckh_exp_flag in per_contact_relationships.cont_information8%type,

1430: p_itax_dpnt_flag in per_contact_relationships.cont_information2%type,
1431: p_addl_tax_exem_flag in per_contact_relationships.cont_information3%type,
1432: p_addl_disabled_flag in per_contact_relationships.cont_information4%type,
1433: p_addl_exem_flag_child in per_contact_relationships.cont_information7%type,
1434: p_age_ckh_exp_flag in per_contact_relationships.cont_information8%type,
1435: p_eff_date in pay_payroll_actions.effective_date%type,
1436: p_ins_prem_exem_incl_flag in per_contact_relationships.cont_information10%type, -- Bug 4931542
1437: p_med_exp_exem_incl_flag in per_contact_relationships.cont_information12%type, -- Bug 4931542
1438: p_edu_exp_exem_incl_flag in per_contact_relationships.cont_information13%type, -- Bug 4931542

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

1432: p_addl_disabled_flag in per_contact_relationships.cont_information4%type,
1433: p_addl_exem_flag_child in per_contact_relationships.cont_information7%type,
1434: p_age_ckh_exp_flag in per_contact_relationships.cont_information8%type,
1435: p_eff_date in pay_payroll_actions.effective_date%type,
1436: p_ins_prem_exem_incl_flag in per_contact_relationships.cont_information10%type, -- Bug 4931542
1437: p_med_exp_exem_incl_flag in per_contact_relationships.cont_information12%type, -- Bug 4931542
1438: p_edu_exp_exem_incl_flag in per_contact_relationships.cont_information13%type, -- Bug 4931542
1439: p_card_exp_exem_incl_flag in per_contact_relationships.cont_information14%type, -- Bug 4931542
1440: p_contact_extra_info_id in per_contact_extra_info_f.contact_extra_info_id%type -- Bug 5879106

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

1433: p_addl_exem_flag_child in per_contact_relationships.cont_information7%type,
1434: p_age_ckh_exp_flag in per_contact_relationships.cont_information8%type,
1435: p_eff_date in pay_payroll_actions.effective_date%type,
1436: p_ins_prem_exem_incl_flag in per_contact_relationships.cont_information10%type, -- Bug 4931542
1437: p_med_exp_exem_incl_flag in per_contact_relationships.cont_information12%type, -- Bug 4931542
1438: p_edu_exp_exem_incl_flag in per_contact_relationships.cont_information13%type, -- Bug 4931542
1439: p_card_exp_exem_incl_flag in per_contact_relationships.cont_information14%type, -- Bug 4931542
1440: p_contact_extra_info_id in per_contact_extra_info_f.contact_extra_info_id%type -- Bug 5879106
1441: ) return varchar2 is

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

1434: p_age_ckh_exp_flag in per_contact_relationships.cont_information8%type,
1435: p_eff_date in pay_payroll_actions.effective_date%type,
1436: p_ins_prem_exem_incl_flag in per_contact_relationships.cont_information10%type, -- Bug 4931542
1437: p_med_exp_exem_incl_flag in per_contact_relationships.cont_information12%type, -- Bug 4931542
1438: p_edu_exp_exem_incl_flag in per_contact_relationships.cont_information13%type, -- Bug 4931542
1439: p_card_exp_exem_incl_flag in per_contact_relationships.cont_information14%type, -- Bug 4931542
1440: p_contact_extra_info_id in per_contact_extra_info_f.contact_extra_info_id%type -- Bug 5879106
1441: ) return varchar2 is
1442: --

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

1435: p_eff_date in pay_payroll_actions.effective_date%type,
1436: p_ins_prem_exem_incl_flag in per_contact_relationships.cont_information10%type, -- Bug 4931542
1437: p_med_exp_exem_incl_flag in per_contact_relationships.cont_information12%type, -- Bug 4931542
1438: p_edu_exp_exem_incl_flag in per_contact_relationships.cont_information13%type, -- Bug 4931542
1439: p_card_exp_exem_incl_flag in per_contact_relationships.cont_information14%type, -- Bug 4931542
1440: p_contact_extra_info_id in per_contact_extra_info_f.contact_extra_info_id%type -- Bug 5879106
1441: ) return varchar2 is
1442: --
1443: cursor csr_contact_extra_info(p_cont_extra_info_id number) is

Line 1597: p_cont_type in per_contact_relationships.contact_type%type,

1593: -- Return: 'Y' if the dependent is eligible
1594: -- for basic exemption, 'N' otherwise.
1595: --
1596: function dpnt_eligible_for_basic_exem(
1597: p_cont_type in per_contact_relationships.contact_type%type,
1598: p_kr_cont_typ in per_contact_relationships.cont_information11%type, -- Bug 7661820
1599: p_ni in per_people_f.national_identifier%type,
1600: p_itax_dpnt_flag in per_contact_relationships.cont_information2%type,
1601: p_addl_disabled_flag in per_contact_relationships.cont_information4%type,

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

1594: -- for basic exemption, 'N' otherwise.
1595: --
1596: function dpnt_eligible_for_basic_exem(
1597: p_cont_type in per_contact_relationships.contact_type%type,
1598: p_kr_cont_typ in per_contact_relationships.cont_information11%type, -- Bug 7661820
1599: p_ni in per_people_f.national_identifier%type,
1600: p_itax_dpnt_flag in per_contact_relationships.cont_information2%type,
1601: p_addl_disabled_flag in per_contact_relationships.cont_information4%type,
1602: p_age_ckh_exp_flag in per_contact_relationships.cont_information8%type,

Line 1600: p_itax_dpnt_flag in per_contact_relationships.cont_information2%type,

1596: function dpnt_eligible_for_basic_exem(
1597: p_cont_type in per_contact_relationships.contact_type%type,
1598: p_kr_cont_typ in per_contact_relationships.cont_information11%type, -- Bug 7661820
1599: p_ni in per_people_f.national_identifier%type,
1600: p_itax_dpnt_flag in per_contact_relationships.cont_information2%type,
1601: p_addl_disabled_flag in per_contact_relationships.cont_information4%type,
1602: p_age_ckh_exp_flag in per_contact_relationships.cont_information8%type,
1603: p_eff_date in pay_payroll_actions.effective_date%type
1604: ) return varchar2

Line 1601: p_addl_disabled_flag in per_contact_relationships.cont_information4%type,

1597: p_cont_type in per_contact_relationships.contact_type%type,
1598: p_kr_cont_typ in per_contact_relationships.cont_information11%type, -- Bug 7661820
1599: p_ni in per_people_f.national_identifier%type,
1600: p_itax_dpnt_flag in per_contact_relationships.cont_information2%type,
1601: p_addl_disabled_flag in per_contact_relationships.cont_information4%type,
1602: p_age_ckh_exp_flag in per_contact_relationships.cont_information8%type,
1603: p_eff_date in pay_payroll_actions.effective_date%type
1604: ) return varchar2
1605: is

Line 1602: p_age_ckh_exp_flag in per_contact_relationships.cont_information8%type,

1598: p_kr_cont_typ in per_contact_relationships.cont_information11%type, -- Bug 7661820
1599: p_ni in per_people_f.national_identifier%type,
1600: p_itax_dpnt_flag in per_contact_relationships.cont_information2%type,
1601: p_addl_disabled_flag in per_contact_relationships.cont_information4%type,
1602: p_age_ckh_exp_flag in per_contact_relationships.cont_information8%type,
1603: p_eff_date in pay_payroll_actions.effective_date%type
1604: ) return varchar2
1605: is
1606: begin

Line 1736: per_contact_relationships ctr

1732: ctr.cont_information2 itax_law,
1733: nvl(ctr.cont_information11, '0') kr_cont_type,
1734: decode(ctr.contact_type, 'P', '1', 'S', '3', 'A', '4', 'C', '4', 'R', '4', 'T', '4', '6') cont_type
1735: from
1736: per_contact_relationships ctr
1737: where
1738: ctr.person_id = p_person_id
1739: and ctr.cont_information_category = 'KR'
1740: and ctr.cont_information1 = 'Y'

Line 1856: per_contact_relationships ctr

1852: ctr.cont_information2 itax_law,
1853: nvl(ctr.cont_information11, '0') kr_cont_type,
1854: decode(ctr.contact_type, 'P', '1', 'S', '3', 'A', '4', 'C', '4', 'R', '4', 'T', '4', '6') cont_type
1855: from
1856: per_contact_relationships ctr
1857: where
1858: ctr.person_id = p_person_id
1859: and ctr.cont_information_category = 'KR'
1860: and ctr.cont_information1 = 'Y'