APPS.PER_INC_BUS dependencies on HR_GENERAL

Line 2130: and nvl(hou.date_to,hr_general.end_of_time)

2126: where hou.organization_id = p_notified_rep_org_id
2127: and hou.internal_external_flag = 'EXT'
2128: and hou.business_group_id = p_business_group_id
2129: and nvl(p_notified_rep_date, hou.date_from) between hou.date_from
2130: and nvl(hou.date_to,hr_general.end_of_time)
2131: and p_notified_rep_org_id in (select hoi.organization_id
2132: from hr_organization_information hoi
2133: where hoi.org_information_context = 'CLASS'
2134: and hoi.org_information1 = 'REPBODY'

Line 2150: between rol.start_date and nvl(rol.end_date,hr_general.end_of_time);

2146: and rol.organization_id = p_notified_rep_org_id
2147: and nvl(p_notified_rep_date, paf.effective_start_date)
2148: between paf.effective_start_date and paf.effective_end_date
2149: and nvl(p_notified_rep_date, rol.start_date)
2150: between rol.start_date and nvl(rol.end_date,hr_general.end_of_time);
2151: --
2152: --
2153: l_proc varchar2(72) := g_package||'chk_notified_rep_org_date';
2154: l_dummy varchar2(1);