DBA Data[Home] [Help]

APPS.BEN_MANAGE_CWB_LIFE_EVENTS dependencies on BEN_BENFTS_GRP

Line 2516: from ben_benfts_grp bnb,

2512: order by pln_order ;
2513: --
2514: cursor c_benfts_grp(cv_benfts_grp_id number, cv_business_group_id number) is
2515: select bnb.benfts_grp_id
2516: from ben_benfts_grp bnb,
2517: ben_benfts_grp bnb1
2518: where bnb.business_group_id = cv_business_group_id
2519: and bnb.name = bnb1.name
2520: and bnb1.benfts_grp_id = cv_benfts_grp_id;

Line 2517: ben_benfts_grp bnb1

2513: --
2514: cursor c_benfts_grp(cv_benfts_grp_id number, cv_business_group_id number) is
2515: select bnb.benfts_grp_id
2516: from ben_benfts_grp bnb,
2517: ben_benfts_grp bnb1
2518: where bnb.business_group_id = cv_business_group_id
2519: and bnb.name = bnb1.name
2520: and bnb1.benfts_grp_id = cv_benfts_grp_id;
2521: --