APPS.BEN_MANAGE_LIFE_EVENTS dependencies on BEN_ACTY_BASE_RT_F

Line 1326: from ben_acty_base_rt_f abr

1322: --
1323: --Bug : 3482033
1324: cursor c2 is
1325: select null
1326: from ben_acty_base_rt_f abr
1327: where abr.pl_id = p_pl_id
1328: and abr.acty_typ_cd like 'CWB%'
1329: and abr.acty_typ_cd not in ('CWBAHE') -- Bug 3975857 - Removed codes CWBRA,CWBGP
1330: and abr.acty_base_rt_stat_cd = 'A'

Line 1362: from ben_acty_base_rt_f abr

1358: cursor c4 is
1359: select count(decode(abr.acty_typ_cd,'CWBDB',1,0)),
1360: count(decode(abr.acty_typ_cd,'CWBWB',1,0)),
1361: count(decode(abr.acty_typ_cd,'CWBR',1,0))
1362: from ben_acty_base_rt_f abr
1363: where abr.acty_typ_cd in ('CWBDB','CWBWB','CWBR')
1364: and abr.acty_base_rt_stat_cd = 'A'
1365: and abr.business_group_id = p_business_group_id
1366: and nvl(p_lf_evt_ocrd_dt,p_effective_date) between

Line 1382: from ben_acty_base_rt_f abr1

1378:
1379: --if plan or option has CWBDB and it should have CWBWB
1380: cursor c5 is
1381: select 'x'
1382: from ben_acty_base_rt_f abr1
1383: where
1384: ( abr1.acty_typ_cd in ('CWBDB')
1385: and abr1.acty_base_rt_stat_cd = 'A'
1386: and abr1.business_group_id = p_business_group_id

Line 1401: from ben_acty_base_rt_f abr2

1397: )
1398: )
1399: and not exists
1400: (select 'x'
1401: from ben_acty_base_rt_f abr2
1402: where abr2.acty_typ_cd = 'CWBWB'
1403: and abr2.acty_base_rt_stat_cd = 'A'
1404: and abr2.business_group_id = p_business_group_id
1405: and nvl(p_lf_evt_ocrd_dt,p_effective_date) between

Line 1429: from ben_acty_base_rt_f abr2

1425: )
1426: )
1427: and not exists
1428: (select 'x'
1429: from ben_acty_base_rt_f abr2
1430: where abr2.acty_typ_cd = 'CWBDB'
1431: and abr2.acty_base_rt_stat_cd = 'A'
1432: and abr2.business_group_id = p_business_group_id
1433: and nvl(p_lf_evt_ocrd_dt,p_effective_date) between

Line 1443: from ben_acty_base_rt_f abr1

1439:
1440:
1441: cursor c6 is
1442: select 'x'
1443: from ben_acty_base_rt_f abr1
1444: where abr1.acty_typ_cd in ('CWBDB')
1445: and abr1.acty_base_rt_stat_cd = 'A'
1446: and abr1.business_group_id = p_business_group_id
1447: and nvl(p_lf_evt_ocrd_dt,p_effective_date) between

Line 1461: from ben_acty_base_rt_f abr2

1457: )
1458: )
1459: and not exists
1460: (select 'x'
1461: from ben_acty_base_rt_f abr2
1462: where abr2.acty_typ_cd in ('CWBES')
1463: and abr2.acty_base_rt_stat_cd = 'A'
1464: and abr2.business_group_id = p_business_group_id
1465: and nvl(p_lf_evt_ocrd_dt,p_effective_date) between

Line 1533: from ben_acty_base_rt_f abr

1529:
1530: -- rate is attached to plan
1531: cursor c11 is
1532: select 'x' found
1533: from ben_acty_base_rt_f abr
1534: where abr.acty_typ_cd in ('CWBDB','CWBWB','CWBR')
1535: and abr.acty_base_rt_stat_cd = 'A'
1536: and abr.business_group_id = p_business_group_id
1537: and nvl(p_lf_evt_ocrd_dt,p_effective_date) between