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_EXT_PERSON dependencies on HR_LOCATIONS_ALL

Line 930: l_location_id Hr_locations_all.location_id%Type ;

926: select location_id
927: from hr_all_organization_units
928: where organization_id = p_org_id ;
929:
930: l_location_id Hr_locations_all.location_id%Type ;
931:
932: cursor c_loc_info (p_location_id number) is
933: select l.address_line_1,
934: l.address_line_2,

Line 943: from hr_locations_all l

939: l.region_1,
940: l.region_2,
941: l.region_3,
942: l.Telephone_number_1
943: from hr_locations_all l
944: where l.location_id = p_location_id;
945:
946: --
947: begin

Line 1037: from hr_locations_all l

1033: g_alc_flex_07,
1034: g_alc_flex_08,
1035: g_alc_flex_09,
1036: g_alc_flex_10
1037: from hr_locations_all l
1038: where l.location_id = p_location_id;
1039:
1040:
1041: if g_debug then

Line 3044: from hr_locations_all

3040: ;
3041:
3042: cursor c_loc(p_loc_id number) is
3043: select location_code
3044: from hr_locations_all
3045: where location_id = p_loc_id
3046: ;
3047:
3048: cursor c_payr(p_rate_id number) is