[Home] [Help]
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
1798: --
1799:
1800: cursor c_per_spouse(l_person_id number) is
1801: select per.date_of_birth
1802: from per_contact_relationships ctr,
1803: per_all_people_f per
1804: where ctr.person_id = l_person_id
1805: and per.person_id = ctr.contact_person_id
1806: and per.business_group_id = p_business_group_id
1815: and nvl(ctr.date_end, hr_api.g_eot);
1816: --
1817: cursor c_per_depen_first(l_person_id number) is
1818: select per.date_of_birth
1819: from per_contact_relationships ctr,
1820: per_all_people_f per
1821: where ctr.person_id = l_person_id
1822: and per.person_id = ctr.contact_person_id
1823: and per.business_group_id = p_business_group_id
1833:
1834: --
1835: cursor c_per_child_first(l_person_id number) is
1836: select per.date_of_birth
1837: from per_contact_relationships ctr,
1838: per_all_people_f per
1839: where ctr.person_id = l_person_id
1840: and per.person_id = ctr.contact_person_id
1841: and per.business_group_id = p_business_group_id
1851:
1852: --
1853: cursor c_per_depen_oldest(l_person_id number) is
1854: select min(per.date_of_birth)
1855: from per_contact_relationships ctr,
1856: per_all_people_f per
1857: where ctr.person_id = l_person_id
1858: and per.person_id = ctr.contact_person_id
1859: and per.business_group_id = p_business_group_id
1869: order by per.date_of_birth;
1870: --
1871: cursor c_per_child_oldest(l_person_id number) is
1872: select min(per.date_of_birth)
1873: from per_contact_relationships ctr,
1874: per_all_people_f per
1875: where ctr.person_id = l_person_id
1876: and per.person_id = ctr.contact_person_id
1877: and per.business_group_id = p_business_group_id
1887: order by per.date_of_birth;
1888: --
1889: cursor c_per_depen_young(l_person_id number) is
1890: select max(per.date_of_birth)
1891: from per_contact_relationships ctr,
1892: per_all_people_f per
1893: where ctr.person_id = l_person_id
1894: and per.person_id = ctr.contact_person_id
1895: and per.business_group_id = p_business_group_id
1905: order by per.date_of_birth;
1906: --
1907: cursor c_per_child_young(l_person_id number) is
1908: select max(per.date_of_birth)
1909: from per_contact_relationships ctr,
1910: per_all_people_f per
1911: where ctr.person_id = l_person_id
1912: and per.business_group_id = p_business_group_id
1913: and per.person_id = ctr.contact_person_id