DBA Data[Home] [Help]

APPS.BEN_PD_RATE_AND_CVG_MODULE dependencies on HR_LOCATIONS

Line 7146: from hr_locations loc

7142: -- pabodla : mapping data
7143: --
7144: cursor c_get_mapping_name10(p_id in number,p_date in date) is
7145: select loc.location_code dsp_location_code
7146: from hr_locations loc
7147: where loc.location_id = p_id
7148: and p_date <= nvl( loc.inactive_date, p_date);
7149:
7150: cursor c_location_inactive_date(c_location_id number) is

Line 7152: from hr_locations

7148: and p_date <= nvl( loc.inactive_date, p_date);
7149:
7150: cursor c_location_inactive_date(c_location_id number) is
7151: select inactive_date
7152: from hr_locations
7153: where location_id = c_location_id;
7154:
7155: l_location_inactive_date hr_locations.inactive_date%type;
7156: ---------------------------------------------------------------

Line 7155: l_location_inactive_date hr_locations.inactive_date%type;

7151: select inactive_date
7152: from hr_locations
7153: where location_id = c_location_id;
7154:
7155: l_location_inactive_date hr_locations.inactive_date%type;
7156: ---------------------------------------------------------------
7157: -- END OF BEN_WK_LOC_RT_F ----------------------
7158: ---------------------------------------------------------------
7159: ---------------------------------------------------------------