APPS.HR_UTIL_MISC_WEB dependencies on HR_API

Line 725: between nvl(start_date_active,hr_api.g_sot)

721: from hr_lookups
722: where lookup_type = p_lookup_type
723: and enabled_flag = 'Y'
724: and nvl(p_effective_date, trunc(sysdate))
725: between nvl(start_date_active,hr_api.g_sot)
726: and nvl(end_date_active,hr_api.g_eot)
727: order by lookup_code;
728: --
729: l_lookup_code_meaning_row get_lookup_code_meaning%rowtype;

Line 726: and nvl(end_date_active,hr_api.g_eot)

722: where lookup_type = p_lookup_type
723: and enabled_flag = 'Y'
724: and nvl(p_effective_date, trunc(sysdate))
725: between nvl(start_date_active,hr_api.g_sot)
726: and nvl(end_date_active,hr_api.g_eot)
727: order by lookup_code;
728: --
729: l_lookup_code_meaning_row get_lookup_code_meaning%rowtype;
730: l_lookup_code_meaning_rec_tbl hr_util_misc_web.g_lookup_values_tab_type

Line 1867: and nvl(fd.end_date_active, hr_api.g_eot)

1863: and fatd.pk1_value = p_pk1_value
1864: and fatd.document_id = fd.document_id
1865: and p_effective_date
1866: between nvl(fd.start_date_active, trunc(sysdate))
1867: and nvl(fd.end_date_active, hr_api.g_eot)
1868: order by fd.last_update_date desc,
1869: fd.document_id desc; -- retrieve the one updated the last
1870:
1871: cursor csr_documents_tl (csr_p_document_id in number) is