DBA Data[Home] [Help]

APPS.BEN_COBRA_REQUIREMENTS dependencies on BEN_REGN_F

Line 499: from ben_regn_f reg

495: and epe.business_group_id = p_business_group_id;
496: --
497: cursor c_regn is
498: select reg.regn_id
499: from ben_regn_f reg
500: where p_effective_date between
501: reg.effective_start_date and reg.effective_end_date
502: and reg.business_group_id = p_business_group_id
503: and reg.sttry_citn_name = 'COBRA';

Line 1055: from ben_regn_f reg

1051: l_state_rec c_state%rowtype;
1052: --
1053: cursor c_regn is
1054: select reg.regn_id
1055: from ben_regn_f reg
1056: where p_effective_date between
1057: reg.effective_start_date and reg.effective_end_date
1058: and reg.business_group_id = p_business_group_id
1059: and reg.sttry_citn_name = 'COBRA';