DBA Data[Home] [Help]

APPS.BEN_PERSON_LIFE_EVENT_API dependencies on BEN_PRTT_ENRT_RSLT_F

Line 126: from ben_prtt_enrt_rslt_f pen, ben_per_in_ler pil

122: cursor c_sspndd_rslt is
123: select pen.prtt_enrt_rslt_id,
124: pen.object_version_number,
125: pil.per_in_ler_id
126: from ben_prtt_enrt_rslt_f pen, ben_per_in_ler pil
127: where pil.person_id = p_person_id
128: and pil.per_in_ler_id = pen.per_in_ler_id
129: --Start Bug 2688172
130: and pil.lf_evt_ocrd_dt <= p_lf_evt_ocrd_dt

Line 511: from ben_prtt_enrt_rslt_f pen, ben_per_in_ler pil

507: cursor c_sspndd_rslt is
508: select pen.prtt_enrt_rslt_id,
509: pen.object_version_number,
510: pil.per_in_ler_id
511: from ben_prtt_enrt_rslt_f pen, ben_per_in_ler pil
512: where pil.person_id = p_person_id
513: and pil.per_in_ler_id = pen.per_in_ler_id
514: --Start Bug 2688172
515: and pil.lf_evt_ocrd_dt <= p_lf_evt_ocrd_dt