DBA Data[Home] [Help]

APPS.HRWSECI dependencies on FND_PROFILE

Line 841: l_user_id NUMBER := FND_PROFILE.Value('USER_ID');

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: --

Line 842: l_login_id NUMBER := FND_PROFILE.Value('LOGIN_ID');

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);

Line 1043: l_user_id NUMBER := FND_PROFILE.Value('USER_ID');

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

Line 1044: l_login_id NUMBER := FND_PROFILE.Value('LOGIN_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: --