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_CWB_BACK_OUT_CONC dependencies on BEN_CWB_PERSON_RATES

Line 33: 27-Apr-04 rpgupta 115.13 bug 3517726 - elete records in ben_cwb_person_rates

29: BEN_CWB_SUMMARY,
30: ben_cwb_pl_dsgn
31: 26-Mar-04 pbodla 115.9 l_ocrd_date need to be passed to
32: BEN_CWB_PL_DSGN_PKG.delete_pl_dsgn
33: 27-Apr-04 rpgupta 115.13 bug 3517726 - elete records in ben_cwb_person_rates
34: with the given group_pl_id, ler_id and life event
35: ocrd date. Sometimes when one thread of benmngle
36: fails, theres a possibility that a few records in
37: person_rates exist with group_per_in_ler_id as -1

Line 70: then while backing out BEN_CWB_PERSON_RATES rows

66: person, the person rates are also
67: deleted and the element entries are
68: not backed out.
69: 06-Apr-2006 abparekh 115.25 Bug 5130397 : When CWB plan has options attached,
70: then while backing out BEN_CWB_PERSON_RATES rows
71: delete pay proposal only once
72: 25-May-2006 ikasired 115.26 Bug 5240208 fix for heirarchy issue for
73: reassign, backout and reprocess issue
74: 26-May-2006 maagrawa 115.27 Always run summary refresh at end

Line 409: -- ben_cwb_person_rates.ELEMENT_ENTRY_VALUE_ID will be passed this routine.

405: -- Ignore proration etc., YES
406: -- Element entry is shared by mutliple cwb entries ? NO
407: --
408: -- Assumptions.
409: -- ben_cwb_person_rates.ELEMENT_ENTRY_VALUE_ID will be passed this routine.
410: -- Element type from ben_cwb_plan_design overrides from abr.
411: -- Abr information have to be fetched similar to cwb post process.
412: --
413: --

Line 986: delete from ben_cwb_person_rates

982:
983: /* bug 3517726
984: */
985:
986: delete from ben_cwb_person_rates
987: where group_pl_id = p_group_pl_id
988: and lf_evt_ocrd_dt = l_ocrd_date
989: and group_per_in_ler_id = -1 -- Bug 5060080
990: and person_id = l_person_id;

Line 1746: from ben_cwb_person_rates

1742: where group_per_in_ler_id = p_per_in_ler_id;
1743: --
1744: cursor c_cwb_person_rates is
1745: select distinct pl_id, oipl_id, pay_proposal_id
1746: from ben_cwb_person_rates
1747: where group_per_in_ler_id = p_per_in_ler_id
1748: order by pay_proposal_id;
1749: --
1750: l_pl_id number;

Line 1758: from ben_cwb_person_rates

1754: select ELEMENT_ENTRY_VALUE_ID,
1755: COMP_POSTING_DATE,
1756: person_id,
1757: object_version_number
1758: from ben_cwb_person_rates
1759: where group_per_in_ler_id = p_per_in_ler_id
1760: and pl_id = l_pl_id
1761: and oipl_id = l_oipl_id ;
1762: --

Line 1841: elsif p_routine = 'BEN_CWB_PERSON_RATES' then

1837:
1838: end loop;
1839: close c_cwb_person_group;
1840: --
1841: elsif p_routine = 'BEN_CWB_PERSON_RATES' then
1842: --
1843: l_pay_proposal_id_prev := -1;
1844: --
1845: open c_cwb_person_rates;

Line 1895: ben_cwb_person_rates_api.delete_person_rate

1891:
1892: end if;
1893: --
1894: if l_object_version_number is not null then
1895: ben_cwb_person_rates_api.delete_person_rate
1896: (p_validate => false
1897: ,p_group_per_in_ler_id => p_per_in_ler_id
1898: ,p_pl_id => l_pl_id
1899: ,p_oipl_id => l_oipl_id

Line 1904: -- Bug 5130397 : When CWB plan has options attached, then all corresponding rows in BEN_CWB_PERSON_RATES

1900: ,p_object_version_number => l_object_version_number
1901: ,p_update_summary => p_update_summary) ;
1902: end if;
1903: --
1904: -- Bug 5130397 : When CWB plan has options attached, then all corresponding rows in BEN_CWB_PERSON_RATES
1905: -- has pay_proposal_id populated and this being same ID, we should not call delete API
1906: -- more than once. Hence added following check : l_pay_proposal_id <> l_pay_proposal_id_prev
1907: --
1908: if l_pay_proposal_id is not null AND

Line 2005: --2. BEN_CWB_PERSON_RATES

2001: ,p_per_in_ler_id => p_per_in_ler_id
2002: ,p_update_summary => p_update_summary
2003: );
2004:
2005: --2. BEN_CWB_PERSON_RATES
2006: hr_utility.set_location( 'Calling delete for BEN_CWB_PERSON_RATES', 15);
2007: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
2008: fnd_message.set_token('PROC','delete_person_rates');
2009: cwb_delete_routine

Line 2006: hr_utility.set_location( 'Calling delete for BEN_CWB_PERSON_RATES', 15);

2002: ,p_update_summary => p_update_summary
2003: );
2004:
2005: --2. BEN_CWB_PERSON_RATES
2006: hr_utility.set_location( 'Calling delete for BEN_CWB_PERSON_RATES', 15);
2007: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
2008: fnd_message.set_token('PROC','delete_person_rates');
2009: cwb_delete_routine
2010: (p_routine => 'BEN_CWB_PERSON_RATES'

Line 2010: (p_routine => 'BEN_CWB_PERSON_RATES'

2006: hr_utility.set_location( 'Calling delete for BEN_CWB_PERSON_RATES', 15);
2007: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
2008: fnd_message.set_token('PROC','delete_person_rates');
2009: cwb_delete_routine
2010: (p_routine => 'BEN_CWB_PERSON_RATES'
2011: ,p_per_in_ler_id => p_per_in_ler_id
2012: ,p_update_summary => p_update_summary
2013: );
2014:

Line 2162: delete from ben_cwb_person_rates

2158: --
2159: backout_heirarchy_data
2160: (p_per_in_ler_id => l_pil_rec.per_in_ler_id);
2161: --
2162: delete from ben_cwb_person_rates
2163: where group_pl_id = p_group_pl_id
2164: and lf_evt_ocrd_dt = l_pil_rec.lf_evt_ocrd_dt
2165: and group_per_in_ler_id = -1 -- Bug 5060080
2166: and person_id = p_person_id;