APPS.HRI_OPL_BEN_ENRL_ACTN dependencies on BEN_PRTT_ENRT_ACTN_F

Line 292: p_sqlstr := p_sqlstr || ' FROM ben_prtt_enrt_actn_f pea ';

288: p_sqlstr := p_sqlstr || ' AND pil.per_in_ler_stat_cd IN (''STRTD'',''PROCD'') ';
289: p_sqlstr := p_sqlstr || ' AND pil.lf_evt_ocrd_dt >= ';
290: p_sqlstr := p_sqlstr || ' TO_DATE('''||TO_CHAR(g_global_start_date,'MM/DD/YYYY') || ''',''MM/DD/YYYY'') ';
291: p_sqlstr := p_sqlstr || ' AND EXISTS (SELECT 1 ';
292: p_sqlstr := p_sqlstr || ' FROM ben_prtt_enrt_actn_f pea ';
293: p_sqlstr := p_sqlstr || ' WHERE pea.per_in_ler_id = pil.per_in_ler_id ) ';
294: p_sqlstr := p_sqlstr || ' ORDER BY pil.person_id ';
295: --
296: END IF;

Line 663: ben_prtt_enrt_actn_f pea,

659: p_pil_rec.per_in_ler_id,
660: pen.rplcs_sspndd_rslt_id,
661: copd_int.compobj_sk_pk interim_compobj_sk_pk, pea.due_dt
662: FROM ben_prtt_enrt_rslt_f pen,
663: ben_prtt_enrt_actn_f pea,
664: hri_cs_time_benrl_prd_ct enpd,
665: ben_actn_typ act,
666: ben_prtt_enrt_rslt_f pen_int,
667: hri_cs_compobj_ct copd_int,