APPS.BEN_DERIVE_FACTORS dependencies on HR_API

Line 1814: between nvl(ctr.date_start, hr_api.g_sot)

1810: between per.effective_start_date
1811: and per.effective_end_date
1812: /* bug 2924077 */
1813: and l_effective_date
1814: between nvl(ctr.date_start, hr_api.g_sot)
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

Line 1815: and nvl(ctr.date_end, hr_api.g_eot);

1811: and per.effective_end_date
1812: /* bug 2924077 */
1813: and l_effective_date
1814: between nvl(ctr.date_start, hr_api.g_sot)
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,

Line 1831: between nvl(ctr.date_start, hr_api.g_sot)

1827: between per.effective_start_date
1828: and per.effective_end_date
1829: /* bug 2924077 */
1830: and l_effective_date
1831: between nvl(ctr.date_start, hr_api.g_sot)
1832: and nvl(ctr.date_end, hr_api.g_eot);
1833:
1834: --
1835: cursor c_per_child_first(l_person_id number) is

Line 1832: and nvl(ctr.date_end, hr_api.g_eot);

1828: and per.effective_end_date
1829: /* bug 2924077 */
1830: and l_effective_date
1831: between nvl(ctr.date_start, hr_api.g_sot)
1832: and nvl(ctr.date_end, hr_api.g_eot);
1833:
1834: --
1835: cursor c_per_child_first(l_person_id number) is
1836: select per.date_of_birth

Line 1849: between nvl(ctr.date_start, hr_api.g_sot)

1845: between per.effective_start_date
1846: and per.effective_end_date
1847: /* bug 2924077 */
1848: and l_effective_date
1849: between nvl(ctr.date_start, hr_api.g_sot)
1850: and nvl(ctr.date_end, hr_api.g_eot);
1851:
1852: --
1853: cursor c_per_depen_oldest(l_person_id number) is

Line 1850: and nvl(ctr.date_end, hr_api.g_eot);

1846: and per.effective_end_date
1847: /* bug 2924077 */
1848: and l_effective_date
1849: between nvl(ctr.date_start, hr_api.g_sot)
1850: and nvl(ctr.date_end, hr_api.g_eot);
1851:
1852: --
1853: cursor c_per_depen_oldest(l_person_id number) is
1854: select min(per.date_of_birth)

Line 1867: between nvl(ctr.date_start, hr_api.g_sot)

1863: between per.effective_start_date
1864: and per.effective_end_date
1865: /* bug 2924077 */
1866: and l_effective_date
1867: between nvl(ctr.date_start, hr_api.g_sot)
1868: and nvl(ctr.date_end, hr_api.g_eot)
1869: order by per.date_of_birth;
1870: --
1871: cursor c_per_child_oldest(l_person_id number) is

Line 1868: and nvl(ctr.date_end, hr_api.g_eot)

1864: and per.effective_end_date
1865: /* bug 2924077 */
1866: and l_effective_date
1867: between nvl(ctr.date_start, hr_api.g_sot)
1868: and nvl(ctr.date_end, hr_api.g_eot)
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)

Line 1885: between nvl(ctr.date_start, hr_api.g_sot)

1881: between per.effective_start_date
1882: and per.effective_end_date
1883: /* bug 2924077 */
1884: and l_effective_date
1885: between nvl(ctr.date_start, hr_api.g_sot)
1886: and nvl(ctr.date_end, hr_api.g_eot)
1887: order by per.date_of_birth;
1888: --
1889: cursor c_per_depen_young(l_person_id number) is

Line 1886: and nvl(ctr.date_end, hr_api.g_eot)

1882: and per.effective_end_date
1883: /* bug 2924077 */
1884: and l_effective_date
1885: between nvl(ctr.date_start, hr_api.g_sot)
1886: and nvl(ctr.date_end, hr_api.g_eot)
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)

Line 1903: between nvl(ctr.date_start, hr_api.g_sot)

1899: between per.effective_start_date
1900: and per.effective_end_date
1901: /* bug 2924077 */
1902: and l_effective_date
1903: between nvl(ctr.date_start, hr_api.g_sot)
1904: and nvl(ctr.date_end, hr_api.g_eot)
1905: order by per.date_of_birth;
1906: --
1907: cursor c_per_child_young(l_person_id number) is

Line 1904: and nvl(ctr.date_end, hr_api.g_eot)

1900: and per.effective_end_date
1901: /* bug 2924077 */
1902: and l_effective_date
1903: between nvl(ctr.date_start, hr_api.g_sot)
1904: and nvl(ctr.date_end, hr_api.g_eot)
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)

Line 1921: between nvl(ctr.date_start, hr_api.g_sot)

1917: between per.effective_start_date
1918: and per.effective_end_date
1919: /* bug 2924077 */
1920: and l_effective_date
1921: between nvl(ctr.date_start, hr_api.g_sot)
1922: and nvl(ctr.date_end, hr_api.g_eot)
1923: order by per.date_of_birth;
1924: --
1925: l_per c_per%rowtype;

Line 1922: and nvl(ctr.date_end, hr_api.g_eot)

1918: and per.effective_end_date
1919: /* bug 2924077 */
1920: and l_effective_date
1921: between nvl(ctr.date_start, hr_api.g_sot)
1922: and nvl(ctr.date_end, hr_api.g_eot)
1923: order by per.date_of_birth;
1924: --
1925: l_per c_per%rowtype;
1926: --