3171: -- pabodla : mapping data
3172: --
3173: cursor c_get_mapping_name8(p_id in number) is
3174: select name
3175: from per_positions
3176: where business_group_id = p_business_group_id
3177: and position_id = p_id;
3178:
3179: cursor c_position_start_date(c_position_id number) is
3177: and position_id = p_id;
3178:
3179: cursor c_position_start_date(c_position_id number) is
3180: select date_effective
3181: from per_positions
3182: where position_id = c_position_id;
3183:
3184: l_position_start_date per_positions.date_effective%type;
3185: ---------------------------------------------------------------
3180: select date_effective
3181: from per_positions
3182: where position_id = c_position_id;
3183:
3184: l_position_start_date per_positions.date_effective%type;
3185: ---------------------------------------------------------------
3186: -- END OF BEN_ELIG_PSTN_PRTE_F ----------------------
3187: ---------------------------------------------------------------
3188: ---------------------------------------------------------------