837: --
838: -- declare local variables
839: --
840: l_last_eligible_date DATE := p_qualifying_date - 1;
841: l_user_id NUMBER := FND_PROFILE.Value('USER_ID');
842: l_login_id NUMBER := FND_PROFILE.Value('LOGIN_ID');
843: --
844: BEGIN
845: --
838: -- declare local variables
839: --
840: l_last_eligible_date DATE := p_qualifying_date - 1;
841: l_user_id NUMBER := FND_PROFILE.Value('USER_ID');
842: l_login_id NUMBER := FND_PROFILE.Value('LOGIN_ID');
843: --
844: BEGIN
845: --
846: hr_utility.set_location('hrwseci.hr_cobra_ins_benefits', 0);
1039: --
1040: -- declare local variables
1041: --
1042: l_count NUMBER(2) := 0;
1043: l_user_id NUMBER := FND_PROFILE.Value('USER_ID');
1044: l_login_id NUMBER := FND_PROFILE.Value('LOGIN_ID');
1045: l_scp_id NUMBER;
1046: --
1047: -- declare cursor for scp_id
1040: -- declare local variables
1041: --
1042: l_count NUMBER(2) := 0;
1043: l_user_id NUMBER := FND_PROFILE.Value('USER_ID');
1044: l_login_id NUMBER := FND_PROFILE.Value('LOGIN_ID');
1045: l_scp_id NUMBER;
1046: --
1047: -- declare cursor for scp_id
1048: --