APPS.BEN_DETERMINE_CHC_CTFN dependencies on BEN_ELIG_PER_ELCTBL_CHC

Line 28: 13 Apr 99 T Guy 115.4 Fixed ben_elig_per_elctbl_chc api

24: if so then do not create ctfn's
25: changed ben_per_in_ler_f to a non
26: date tracked table and fixed approp.
27: cursors
28: 13 Apr 99 T Guy 115.4 Fixed ben_elig_per_elctbl_chc api
29: call
30: 28 Apr 99 Shdas 115.5 Added more contexts to rule calls.
31: 30 Apr 99 lmcdonal 115.6 Add check for per-in-ler status.
32: 04 May 99 Shdas 115.7 Added jurisdiction code.

Line 564: from ben_elig_per_elctbl_chc epe,

560: epe.business_group_id,
561: epe.ctfn_rqd_flag,
562: pil.person_id,
563: pil.ler_id
564: from ben_elig_per_elctbl_chc epe,
565: ben_per_in_ler pil,
566: ben_oipl_f oipl
567: where pil.per_in_ler_id = epe.per_in_ler_id
568: and epe.crntly_enrd_flag = 'N'

Line 924: ben_elig_per_elctbl_chc epe

920: epe.pl_typ_id,
921: epe.pl_id,
922: ecc.enrt_ctfn_typ_cd
923: from ben_elctbl_chc_ctfn ecc,
924: ben_elig_per_elctbl_chc epe
925: where epe.per_in_ler_id = p_per_in_ler_id
926: and epe.elctbl_flag = 'Y'
927: and epe.ctfn_rqd_flag = 'Y'
928: and ecc.elig_per_elctbl_chc_id = epe.elig_per_elctbl_chc_id

Line 1012: ben_elig_per_elctbl_chc epe

1008: ecc.elctbl_chc_ctfn_id,
1009: ecc.object_version_number,
1010: ecc.business_group_id
1011: from ben_elctbl_chc_ctfn ecc,
1012: ben_elig_per_elctbl_chc epe
1013: where epe.per_in_ler_id = p_per_in_ler_id
1014: and epe.pl_id = p_pl_id
1015: and epe.elctbl_flag = 'Y'
1016: and epe.ctfn_rqd_flag = 'Y'

Line 1035: ben_elig_per_elctbl_chc epe

1031: ecc.elctbl_chc_ctfn_id,
1032: ecc.object_version_number,
1033: ecc.business_group_id
1034: from ben_elctbl_chc_ctfn ecc,
1035: ben_elig_per_elctbl_chc epe
1036: where epe.per_in_ler_id = p_per_in_ler_id
1037: and epe.pl_id = p_pl_id
1038: and epe.elctbl_flag = 'Y'
1039: and epe.ctfn_rqd_flag = 'Y'