APPS.BEN_PLAN_DESIGN_ELPRO_MODULE dependencies on HR_LOCATIONS

Line 3066: from hr_locations loc

3062: -- pabodla : mapping data
3063: --
3064: cursor c_get_mapping_name15(p_id in number,p_date date) is
3065: select loc.location_code dsp_location_code
3066: from hr_locations loc
3067: where loc.location_id = p_id
3068: and p_date <= nvl( loc.inactive_date, p_date);
3069:
3070: cursor c_location_inactive_date(c_location_id number) is

Line 3072: from hr_locations

3068: and p_date <= nvl( loc.inactive_date, p_date);
3069:
3070: cursor c_location_inactive_date(c_location_id number) is
3071: select inactive_date
3072: from hr_locations
3073: where location_id = c_location_id;
3074:
3075: l_location_inactive_date hr_locations.inactive_date%type;
3076: ---------------------------------------------------------------

Line 3075: l_location_inactive_date hr_locations.inactive_date%type;

3071: select inactive_date
3072: from hr_locations
3073: where location_id = c_location_id;
3074:
3075: l_location_inactive_date hr_locations.inactive_date%type;
3076: ---------------------------------------------------------------
3077: -- END OF BEN_ELIG_WK_LOC_PRTE_F ----------------------
3078: ---------------------------------------------------------------
3079: ---------------------------------------------------------------