APPS.BEN_DERIVE_PART_AND_RATE_FACTS dependencies on BEN_CBR_PER_IN_LER

Line 9758: FROM ben_cbr_per_in_ler crp, ben_pil_elctbl_chc_popl pel

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

Line 10122: ,ben_cbr_per_in_ler crp

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

Line 10145: FROM ben_cbr_per_in_ler crp, ben_per_in_ler pil

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

Line 10155: FROM ben_cbr_per_in_ler crp, ben_per_in_ler pil

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

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

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

Line 10203: FROM ben_cbr_per_in_ler crp2, ben_per_in_ler pil2

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

Line 10217: ,ben_cbr_per_in_ler crp

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

Line 10270: ,ben_cbr_per_in_ler crp

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