APPS.BEN_DERIVE_FACTORS dependencies on HR_API

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

1692: between per.effective_start_date
1693: and per.effective_end_date
1694: /* bug 2924077 */
1695: and l_effective_date
1696: between nvl(ctr.date_start, hr_api.g_sot)
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

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

1693: and per.effective_end_date
1694: /* bug 2924077 */
1695: and l_effective_date
1696: between nvl(ctr.date_start, hr_api.g_sot)
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,

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

1709: between per.effective_start_date
1710: and per.effective_end_date
1711: /* bug 2924077 */
1712: and l_effective_date
1713: between nvl(ctr.date_start, hr_api.g_sot)
1714: and nvl(ctr.date_end, hr_api.g_eot);
1715:
1716: --
1717: cursor c_per_child_first(l_person_id number) is

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

1710: and per.effective_end_date
1711: /* bug 2924077 */
1712: and l_effective_date
1713: between nvl(ctr.date_start, hr_api.g_sot)
1714: and nvl(ctr.date_end, hr_api.g_eot);
1715:
1716: --
1717: cursor c_per_child_first(l_person_id number) is
1718: select per.date_of_birth

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

1727: between per.effective_start_date
1728: and per.effective_end_date
1729: /* bug 2924077 */
1730: and l_effective_date
1731: between nvl(ctr.date_start, hr_api.g_sot)
1732: and nvl(ctr.date_end, hr_api.g_eot);
1733:
1734: --
1735: cursor c_per_depen_oldest(l_person_id number) is

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

1728: and per.effective_end_date
1729: /* bug 2924077 */
1730: and l_effective_date
1731: between nvl(ctr.date_start, hr_api.g_sot)
1732: and nvl(ctr.date_end, hr_api.g_eot);
1733:
1734: --
1735: cursor c_per_depen_oldest(l_person_id number) is
1736: select min(per.date_of_birth)

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

1745: between per.effective_start_date
1746: and per.effective_end_date
1747: /* bug 2924077 */
1748: and l_effective_date
1749: between nvl(ctr.date_start, hr_api.g_sot)
1750: and nvl(ctr.date_end, hr_api.g_eot)
1751: order by per.date_of_birth;
1752: --
1753: cursor c_per_child_oldest(l_person_id number) is

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

1746: and per.effective_end_date
1747: /* bug 2924077 */
1748: and l_effective_date
1749: between nvl(ctr.date_start, hr_api.g_sot)
1750: and nvl(ctr.date_end, hr_api.g_eot)
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)

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

1763: between per.effective_start_date
1764: and per.effective_end_date
1765: /* bug 2924077 */
1766: and l_effective_date
1767: between nvl(ctr.date_start, hr_api.g_sot)
1768: and nvl(ctr.date_end, hr_api.g_eot)
1769: order by per.date_of_birth;
1770: --
1771: cursor c_per_depen_young(l_person_id number) is

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

1764: and per.effective_end_date
1765: /* bug 2924077 */
1766: and l_effective_date
1767: between nvl(ctr.date_start, hr_api.g_sot)
1768: and nvl(ctr.date_end, hr_api.g_eot)
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)

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

1781: between per.effective_start_date
1782: and per.effective_end_date
1783: /* bug 2924077 */
1784: and l_effective_date
1785: between nvl(ctr.date_start, hr_api.g_sot)
1786: and nvl(ctr.date_end, hr_api.g_eot)
1787: order by per.date_of_birth;
1788: --
1789: cursor c_per_child_young(l_person_id number) is

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

1782: and per.effective_end_date
1783: /* bug 2924077 */
1784: and l_effective_date
1785: between nvl(ctr.date_start, hr_api.g_sot)
1786: and nvl(ctr.date_end, hr_api.g_eot)
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)

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

1799: between per.effective_start_date
1800: and per.effective_end_date
1801: /* bug 2924077 */
1802: and l_effective_date
1803: between nvl(ctr.date_start, hr_api.g_sot)
1804: and nvl(ctr.date_end, hr_api.g_eot)
1805: order by per.date_of_birth;
1806: --
1807: l_per c_per%rowtype;

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

1800: and per.effective_end_date
1801: /* bug 2924077 */
1802: and l_effective_date
1803: between nvl(ctr.date_start, hr_api.g_sot)
1804: and nvl(ctr.date_end, hr_api.g_eot)
1805: order by per.date_of_birth;
1806: --
1807: l_per c_per%rowtype;
1808: --