APPS.GHR_BENEFITS_EIT dependencies on BEN_PTNL_LER_FOR_PER

Line 196: select ler_id from ben_ptnl_ler_for_per

192: SELECT 1 FROM fnd_sessions
193: where session_id = c_session_id;
194:
195: cursor c_get_ler_id is
196: select ler_id from ben_ptnl_ler_for_per
197: where business_group_id = p_business_group_id
198: and person_id = p_person_id
199: and ptnl_ler_for_per_stat_cd ='UNPROCD'
200: and ler_id not in (select ler_id from ben_ler_f where name

Line 215: from ben_ptnl_ler_for_per ptnl,

211:
212: cursor c_get_unproc_lf_evt
213: is
214: select le.name
215: from ben_ptnl_ler_for_per ptnl,
216: ben_ler_f le
217: where ptnl.business_group_id = p_business_group_id
218: and ptnl.person_id = p_person_id
219: and ptnl_ler_for_per_stat_cd ='UNPROCD'

Line 1106: FROM ben_ptnl_ler_for_per

1102: WHERE session_id = c_session_id;
1103:
1104: CURSOR c_get_ler_id(c_effective_date date) is
1105: SELECT ler_id
1106: FROM ben_ptnl_ler_for_per
1107: WHERE business_group_id = p_business_group_id
1108: AND person_id = p_person_id
1109: AND ptnl_ler_for_per_stat_cd ='UNPROCD'
1110: AND ler_id not in (select ler_id from ben_ler_f