eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_PROVIDER_POOLS dependencies on BEN_BNFT_PRVDD_LDGR_F

Line 120: from ben_bnft_prvdd_ldgr_f with the result the

116: 13-Feb-00 pbodla 115.50 - Put the version 115.48 with changes in 115.49
117: 30-Mar-01 kmahendr 115.51 - Bug#1708166 - when comp.object is replaced in the
118: subsequent life event, the flex credit entry for
119: the deenrolled comp.object is not being deleted
120: from ben_bnft_prvdd_ldgr_f with the result the
121: used value is wrongly shown - added codes to
122: cleanup_invalid_ledger_entries
123: 09-Apr-01 pbodla 115.52 - Bug 1711831 - While getting the activity base rate
124: for the provided credits choice row for the pool

Line 1100: from ben_bnft_prvdd_ldgr_f bpl,

1096: select bpl.bnft_prvdd_ldgr_id,
1097: bpl.prvdd_val,
1098: bpl.object_version_number,
1099: bpl.effective_start_date
1100: from ben_bnft_prvdd_ldgr_f bpl,
1101: ben_per_in_ler pil
1102: where bpl.bnft_prvdr_pool_id=p_epe_rec.bnft_prvdr_pool_id
1103: and bpl.business_group_id=p_epe_rec.business_group_id
1104: and bpl.acty_base_rt_id = l_acty_base_rt_id

Line 1224: p_base_table_name => 'BEN_BNFT_PRVDD_LDGR_F',

1220: end if;
1221: */
1222: Get_DT_Upd_Mode
1223: (p_effective_date => p_effective_date,
1224: p_base_table_name => 'BEN_BNFT_PRVDD_LDGR_F',
1225: p_base_key_column => 'BNFT_PRVDD_LDGR_ID',
1226: p_base_key_value => l_bnft_prvdd_ldgr_id,
1227: p_mode => l_datetrack_mode);
1228: hr_utility.set_location('UPDATING LEDGER ID='||to_char(l_bnft_prvdd_ldgr_id),70);

Line 1389: from ben_bnft_prvdd_ldgr_f bpl,

1385: bpl.per_in_ler_id,
1386: bpl.used_val,
1387: bpl.object_version_number,
1388: bpl.effective_start_date
1389: from ben_bnft_prvdd_ldgr_f bpl,
1390: ben_per_in_ler pil
1391: where bpl.bnft_prvdr_pool_id=p_enrt_rt_rec.decr_bnft_prvdr_pool_id
1392: and bpl.business_group_id=p_epe_rec.business_group_id
1393: and bpl.acty_base_rt_id=p_enrt_rt_rec.acty_base_rt_id

Line 1470: p_base_table_name => 'BEN_BNFT_PRVDD_LDGR_F',

1466: l_datetrack_mode:=hr_api.g_update;
1467: end if;*/
1468: Get_DT_Upd_Mode
1469: (p_effective_date => p_effective_date,
1470: p_base_table_name => 'BEN_BNFT_PRVDD_LDGR_F',
1471: p_base_key_column => 'BNFT_PRVDD_LDGR_ID',
1472: p_base_key_value => p_bnft_prvdd_ldgr_id,
1473: p_mode => l_datetrack_mode);
1474: -- bug#2210322 - if there is no update on result row then no need to update ledger row

Line 1537: l_prtt_ro_of_unusd_amt_flag ben_bnft_prvdd_ldgr_f.prtt_ro_of_unusd_amt_flag%type;

1533: l_effective_end_date date;
1534: l_object_version_number number;
1535: l_prtt_enrt_rslt_id number;
1536: l_acty_base_rt_id number;
1537: l_prtt_ro_of_unusd_amt_flag ben_bnft_prvdd_ldgr_f.prtt_ro_of_unusd_amt_flag%type;
1538: l_delete_bpl boolean default true;
1539: l_exists varchar2(1);
1540: --
1541: -- this cursor needs some explaination

Line 1572: ben_bnft_prvdd_ldgr_f bpl,

1568: ben_per_in_ler pil,
1569: ben_enrt_rt ecr1,
1570: ben_enrt_rt ecr2,
1571: ben_enrt_bnft enb,
1572: ben_bnft_prvdd_ldgr_f bpl,
1573: ben_elig_per_elctbl_chc epe_flex,
1574: ben_per_in_ler pil_flex
1575: where pil.person_id=p_person_id and
1576: pil.business_group_id=p_business_group_id and

Line 1609: from ben_bnft_prvdd_ldgr_f bpl,

1605: pen.effective_start_date and pen.effective_end_date;
1606:
1607: cursor c_ldgr_exist(l_ldgr_id number,l_per_in_ler_id number) is
1608: select 'x'
1609: from ben_bnft_prvdd_ldgr_f bpl,
1610: ben_per_in_ler pil
1611: where bpl.bnft_prvdd_ldgr_id = l_ldgr_id
1612: and bpl.per_in_ler_id = l_per_in_ler_id
1613: -- UK change : Bug 1634870

Line 1656: from ben_bnft_prvdd_ldgr_f bpl,

1652: select bpl.bnft_prvdd_ldgr_id,
1653: bpl.prtt_ro_of_unusd_amt_flag,
1654: bpl.object_version_number,
1655: bpl.effective_start_date
1656: from ben_bnft_prvdd_ldgr_f bpl,
1657: ben_per_in_ler pil
1658: where bpl.acty_base_rt_id = l_acty_base_rt_id
1659: and bpl.prtt_enrt_rslt_id = l_prtt_enrt_rslt_id
1660: -- and bpl.effective_end_date = hr_api.g_eot

Line 1698: from ben_bnft_prvdd_ldgr_f bpl,

1694: cursor c_bnft_prvdd_ldgr_2 (p_acty_base_rt_id number) is
1695: select bpl.bnft_prvdd_ldgr_id,
1696: bpl.object_version_number,
1697: effective_start_date
1698: from ben_bnft_prvdd_ldgr_f bpl,
1699: ben_per_in_ler pil
1700: where bpl.bnft_prvdr_pool_id = l_epe.bnft_prvdr_pool_id
1701: and bpl.prtt_enrt_rslt_id = l_prtt_enrt_rslt_id
1702: and bpl.acty_base_rt_id = p_acty_base_rt_id

Line 2052: ben_bnft_prvdd_ldgr_f bpl,

2048: ben_per_in_ler pil,
2049: ben_enrt_rt ecr1,
2050: ben_enrt_rt ecr2,
2051: ben_enrt_bnft enb,
2052: ben_bnft_prvdd_ldgr_f bpl,
2053: ben_elig_per_elctbl_chc epe_flex,
2054: ben_per_in_ler pil_flex,
2055: ben_per_in_ler pil_flex1
2056: where pil.per_in_ler_id = p_per_in_ler_id and

Line 2667: from ben_bnft_prvdd_ldgr_f bpl,

2663: select bpl.bnft_prvdd_ldgr_id,
2664: bpl.frftd_val,
2665: bpl.object_version_number,
2666: bpl.effective_start_date
2667: from ben_bnft_prvdd_ldgr_f bpl,
2668: ben_per_in_ler pil
2669: where bpl.bnft_prvdr_pool_id=p_bnft_prvdr_pool_id
2670: and bpl.business_group_id=p_business_group_id
2671: and bpl.acty_base_rt_id = p_acty_base_rt_id

Line 2687: from ben_bnft_prvdd_ldgr_f bpl,

2683: select bpl.bnft_prvdd_ldgr_id,
2684: bpl.cash_recd_val,
2685: bpl.object_version_number,
2686: bpl.effective_start_date
2687: from ben_bnft_prvdd_ldgr_f bpl,
2688: ben_per_in_ler pil
2689: where bpl.bnft_prvdr_pool_id=p_bnft_prvdr_pool_id
2690: and bpl.business_group_id=p_business_group_id
2691: -- and bpl.acty_base_rt_id = p_acty_base_rt_id /* Bug No 4714939 */

Line 2743: p_base_table_name => 'BEN_BNFT_PRVDD_LDGR_F',

2739: end if;
2740: */
2741: Get_DT_Upd_Mode
2742: (p_effective_date => p_effective_date,
2743: p_base_table_name => 'BEN_BNFT_PRVDD_LDGR_F',
2744: p_base_key_column => 'BNFT_PRVDD_LDGR_ID',
2745: p_base_key_value => l_bnft_prvdd_ldgr_id,
2746: p_mode => l_datetrack_mode);
2747: hr_utility.set_location('UPDATING LEDGER ID='||to_char(l_bnft_prvdd_ldgr_id),20);

Line 2817: p_base_table_name => 'BEN_BNFT_PRVDD_LDGR_F',

2813: --end if;
2814: --
2815: Get_DT_Upd_Mode
2816: (p_effective_date => p_effective_date,
2817: p_base_table_name => 'BEN_BNFT_PRVDD_LDGR_F',
2818: p_base_key_column => 'BNFT_PRVDD_LDGR_ID',
2819: p_base_key_value => l_bnft_prvdd_ldgr_id,
2820: p_mode => l_datetrack_mode);
2821: hr_utility.set_location('l_cash_recd_val is not null '||to_char(l_bnft_prvdd_ldgr_id),20);

Line 2927: from ben_bnft_prvdd_ldgr_f bpl,

2923: l_pgm_id number;
2924:
2925: cursor c_cash_abr is
2926: select bpl.acty_base_rt_id
2927: from ben_bnft_prvdd_ldgr_f bpl,
2928: ben_per_in_ler pil,
2929: ben_acty_base_rt_f abr -- Bug 4613270
2930: where bpl.bnft_prvdr_pool_id=p_bnft_prvdr_pool_id
2931: and bpl.business_group_id=p_business_group_id

Line 2972: from ben_bnft_prvdd_ldgr_f bpl,

2968: select bpl.bnft_prvdd_ldgr_id,
2969: bpl.cash_recd_val,
2970: bpl.object_version_number,
2971: bpl.effective_start_date
2972: from ben_bnft_prvdd_ldgr_f bpl,
2973: ben_per_in_ler pil
2974: where bpl.bnft_prvdr_pool_id = c_bnft_prvdr_pool_id
2975: and bpl.prtt_enrt_rslt_id = c_prtt_enrt_rslt_id
2976: and bpl.cash_recd_val is not null

Line 3232: p_base_table_name => 'BEN_BNFT_PRVDD_LDGR_F',

3228: l_datetrack_mode:=hr_api.g_update;
3229: end if; */
3230: Get_DT_Upd_Mode
3231: (p_effective_date => p_effective_date,
3232: p_base_table_name => 'BEN_BNFT_PRVDD_LDGR_F',
3233: p_base_key_column => 'BNFT_PRVDD_LDGR_ID',
3234: p_base_key_value => l_bnft_prvdd_ldgr_id,
3235: p_mode => l_datetrack_mode);
3236: hr_utility.set_location('UPDATING LEDGER ID='||to_char(l_bnft_prvdd_ldgr_id),340);

Line 3478: from ben_bnft_prvdd_ldgr_f bpl,

3474: nvl(sum(prvdd_val),0),
3475: nvl(sum(decode(prtt_ro_of_unusd_amt_flag,'N',used_val,0)),0),-- non rollovers
3476: nvl(sum(cash_recd_val),0),
3477: nvl(sum(decode(prtt_ro_of_unusd_amt_flag,'Y',used_val,0)),0) -- rollovers
3478: from ben_bnft_prvdd_ldgr_f bpl,
3479: ben_elig_per_elctbl_chc epe_flex,
3480: ben_per_in_ler pil_flex,
3481: ben_per_in_ler pil_flex1
3482: where p_effective_date between

Line 3509: from ben_bnft_prvdd_ldgr_f bpl,

3505: nvl(sum(prvdd_val),0),
3506: nvl(sum(decode(prtt_ro_of_unusd_amt_flag,'N',used_val,0)),0),-- non rollovers
3507: nvl(sum(cash_recd_val),0),
3508: nvl(sum(decode(prtt_ro_of_unusd_amt_flag,'Y',used_val,0)),0) -- rollovers
3509: from ben_bnft_prvdd_ldgr_f bpl,
3510: ben_elig_per_elctbl_chc epe_flex,
3511: ben_per_in_ler pil_flex,
3512: ben_per_in_ler pil_flex1
3513: where p_effective_date between

Line 3538: from ben_bnft_prvdd_ldgr_f bpl,

3534: bnft_prvdd_ldgr_id,
3535: bpl.used_val,
3536: bpl.object_version_number,
3537: bpl.effective_start_date
3538: from ben_bnft_prvdd_ldgr_f bpl,
3539: ben_elig_per_elctbl_chc epe_flex,
3540: ben_per_in_ler pil_flex,
3541: ben_per_in_ler pil_flex1
3542: where p_effective_date between

Line 3759: p_base_table_name => 'BEN_BNFT_PRVDD_LDGR_F',

3755: ;
3756: if c_old_ledger%found then
3757: Get_DT_Upd_Mode
3758: (p_effective_date => p_effective_date,
3759: p_base_table_name => 'BEN_BNFT_PRVDD_LDGR_F',
3760: p_base_key_column => 'BNFT_PRVDD_LDGR_ID',
3761: p_base_key_value => l_bnft_prvdd_ldgr_id,
3762: p_mode => l_datetrack_mode);
3763: l_balance := 0;

Line 3838: p_base_table_name => 'BEN_BNFT_PRVDD_LDGR_F',

3834: end if;
3835: */
3836: Get_DT_Upd_Mode
3837: (p_effective_date => p_effective_date,
3838: p_base_table_name => 'BEN_BNFT_PRVDD_LDGR_F',
3839: p_base_key_column => 'BNFT_PRVDD_LDGR_ID',
3840: p_base_key_value => l_bnft_prvdd_ldgr_id,
3841: p_mode => l_datetrack_mode);
3842: hr_utility.set_location('UPDATING LDGR ID='||to_char(l_bnft_prvdd_ldgr_id),120);

Line 4366: from ben_bnft_prvdd_ldgr_f bpl,

4362: nvl(sum(used_val),0) used_total, -- include rollovers
4363: nvl(sum(frftd_val),0) frftd_total,
4364: nvl(sum(cash_recd_val),0) cash_recd_total,
4365: pil_flex.ler_id
4366: from ben_bnft_prvdd_ldgr_f bpl,
4367: ben_elig_per_elctbl_chc epe_flex,
4368: ben_per_in_ler pil_flex,
4369: ben_per_in_ler pil_flex1
4370: where p_effective_date between

Line 4422: from ben_bnft_prvdd_ldgr_f bpl,

4418: -- Bug 1711831
4419: --
4420: cursor c_get_pool_abr is
4421: select abr.acty_base_rt_id
4422: from ben_bnft_prvdd_ldgr_f bpl,
4423: ben_acty_base_rt_f abr
4424: where bpl.bnft_prvdr_pool_id = l_ledger_totals.bnft_prvdr_pool_id and
4425: abr.rt_usg_cd = 'FLXCR' and
4426: bpl.business_group_id = abr.business_group_id and

Line 4460: from ben_bnft_prvdd_ldgr_f bpl,

4456: select bpl.bnft_prvdd_ldgr_id,
4457: bpl.cash_recd_val,
4458: bpl.object_version_number,
4459: bpl.effective_start_date
4460: from ben_bnft_prvdd_ldgr_f bpl,
4461: ben_per_in_ler pil
4462: where bpl.bnft_prvdr_pool_id=l_ledger_totals.bnft_prvdr_pool_id
4463: and bpl.business_group_id=p_business_group_id
4464: and bpl.acty_base_rt_id = l_acty_base_rt_id

Line 4487: from ben_bnft_prvdd_ldgr_f bpl,

4483: ;
4484: --
4485: cursor c_get_ldgr(p_acty_base_rt_id in number) is
4486: select bpl.used_val
4487: from ben_bnft_prvdd_ldgr_f bpl,
4488: ben_per_in_ler pil
4489: where p_effective_date between
4490: bpl.effective_start_date and
4491: bpl.effective_end_date

Line 5272: from ben_bnft_prvdd_ldgr_f bpl,

5268: bpl.effective_start_date,
5269: bpl.acty_base_rt_id,
5270: bpl.prtt_ro_of_unusd_amt_flag,
5271: bpl.used_val
5272: from ben_bnft_prvdd_ldgr_f bpl,
5273: ben_per_in_ler pil
5274: where bpl.bnft_prvdr_pool_id = p_bnft_prvdr_pool_id
5275: and bpl.prtt_enrt_rslt_id = p_flex_rslt_id
5276: and bpl.business_group_id = p_business_group_id

Line 5536: from ben_bnft_prvdd_ldgr_f bpl,

5532: nvl(sum(bpl.cash_recd_val),0),
5533: nvl(sum(decode(bpl.prtt_ro_of_unusd_amt_flag,
5534: 'Y',bpl.used_val,
5535: 0)),0) -- rollovers
5536: from ben_bnft_prvdd_ldgr_f bpl,
5537: ben_per_in_ler pil
5538: where p_effective_date between
5539: bpl.effective_start_date and bpl.effective_end_date and
5540: bpl.business_group_id=p_business_group_id and

Line 5560: from ben_bnft_prvdd_ldgr_f bpl,

5556: bnft_prvdd_ldgr_id,
5557: bpl.used_val,
5558: bpl.object_version_number,
5559: bpl.effective_start_date
5560: from ben_bnft_prvdd_ldgr_f bpl,
5561: ben_per_in_ler pil
5562: where p_effective_date between
5563: bpl.effective_start_date and bpl.effective_end_date and
5564: bpl.business_group_id=p_business_group_id and

Line 5832: p_base_table_name => 'BEN_BNFT_PRVDD_LDGR_F',

5828: end if;
5829: */
5830: Get_DT_Upd_Mode
5831: (p_effective_date => p_effective_date,
5832: p_base_table_name => 'BEN_BNFT_PRVDD_LDGR_F',
5833: p_base_key_column => 'BNFT_PRVDD_LDGR_ID',
5834: p_base_key_value => l_bnft_prvdd_ldgr_id,
5835: p_mode => l_datetrack_mode);
5836: hr_utility.set_location('UPDATING LEDGER ID='||to_char(l_bnft_prvdd_ldgr_id),120);

Line 5917: from ben_bnft_prvdd_ldgr_f bpl,

5913: nvl(sum(bpl.used_val),0) tot_used,
5914: nvl(sum(frftd_val),0) tot_frftd,
5915: nvl(sum(cash_recd_val),0) tot_cash,
5916: pil.ler_id
5917: from ben_bnft_prvdd_ldgr_f bpl,
5918: ben_per_in_ler pil
5919: where bpl.bnft_prvdr_pool_id = c_bnft_prvdr_pool_id
5920: and bpl.prtt_enrt_rslt_id = c_prtt_enrt_rslt_id
5921: and c_effective_date

Line 5934: from ben_bnft_prvdd_ldgr_f bpl,

5930: -- excess amounts ledger.(Credit Ledger)
5931: --
5932: cursor c_bpl is
5933: select bpl.acty_base_rt_id
5934: from ben_bnft_prvdd_ldgr_f bpl,
5935: ben_per_in_ler pil
5936: where bpl.bnft_prvdr_pool_id = p_bnft_prvdr_pool_id
5937: and bpl.prtt_enrt_rslt_id = p_flex_rslt_id
5938: and bpl.prvdd_val is not null

Line 6625: ben_bnft_prvdd_ldgr_f bpl,

6621: bpl.bnft_prvdr_pool_id,
6622: bpl.prtt_enrt_rslt_id
6623: from ben_prtt_enrt_rslt_f enrt_pen,
6624: ben_prtt_rt_val enrt_prv,
6625: ben_bnft_prvdd_ldgr_f bpl,
6626: ben_per_in_ler pil,
6627: ben_prtt_enrt_rslt_f flex_pen
6628: where enrt_pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
6629: and enrt_pen.prtt_enrt_rslt_stat_cd is null

Line 6668: ben_bnft_prvdd_ldgr_f bpl,

6664: bpl.prvdd_val,
6665: bpl.prtt_enrt_rslt_id,
6666: bpp.uses_net_crs_mthd_flag
6667: from ben_prtt_enrt_rslt_f flex_pen,
6668: ben_bnft_prvdd_ldgr_f bpl,
6669: ben_per_in_ler pil,
6670: ben_bnft_prvdr_pool_f bpp
6671: where flex_pen.person_id = p_person_id
6672: and flex_pen.pgm_id = p_pgm_id

Line 6693: from ben_bnft_prvdd_ldgr_f bpl,

6689: -- Cursor to get forfeited amount for a pool.
6690: --
6691: cursor c_frftd_bpl(v_pool_id in number) is
6692: select bpl.frftd_val
6693: from ben_bnft_prvdd_ldgr_f bpl,
6694: ben_per_in_ler pil
6695: where bpl.bnft_prvdr_pool_id = v_pool_id
6696: and bpl.prtt_enrt_rslt_id = l_flex_rslt_id
6697: and bpl.business_group_id = p_business_group_id

Line 6758: from ben_bnft_prvdd_ldgr_f bpl

6754: select bnft_prvdd_ldgr_id,
6755: effective_start_date,
6756: effective_end_date,
6757: object_version_number
6758: from ben_bnft_prvdd_ldgr_f bpl
6759: where bnft_prvdd_ldgr_id = p_bpl_id
6760: --and effective_start_date < p_eff_dt
6761: order by effective_start_date;
6762: --