APPS.BEN_CWB_BACK_OUT_CONC dependencies on BEN_PER_IN_LER

Line 747: from ben_per_in_ler pil,

743: pil.lf_evt_ocrd_dt,
744: pil.business_group_id,
745: ler.typ_cd,
746: ler.ler_id
747: from ben_per_in_ler pil,
748: ben_ler_f ler
749: where pil.person_id = l_person_id
750: and pil.lf_evt_ocrd_dt = l_ocrd_date
751: and pil.per_in_ler_stat_cd in ('STRTD', 'PROCD')

Line 773: from ben_per_in_ler pil,

769: --
770: cursor c_latest_ler_cwb is
771: select pil.per_in_ler_id,
772: ler.name
773: from ben_per_in_ler pil,
774: ben_ler_f ler
775: where pil.person_id = l_person_id
776: and pil.per_in_ler_stat_cd not in ('VOIDD', 'BCKDT')
777: and pil.ler_id = ler.ler_id

Line 1207: from ben_per_in_ler pil

1203: select distinct ppf.person_id, ppf.business_group_id
1204: from per_all_people_f ppf
1205: where -- l_effective_date between ppf.effective_start_date and ppf.effective_end_date and
1206: exists (select null
1207: from ben_per_in_ler pil
1208: , ben_ler_f ler
1209: where pil.lf_evt_ocrd_dt = l_ocrd_date
1210: and (p_person_id IS NULL OR pil.person_id = p_person_id)
1211: and pil.ler_id = ler.ler_id

Line 1226: from ben_per_in_ler pil

1222: ) ;
1223: /*
1224: cursor c_person is
1225: select distinct pil.person_id, pil.business_group_id
1226: from ben_per_in_ler pil
1227: where pil.lf_evt_ocrd_dt = l_ocrd_date
1228: and pil.per_in_ler_stat_cd in ('STRTD', 'PROCD')
1229: and pil.group_pl_id = p_group_pl_id;
1230:

Line 1252: ben_per_in_ler pil

1248:
1249: cursor c_group_pils(cv_group_bg_id in number) is
1250: Select pil.per_in_ler_id
1251: from ben_person_actions act,
1252: ben_per_in_ler pil
1253: where act.benefit_action_id = l_benefit_action_id
1254: and act.action_status_cd = 'P'
1255: and act.person_id = pil.person_id
1256: and pil.lf_evt_ocrd_dt = l_ocrd_date

Line 1272: ,ben_per_in_ler pil

1268: cursor c_broke_hier (cv_group_pl_id in number,
1269: cv_ocrd_date in date) is
1270: select inf.full_name, inf.person_id
1271: from ben_cwb_person_info inf
1272: ,ben_per_in_ler pil
1273: where pil.group_pl_id = cv_group_pl_id
1274: and pil.lf_evt_ocrd_dt = cv_ocrd_date
1275: and pil.per_in_ler_stat_cd in ('STRTD', 'PROCD')
1276: and pil.ws_mgr_id is not null

Line 2108: from ben_per_in_ler pil,

2104: pil.lf_evt_ocrd_dt,
2105: pil.business_group_id,
2106: ler.typ_cd,
2107: ler.ler_id
2108: from ben_per_in_ler pil,
2109: ben_ler_f ler
2110: where pil.person_id = cv_person_id
2111: and pil.lf_evt_ocrd_dt = cv_lf_evt_ocrd_dt
2112: and pil.per_in_ler_stat_cd in ('STRTD', 'PROCD')