APPS.BEN_REOPEN_LER_CONC dependencies on BEN_PER_IN_LER

Line 85: -- given from ben_per_in_ler. We will to check whether this life event is

81: --
82: -- curosrs
83: --
84: -- this cursor will fetch all the processed life events with the ler id
85: -- given from ben_per_in_ler. We will to check whether this life event is
86: -- latest or not at the time reopening life event api
87: CURSOR c_pil
88: IS
89: SELECT per.person_id, pil.per_in_ler_id

Line 90: FROM per_all_people_f per, ben_per_in_ler pil, ben_ler_f ler

86: -- latest or not at the time reopening life event api
87: CURSOR c_pil
88: IS
89: SELECT per.person_id, pil.per_in_ler_id
90: FROM per_all_people_f per, ben_per_in_ler pil, ben_ler_f ler
91: WHERE pil.person_id = per.person_id
92: AND pil.per_in_ler_stat_cd = 'PROCD'
93: AND pil.ler_id = p_ler_id
94: AND pil.ler_id = ler.ler_id

Line 253: -- Loop through rows in ben_per_in_ler_f based on the parameters passed and

249: DELETE FROM ben_batch_ranges
250: WHERE benefit_action_id = l_benefit_action_id;
251:
252: --
253: -- Loop through rows in ben_per_in_ler_f based on the parameters passed and
254: -- create person actions for the selected people.
255: --
256: FOR l_rec IN c_pil
257: LOOP

Line 653: FROM ben_per_in_ler

649: --
650: CURSOR c_per_in_ler (p_per_in_ler_id IN NUMBER)
651: IS
652: SELECT lf_evt_ocrd_dt, object_version_number
653: FROM ben_per_in_ler
654: WHERE per_in_ler_id = p_per_in_ler_id;
655:
656: --
657: l_parm c_parameter%ROWTYPE;