APPS.BEN_DETERMINE_ELIGIBILITY2 dependencies on BEN_PER_IN_LER

Line 396: ,p_pil_row in ben_per_in_ler%rowtype

392: -- -----------------------------------------------------------------------------
393: --
394: procedure get_start_end_dates
395: (p_comp_obj_tree_row in ben_manage_life_events.g_cache_proc_objects_rec
396: ,p_pil_row in ben_per_in_ler%rowtype
397: ,p_effective_date in date
398: ,p_business_group_id in number
399: ,p_person_id in number
400: ,p_pl_id in number

Line 1091: ,p_pil_row in out NOCOPY ben_per_in_ler%rowtype

1087: (p_comp_obj_tree_row in out NOCOPY ben_manage_life_events.g_cache_proc_objects_rec
1088: ,p_per_row in out NOCOPY per_all_people_f%rowtype
1089: ,p_empasg_row in out NOCOPY per_all_assignments_f%rowtype
1090: ,p_benasg_row in out NOCOPY per_all_assignments_f%rowtype
1091: ,p_pil_row in out NOCOPY ben_per_in_ler%rowtype
1092: ,p_person_id in number
1093: ,p_business_group_id in number
1094: ,p_effective_date in date
1095: ,p_lf_evt_ocrd_dt in date

Line 1230: ben_per_in_ler pil

1226: pep.prtn_end_dt,
1227: pep.per_in_ler_id,
1228: pep.object_version_number
1229: from ben_elig_per_f pep,
1230: ben_per_in_ler pil
1231: where pep.person_id = c_person_id
1232: and nvl(pep.pgm_id,-1) = c_pgm_id
1233: and nvl(pep.pl_id,-1) = c_pl_id
1234: and pep.plip_id is null

Line 1271: ben_per_in_ler pil,

1267: epo.per_in_ler_id,
1268: pep.prtn_strt_dt,
1269: pep.prtn_end_dt
1270: from ben_elig_per_opt_f epo,
1271: ben_per_in_ler pil,
1272: ben_elig_per_f pep
1273: where pep.person_id = c_person_id
1274: and pep.pl_id = c_pl_id
1275: and epo.opt_id = c_opt_id

Line 1307: ben_per_in_ler pil,

1303: epo.elig_per_id,
1304: epo.effective_start_date,
1305: epo.object_version_number
1306: from ben_elig_per_opt_f epo,
1307: ben_per_in_ler pil,
1308: ben_elig_per_f pep
1309: where pep.person_id = c_person_id
1310: and pep.pgm_id = c_pgm_id
1311: and pep.plip_id = c_plip_id

Line 1337: ben_per_in_ler pil

1333: )
1334: is
1335: select pep.prtn_strt_dt
1336: from ben_elig_per_f pep,
1337: ben_per_in_ler pil
1338: where pep.person_id = p_person_id
1339: and nvl(pep.pgm_id,-1) =
1340: nvl(p_pgm_id,nvl(l_envpgm_id,-1))
1341: and nvl(pep.pl_id,-1) = nvl(p_pl_id,-1)

Line 1385: ben_per_in_ler pil

1381: is
1382: select epo.prtn_strt_dt
1383: from ben_elig_per_opt_f epo,
1384: ben_elig_per_f pep,
1385: ben_per_in_ler pil
1386: where pep.person_id = p_person_id
1387: and pep.pl_id = l_envpl_id
1388: and nvl(pep.pgm_id,-1) = nvl(l_envpgm_id,-1)
1389: and pep.elig_per_id = epo.elig_per_id

Line 1448: l_pil_rec ben_per_in_ler%rowtype;

1444: l_plan_ordr_num ben_pl_f.ordr_num%type;
1445: --
1446: l_comp_rec ben_derive_part_and_rate_facts.g_cache_structure;
1447: l_oiplip_rec ben_derive_part_and_rate_facts.g_cache_structure;
1448: l_pil_rec ben_per_in_ler%rowtype;
1449: l_prev_eligibility boolean;
1450: --
1451: l_oiplippep_dets ben_pep_cache.g_pep_rec;
1452: l_plnpep_dets ben_pep_cache.g_pep_rec;

Line 1471: from ben_per_in_ler pil,

1467: /* Bug 9020962 */
1468: /* Cursor to get the previous per_in_ler_id*/
1469: cursor c_prev_pil(c_per_in_ler_id number ) is
1470: select pil.per_in_ler_id
1471: from ben_per_in_ler pil,
1472: ben_ler_f ler
1473: where pil.per_in_ler_id not in (c_per_in_ler_id)
1474: and pil.person_id = p_person_id
1475: and pil.ler_id = ler.ler_id