DBA Data[Home] [Help]

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 3078: from hr_locations_all

3074: ;
3075:
3076: cursor c_loc(p_loc_id number) is
3077: select location_code
3078: from hr_locations_all
3079: where location_id = p_loc_id
3080: ;
3081:
3082: cursor c_payr(p_rate_id number) is