DBA Data[Home] [Help]

APPS.BEN_PRTT_ENRT_RESULT_API dependencies on BEN_PRTT_ENRT_CTFN_PRVDD_F

Line 790: from ben_prtt_enrt_ctfn_prvdd_f

786:
787: --
788: cursor c_future_pcs(p_prtt_enrt_actn_id number,p_effective_date date ) is
789: select *
790: from ben_prtt_enrt_ctfn_prvdd_f
791: where prtt_enrt_actn_id = p_prtt_enrt_actn_id
792: and effective_start_date > p_effective_date
793: order by effective_start_date desc ;
794: --

Line 977: --ben_prtt_enrt_ctfn_prvdd_f

973: );
974:
975: end loop;
976: --
977: --ben_prtt_enrt_ctfn_prvdd_f
978: --
979: for l_lcs in c_future_pcs(l_bnf_types.prtt_enrt_actn_id,l_effective_date) loop
980: --
981: insert into BEN_LE_CLSN_N_RSTR (

Line 1038: 'BEN_PRTT_ENRT_CTFN_PRVDD_F_UPD'

1034: OBJECT_VERSION_NUMBER,
1035: PER_IN_LER_ID,
1036: PER_IN_LER_ENDED_ID)
1037: values (
1038: 'BEN_PRTT_ENRT_CTFN_PRVDD_F_UPD'
1039: ,l_lcs.PRTT_ENRT_CTFN_PRVDD_ID
1040: ,l_lcs.EFFECTIVE_START_DATE
1041: ,l_lcs.EFFECTIVE_END_DATE
1042: ,l_lcs.ENRT_CTFN_RQD_FLAG