APPS.BEN_IRC_UTIL dependencies on BEN_ELIG_PER_ELCTBL_CHC

Line 381: FROM ben_elig_per_elctbl_chc past_epe

377: --- between old and new epe.
378: CURSOR c_last_epe (p_past_pil NUMBER, p_present_pil NUMBER)
379: IS
380: SELECT oipl_id, pl_id, elig_per_elctbl_chc_id,comments
381: FROM ben_elig_per_elctbl_chc past_epe
382: WHERE past_epe.per_in_ler_id = p_past_pil
383: AND past_epe.business_group_id = p_business_group_id
384: AND past_epe.elctbl_flag = 'Y'
385: AND past_epe.approval_status_cd = 'IRC_BEN_A'

Line 388: FROM ben_elig_per_elctbl_chc present_epe

384: AND past_epe.elctbl_flag = 'Y'
385: AND past_epe.approval_status_cd = 'IRC_BEN_A'
386: AND EXISTS (
387: SELECT NULL
388: FROM ben_elig_per_elctbl_chc present_epe
389: WHERE present_epe.per_in_ler_id = p_present_pil
390: AND present_epe.elctbl_flag = 'Y'
391: AND present_epe.elig_flag = 'Y'
392: AND present_epe.pl_id = past_epe.pl_id

Line 400: FROM ben_elig_per_elctbl_chc present_pil

396: -- get the new epe id for commomn comp object
397: CURSOR c_present_epe (p_present_pil NUMBER, p_pl_id NUMBER, p_oipl_id NUMBER)
398: IS
399: SELECT elig_per_elctbl_chc_id,object_version_number
400: FROM ben_elig_per_elctbl_chc present_pil
401: WHERE present_pil.per_in_ler_id = p_present_pil
402: AND present_pil.elctbl_flag = 'Y'
403: AND present_pil.elig_flag = 'Y'
404: AND present_pil.pl_id = p_pl_id

Line 411: l_comments ben_elig_per_elctbl_chc.comments%TYPE;

407: AND present_pil.business_group_id = p_business_group_id;
408:
409: l_present_epe_id NUMBER;
410: l_present_epe_ovn NUMBER;
411: l_comments ben_elig_per_elctbl_chc.comments%TYPE;
412:
413: -- Get the ecr correspoding to past epe
414: CURSOR c_past_ecr (p_past_epe NUMBER)
415: IS