DBA Data[Home] [Help]

APPS.BEN_COBRA_REQUIREMENTS dependencies on BEN_REGN_F

Line 481: from ben_regn_f reg

477: and epe.business_group_id = p_business_group_id;
478: --
479: cursor c_regn is
480: select reg.regn_id
481: from ben_regn_f reg
482: where p_effective_date between
483: reg.effective_start_date and reg.effective_end_date
484: and reg.business_group_id = p_business_group_id
485: and reg.sttry_citn_name = 'COBRA';

Line 1037: from ben_regn_f reg

1033: l_state_rec c_state%rowtype;
1034: --
1035: cursor c_regn is
1036: select reg.regn_id
1037: from ben_regn_f reg
1038: where p_effective_date between
1039: reg.effective_start_date and reg.effective_end_date
1040: and reg.business_group_id = p_business_group_id
1041: and reg.sttry_citn_name = 'COBRA';