APPS.PER_COBRA_ECI dependencies on FND_PROFILE

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

894: --
895: -- declare local variables
896: --
897: l_last_eligible_date DATE := p_qualifying_date - 1;
898: l_user_id NUMBER := FND_PROFILE.Value('USER_ID');
899: l_login_id NUMBER := FND_PROFILE.Value('LOGIN_ID');
900: --
901: BEGIN
902: --

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

895: -- declare local variables
896: --
897: l_last_eligible_date DATE := p_qualifying_date - 1;
898: l_user_id NUMBER := FND_PROFILE.Value('USER_ID');
899: l_login_id NUMBER := FND_PROFILE.Value('LOGIN_ID');
900: --
901: BEGIN
902: --
903: hr_utility.set_location(g_package || 'hr_cobra_ins_benefits', 0);

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

1103: --
1104: -- declare local variables
1105: --
1106: l_count NUMBER(2) := 0;
1107: l_user_id NUMBER := FND_PROFILE.Value('USER_ID');
1108: l_login_id NUMBER := FND_PROFILE.Value('LOGIN_ID');
1109: l_scp_id NUMBER;
1110: --
1111: -- declare cursor for scp_id

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

1104: -- declare local variables
1105: --
1106: l_count NUMBER(2) := 0;
1107: l_user_id NUMBER := FND_PROFILE.Value('USER_ID');
1108: l_login_id NUMBER := FND_PROFILE.Value('LOGIN_ID');
1109: l_scp_id NUMBER;
1110: --
1111: -- declare cursor for scp_id
1112: --

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

1533: l_package VARCHAR2(70) := g_package || 'hr_cobra_update_element';
1534: l_effective_start_date date;
1535: l_effective_end_date date;
1536: l_cobra_coverage_benefit_id number;
1537: l_user_id NUMBER := FND_PROFILE.Value('USER_ID');
1538: l_login_id NUMBER := FND_PROFILE.Value('LOGIN_ID');
1539: l_element_entry_id number;
1540: l_element_type_id number;
1541: l_effective_start_date2 date;

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

1534: l_effective_start_date date;
1535: l_effective_end_date date;
1536: l_cobra_coverage_benefit_id number;
1537: l_user_id NUMBER := FND_PROFILE.Value('USER_ID');
1538: l_login_id NUMBER := FND_PROFILE.Value('LOGIN_ID');
1539: l_element_entry_id number;
1540: l_element_type_id number;
1541: l_effective_start_date2 date;
1542: l_effective_end_date2 date;