APPS.PSP_GENERAL dependencies on HR_ORGANIZATION_UNITS

Line 242: FROM HR_ORGANIZATION_UNITS

238: BEGIN
239: BEGIN
240: SELECT 'x'
241: INTO l_dummy
242: FROM HR_ORGANIZATION_UNITS
243: WHERE organization_id = organization_id1 AND
244: ROWNUM = 1;
245: RETURN(0);
246: EXCEPTION

Line 2342: from hr_organization_units hou

2338: FUNCTION chk_org_validity(p_org_id IN NUMBER, p_effective_date IN DATE) RETURN VARCHAR2 IS
2339:
2340: cursor eff_dates is
2341: select max(nvl(hou.date_to,to_date('31/12/4712','DD/MM/RRRR'))),min(hou.date_from)
2342: from hr_organization_units hou
2343: WHERE hou.organization_id = p_org_id;
2344:
2345: max_eff_end_date date;
2346: min_eff_start_date date;

Line 2371: from hr_organization_units hou

2367: FUNCTION get_org_name_er(p_org_id IN NUMBER, p_effective_date IN DATE) RETURN VARCHAR2 IS
2368:
2369: cursor eff_dates is
2370: select max(nvl(hou.date_to,to_date('31/12/4712','DD/MM/RRRR'))),min(hou.date_from)
2371: from hr_organization_units hou
2372: WHERE hou.organization_id = p_org_id;
2373:
2374: cursor c1(p_calculated_date date)
2375: is

Line 2377: from hr_organization_units hou

2373:
2374: cursor c1(p_calculated_date date)
2375: is
2376: select name
2377: from hr_organization_units hou
2378: WHERE hou.organization_id = p_org_id
2379: and p_calculated_date between hou.date_from and trunc(nvl(hou.date_to,to_date('31/12/4712','DD/MM/RRRR')));
2380:
2381: l_organization_name varchar2(240);