APPS.BEN_DERIVE_PART_AND_RATE_FACTS dependencies on BEN_CBR_PER_IN_LER

Line 9759: FROM ben_cbr_per_in_ler crp, ben_pil_elctbl_chc_popl pel

9755: --
9756: CURSOR c_get_elcns_made_dt IS
9757: SELECT pel.elcns_made_dt
9758: ,crp.per_in_ler_id
9759: FROM ben_cbr_per_in_ler crp, ben_pil_elctbl_chc_popl pel
9760: WHERE crp.cbr_quald_bnf_id = p_cbr_quald_bnf_id
9761: AND crp.init_evt_flag = 'Y'
9762: AND crp.business_group_id = p_business_group_id
9763: AND crp.per_in_ler_id = pel.per_in_ler_id

Line 10123: ,ben_cbr_per_in_ler crp

10119: SELECT cqb.*
10120: ,crp.per_in_ler_id
10121: ,pil.ler_id
10122: FROM ben_cbr_quald_bnf cqb
10123: ,ben_cbr_per_in_ler crp
10124: ,ben_per_in_ler pil
10125: WHERE cqb.quald_bnf_person_id = p_person_id
10126: AND cqb.quald_bnf_flag = 'Y'
10127: AND cqb.pgm_id = NVL(p_pgm_id

Line 10146: FROM ben_cbr_per_in_ler crp, ben_per_in_ler pil

10142: --
10143: CURSOR c_get_init_evt(
10144: p_cbr_quald_bnf_id IN NUMBER) IS
10145: SELECT NULL
10146: FROM ben_cbr_per_in_ler crp, ben_per_in_ler pil
10147: WHERE crp.cbr_quald_bnf_id = p_cbr_quald_bnf_id
10148: AND crp.per_in_ler_id = pil.per_in_ler_id
10149: AND pil.per_in_ler_stat_cd NOT IN ('VOIDD', 'BCKDT')
10150: AND crp.business_group_id = pil.business_group_id

Line 10156: FROM ben_cbr_per_in_ler crp, ben_per_in_ler pil

10152: AND crp.init_evt_flag = 'N';
10153: CURSOR c_get_per_in_ler(
10154: p_cbr_quald_bnf_id IN NUMBER) IS
10155: SELECT crp.per_in_ler_id
10156: FROM ben_cbr_per_in_ler crp, ben_per_in_ler pil
10157: WHERE crp.cbr_quald_bnf_id = p_cbr_quald_bnf_id
10158: AND crp.per_in_ler_id = pil.per_in_ler_id
10159: AND pil.per_in_ler_stat_cd NOT IN ('VOIDD', 'BCKDT')
10160: -- AND crp.business_group_id = pil.business_group_id

Line 10190: FROM ben_cbr_per_in_ler crp, ben_ler_f ler, ben_per_in_ler pil

10186: --
10187: CURSOR c_get_dsblity_evt(
10188: p_cbr_quald_bnf_id NUMBER) IS
10189: SELECT crp.*
10190: FROM ben_cbr_per_in_ler crp, ben_ler_f ler, ben_per_in_ler pil
10191: WHERE crp.cbr_quald_bnf_id = p_cbr_quald_bnf_id
10192: AND crp.per_in_ler_id = pil.per_in_ler_id
10193: AND pil.ler_id = ler.ler_id
10194: AND ler.typ_cd = 'DSBLTY'

Line 10204: FROM ben_cbr_per_in_ler crp2, ben_per_in_ler pil2

10200: AND ler.business_group_id = pil.business_group_id
10201: AND pil.per_in_ler_stat_cd NOT IN ('VOIDD', 'BCKDT')
10202: AND crp.cnt_num =
10203: (SELECT MAX(cnt_num)
10204: FROM ben_cbr_per_in_ler crp2, ben_per_in_ler pil2
10205: WHERE crp2.cbr_quald_bnf_id = p_cbr_quald_bnf_id
10206: AND crp2.per_in_ler_id = pil2.per_in_ler_id
10207: AND pil2.per_in_ler_stat_cd NOT IN ('VOIDD', 'BCKDT')
10208: AND crp2.business_group_id = p_business_group_id

Line 10218: ,ben_cbr_per_in_ler crp

10214: ,p_pgm_id IN NUMBER
10215: ,p_ptip_id IN NUMBER) IS
10216: SELECT cqb.*
10217: FROM ben_cbr_quald_bnf cqb
10218: ,ben_cbr_per_in_ler crp
10219: ,ben_per_in_ler pil
10220: WHERE cqb.cvrd_emp_person_id = p_cvrd_emp_person_id
10221: AND cqb.quald_bnf_flag = 'Y'
10222: AND l_effective_date BETWEEN cqb.cbr_elig_perd_strt_dt

Line 10271: ,ben_cbr_per_in_ler crp

10267: ,cqb.ptip_id
10268: ,crp.per_in_ler_id
10269: ,pil.ler_id
10270: FROM ben_cbr_quald_bnf cqb
10271: ,ben_cbr_per_in_ler crp
10272: ,ben_per_in_ler pil
10273: WHERE cqb.quald_bnf_person_id = p_person_id
10274: AND cqb.quald_bnf_flag = 'Y'
10275: AND cqb.pgm_id = p_pgm_id