eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_PD_RATE_AND_CVG_MODULE dependencies on HR_ALL_ORGANIZATION_UNITS

Line 6366: from hr_all_organization_units

6362: and hoi.org_information_context || '' ='CLASS' ;
6363:
6364: cursor c_organization_start_date(c_organization_id number) is
6365: select date_from
6366: from hr_all_organization_units
6367: where organization_id = c_organization_id;
6368:
6369: l_organization_start_date hr_all_organization_units.date_from%type;
6370: ---------------------------------------------------------------

Line 6369: l_organization_start_date hr_all_organization_units.date_from%type;

6365: select date_from
6366: from hr_all_organization_units
6367: where organization_id = c_organization_id;
6368:
6369: l_organization_start_date hr_all_organization_units.date_from%type;
6370: ---------------------------------------------------------------
6371: -- END OF BEN_LGL_ENTY_RT_F ----------------------
6372: ---------------------------------------------------------------
6373: ---------------------------------------------------------------

Line 6555: from hr_all_organization_units_vl

6551: -- pabodla : mapping data - Bug 2716749
6552: --
6553: cursor c_get_mapping_name9(p_id in number,p_date in date) is
6554: select name
6555: from hr_all_organization_units_vl
6556: where business_group_id = business_group_id
6557: and organization_id = p_id
6558: and internal_external_flag = 'INT'
6559: and p_date between nvl(date_from, p_date)