DBA Data[Home] [Help]

APPS.BEN_PRTT_RMT_APRVD_PYMT_API dependencies on BEN_PRTT_ENRT_RSLT_F

Line 89: from ben_prtt_enrt_rslt_f pen

85: p_incrd_from_dt date ,
86: p_incrd_to_dt date ) is
87: select pen.pgm_id,
88: pen.per_in_ler_id
89: from ben_prtt_enrt_rslt_f pen
90: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
91: and pen.prtt_enrt_rslt_stat_cd is null
92: and pen.business_group_id = p_business_group_id
93: and p_effective_date between

Line 668: from ben_prtt_enrt_rslt_f pen

664:
665: --
666: cursor c_rslt (p_prtt_enrt_rslt_id number) is
667: select pgm_id
668: from ben_prtt_enrt_rslt_f pen
669: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
670: and pen.prtt_enrt_rslt_stat_cd is null;
671: --
672: l_acty_base_rt c_abr_pl%rowtype;