APPS.OTA_ELIG_PROFILE_UTIL dependencies on BEN_ELIG_OBJ_F

Line 160: from ben_elig_obj_f

156: return number is
157:
158: cursor get_elig_obj_id is
159: select elig_obj_id
160: from ben_elig_obj_f
161: where
162: TABLE_NAME = 'OTA_USER_GROUPS_B'
163: and COLUMN_NAME='USER_GROUP_ID'
164: and COLUMN_VALUE= p_user_group_id

Line 1346: ben_elig_obj_f EO

1342: cursor get_elig_object_id (p_user_group_id in number) is
1343: select
1344: elig_obj_id
1345: from
1346: ben_elig_obj_f EO
1347: where
1348: trunc(sysdate) between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE
1349: and TABLE_NAME = 'OTA_USER_GROUPS_B'
1350: and COLUMN_NAME = 'USER_GROUP_ID'

Line 1354: l_elig_obj_id ben_elig_obj_f.elig_obj_id%type;

1350: and COLUMN_NAME = 'USER_GROUP_ID'
1351: and COLUMN_VALUE = p_user_group_id;
1352:
1353:
1354: l_elig_obj_id ben_elig_obj_f.elig_obj_id%type;
1355: l_start_date date;
1356: l_end_date date;
1357: l_object_version_number1 number;
1358: l_effective_start_date date;

Line 1441: ben_elig_obj_f EO

1437: select
1438: elig_obj_id ,
1439: object_version_number
1440: from
1441: ben_elig_obj_f EO
1442: where
1443: trunc(sysdate) between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE
1444: and TABLE_NAME = 'OTA_USER_GROUPS_B'
1445: and COLUMN_NAME = 'USER_GROUP_ID'

Line 1460: l_elig_object_id ben_elig_obj_f.elig_obj_id%type;

1456: trunc(sysdate) between effective_start_date and effective_end_date
1457: and elig_obj_id = p_elig_obj_id
1458: and rownum < 2;
1459:
1460: l_elig_object_id ben_elig_obj_f.elig_obj_id%type;
1461: l_obj_version ben_elig_obj_f.object_version_number%type;
1462: l_elig_obj_elig_prf_id ben_elig_obj_elig_profl_f.elig_obj_elig_prfl_id%type;
1463: l_elig_obj_obj_version ben_elig_obj_elig_profl_f.object_version_number%type;
1464: l_elig_prof_id ben_elig_obj_elig_profl_f.elig_prfl_id%type;

Line 1461: l_obj_version ben_elig_obj_f.object_version_number%type;

1457: and elig_obj_id = p_elig_obj_id
1458: and rownum < 2;
1459:
1460: l_elig_object_id ben_elig_obj_f.elig_obj_id%type;
1461: l_obj_version ben_elig_obj_f.object_version_number%type;
1462: l_elig_obj_elig_prf_id ben_elig_obj_elig_profl_f.elig_obj_elig_prfl_id%type;
1463: l_elig_obj_obj_version ben_elig_obj_elig_profl_f.object_version_number%type;
1464: l_elig_prof_id ben_elig_obj_elig_profl_f.elig_prfl_id%type;
1465: l_effective_start_date date;