APPS.BEN_DERIVE_FACTORS dependencies on PER_CONTACT_RELATIONSHIPS

Line 174: using per_contact_relationships

170: 28-APR-2003 rpgupta 115.69 Bug 2924077
171: Added a check on effective dates while
172: picking up details of the person's spouse
173: The same chk has been added to all cursors
174: using per_contact_relationships
175: 14-JUL-2003 glingapp 115.70 added outer join on per_periods_of_service in
176: cursor c_person of determine_los
177: 24-Sep-2003 ikasire 115.71 Bug 3151737 - made the join to pay_all_payrolls_f
178: as outer join and added the effective date

Line 1684: from per_contact_relationships ctr,

1680: --
1681:
1682: cursor c_per_spouse(l_person_id number) is
1683: select per.date_of_birth
1684: from per_contact_relationships ctr,
1685: per_all_people_f per
1686: where ctr.person_id = l_person_id
1687: and per.person_id = ctr.contact_person_id
1688: and per.business_group_id = p_business_group_id

Line 1701: from per_contact_relationships ctr,

1697: and nvl(ctr.date_end, hr_api.g_eot);
1698: --
1699: cursor c_per_depen_first(l_person_id number) is
1700: select per.date_of_birth
1701: from per_contact_relationships ctr,
1702: per_all_people_f per
1703: where ctr.person_id = l_person_id
1704: and per.person_id = ctr.contact_person_id
1705: and per.business_group_id = p_business_group_id

Line 1719: from per_contact_relationships ctr,

1715:
1716: --
1717: cursor c_per_child_first(l_person_id number) is
1718: select per.date_of_birth
1719: from per_contact_relationships ctr,
1720: per_all_people_f per
1721: where ctr.person_id = l_person_id
1722: and per.person_id = ctr.contact_person_id
1723: and per.business_group_id = p_business_group_id

Line 1737: from per_contact_relationships ctr,

1733:
1734: --
1735: cursor c_per_depen_oldest(l_person_id number) is
1736: select min(per.date_of_birth)
1737: from per_contact_relationships ctr,
1738: per_all_people_f per
1739: where ctr.person_id = l_person_id
1740: and per.person_id = ctr.contact_person_id
1741: and per.business_group_id = p_business_group_id

Line 1755: from per_contact_relationships ctr,

1751: order by per.date_of_birth;
1752: --
1753: cursor c_per_child_oldest(l_person_id number) is
1754: select min(per.date_of_birth)
1755: from per_contact_relationships ctr,
1756: per_all_people_f per
1757: where ctr.person_id = l_person_id
1758: and per.person_id = ctr.contact_person_id
1759: and per.business_group_id = p_business_group_id

Line 1773: from per_contact_relationships ctr,

1769: order by per.date_of_birth;
1770: --
1771: cursor c_per_depen_young(l_person_id number) is
1772: select max(per.date_of_birth)
1773: from per_contact_relationships ctr,
1774: per_all_people_f per
1775: where ctr.person_id = l_person_id
1776: and per.person_id = ctr.contact_person_id
1777: and per.business_group_id = p_business_group_id

Line 1791: from per_contact_relationships ctr,

1787: order by per.date_of_birth;
1788: --
1789: cursor c_per_child_young(l_person_id number) is
1790: select max(per.date_of_birth)
1791: from per_contact_relationships ctr,
1792: per_all_people_f per
1793: where ctr.person_id = l_person_id
1794: and per.business_group_id = p_business_group_id
1795: and per.person_id = ctr.contact_person_id