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 562: from ben_elig_per_elctbl_chc epe,

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

Line 922: ben_elig_per_elctbl_chc epe

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

Line 1010: ben_elig_per_elctbl_chc epe

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

Line 1033: ben_elig_per_elctbl_chc epe

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