APPS.BEN_CWB_BACK_OUT_CONC dependencies on BEN_PER_IN_LER

Line 672: from ben_per_in_ler pil,

668: pil.lf_evt_ocrd_dt,
669: pil.business_group_id,
670: ler.typ_cd,
671: ler.ler_id
672: from ben_per_in_ler pil,
673: ben_ler_f ler
674: where pil.person_id = l_person_id
675: and pil.lf_evt_ocrd_dt = l_ocrd_date
676: and pil.per_in_ler_stat_cd in ('STRTD', 'PROCD')

Line 698: from ben_per_in_ler pil,

694: --
695: cursor c_latest_ler_cwb is
696: select pil.per_in_ler_id,
697: ler.name
698: from ben_per_in_ler pil,
699: ben_ler_f ler
700: where pil.person_id = l_person_id
701: and pil.per_in_ler_stat_cd not in ('VOIDD', 'BCKDT')
702: and pil.ler_id = ler.ler_id

Line 1129: from ben_per_in_ler pil

1125: select distinct ppf.person_id, ppf.business_group_id
1126: from per_all_people_f ppf
1127: where -- l_effective_date between ppf.effective_start_date and ppf.effective_end_date and
1128: exists (select null
1129: from ben_per_in_ler pil
1130: , ben_ler_f ler
1131: where pil.lf_evt_ocrd_dt = l_ocrd_date
1132: and pil.ler_id = ler.ler_id
1133: and l_effective_date between ler.effective_start_date

Line 1147: from ben_per_in_ler pil

1143: ) ;
1144: /*
1145: cursor c_person is
1146: select distinct pil.person_id, pil.business_group_id
1147: from ben_per_in_ler pil
1148: where pil.lf_evt_ocrd_dt = l_ocrd_date
1149: and pil.per_in_ler_stat_cd in ('STRTD', 'PROCD')
1150: and pil.group_pl_id = p_group_pl_id;
1151:

Line 1173: ben_per_in_ler pil

1169:
1170: cursor c_group_pils(cv_group_bg_id in number) is
1171: Select pil.per_in_ler_id
1172: from ben_person_actions act,
1173: ben_per_in_ler pil
1174: where act.benefit_action_id = l_benefit_action_id
1175: and act.action_status_cd = 'P'
1176: and act.person_id = pil.person_id
1177: and pil.lf_evt_ocrd_dt = l_ocrd_date

Line 1193: ,ben_per_in_ler pil

1189: cursor c_broke_hier (cv_group_pl_id in number,
1190: cv_ocrd_date in date) is
1191: select inf.full_name, inf.person_id
1192: from ben_cwb_person_info inf
1193: ,ben_per_in_ler pil
1194: where pil.group_pl_id = cv_group_pl_id
1195: and pil.lf_evt_ocrd_dt = cv_ocrd_date
1196: and pil.per_in_ler_stat_cd in ('STRTD', 'PROCD')
1197: and pil.ws_mgr_id is not null

Line 2014: from ben_per_in_ler pil,

2010: pil.lf_evt_ocrd_dt,
2011: pil.business_group_id,
2012: ler.typ_cd,
2013: ler.ler_id
2014: from ben_per_in_ler pil,
2015: ben_ler_f ler
2016: where pil.person_id = cv_person_id
2017: and pil.lf_evt_ocrd_dt = cv_lf_evt_ocrd_dt
2018: and pil.per_in_ler_stat_cd in ('STRTD', 'PROCD')