2557: order by pln_order ;
2558: --
2559: cursor c_benfts_grp(cv_benfts_grp_id number, cv_business_group_id number) is
2560: select bnb.benfts_grp_id
2561: from ben_benfts_grp bnb,
2562: ben_benfts_grp bnb1
2563: where bnb.business_group_id = cv_business_group_id
2564: and bnb.name = bnb1.name
2565: and bnb1.benfts_grp_id = cv_benfts_grp_id;
2558: --
2559: cursor c_benfts_grp(cv_benfts_grp_id number, cv_business_group_id number) is
2560: select bnb.benfts_grp_id
2561: from ben_benfts_grp bnb,
2562: ben_benfts_grp bnb1
2563: where bnb.business_group_id = cv_business_group_id
2564: and bnb.name = bnb1.name
2565: and bnb1.benfts_grp_id = cv_benfts_grp_id;
2566: --