APPS.OTA_ELIG_PROFILE_UTIL dependencies on BEN_ELIG_OBJ_ELIG_PROFL_F

Line 1362: l_elig_obj_obj_version ben_elig_obj_elig_profl_f.object_version_number%type;

1358: l_effective_start_date date;
1359: l_effective_end_date date;
1360: l_object_version_number2 number;
1361: l_business_group_id number:= p_business_group_id;
1362: l_elig_obj_obj_version ben_elig_obj_elig_profl_f.object_version_number%type;
1363: l_elig_prof_id ben_elig_obj_elig_profl_f.elig_prfl_id%type;
1364: l_elig_obj_elig_prf_id ben_elig_obj_elig_profl_f.elig_obj_elig_prfl_id%type;
1365:
1366: begin

Line 1363: l_elig_prof_id ben_elig_obj_elig_profl_f.elig_prfl_id%type;

1359: l_effective_end_date date;
1360: l_object_version_number2 number;
1361: l_business_group_id number:= p_business_group_id;
1362: l_elig_obj_obj_version ben_elig_obj_elig_profl_f.object_version_number%type;
1363: l_elig_prof_id ben_elig_obj_elig_profl_f.elig_prfl_id%type;
1364: l_elig_obj_elig_prf_id ben_elig_obj_elig_profl_f.elig_obj_elig_prfl_id%type;
1365:
1366: begin
1367:

Line 1364: l_elig_obj_elig_prf_id ben_elig_obj_elig_profl_f.elig_obj_elig_prfl_id%type;

1360: l_object_version_number2 number;
1361: l_business_group_id number:= p_business_group_id;
1362: l_elig_obj_obj_version ben_elig_obj_elig_profl_f.object_version_number%type;
1363: l_elig_prof_id ben_elig_obj_elig_profl_f.elig_prfl_id%type;
1364: l_elig_obj_elig_prf_id ben_elig_obj_elig_profl_f.elig_obj_elig_prfl_id%type;
1365:
1366: begin
1367:
1368:

Line 1454: ben_elig_obj_elig_profl_f

1450: cursor check_elig_obj_asso_id_exist(p_elig_obj_id in number) is
1451: select
1452: elig_obj_elig_prfl_id
1453: from
1454: ben_elig_obj_elig_profl_f
1455: where
1456: trunc(sysdate) between effective_start_date and effective_end_date
1457: and elig_obj_id = p_elig_obj_id
1458: and rownum < 2;

Line 1462: l_elig_obj_elig_prf_id ben_elig_obj_elig_profl_f.elig_obj_elig_prfl_id%type;

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;
1466: l_effective_end_date date;

Line 1463: l_elig_obj_obj_version ben_elig_obj_elig_profl_f.object_version_number%type;

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;
1466: l_effective_end_date date;
1467: l_check_elig_obj_elig_prf_id ben_elig_obj_elig_profl_f.elig_obj_elig_prfl_id%type;

Line 1464: l_elig_prof_id ben_elig_obj_elig_profl_f.elig_prfl_id%type;

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;
1466: l_effective_end_date date;
1467: l_check_elig_obj_elig_prf_id ben_elig_obj_elig_profl_f.elig_obj_elig_prfl_id%type;
1468: begin

Line 1467: l_check_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;
1466: l_effective_end_date date;
1467: l_check_elig_obj_elig_prf_id ben_elig_obj_elig_profl_f.elig_obj_elig_prfl_id%type;
1468: begin
1469:
1470: savepoint delete_eligibility_object;
1471: