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_PERSON_DELETE dependencies on BEN_PRTT_ENRT_RSLT_F

Line 212: FROM ben_prtt_enrt_rslt_f

208: CURSOR c18 (
209: p_person_id NUMBER
210: ) IS
211: SELECT 1
212: FROM ben_prtt_enrt_rslt_f
213: WHERE person_id = p_person_id;
214: CURSOR c13 (
215: p_person_id NUMBER
216: ) IS

Line 901: -- Testing for values in BEN_PRTT_ENRT_RSLT_F

897: --
898: CLOSE c14;
899:
900: --
901: -- Testing for values in BEN_PRTT_ENRT_RSLT_F
902: --
903: OPEN c18 (
904: p_person_id
905: );

Line 917: 'BEN_PRTT_ENRT_RSLT_F'

913: 'BEN_94121_DT_CHILD_EXISTS'
914: );
915: fnd_message.set_token (
916: 'TABLE_NAME',
917: 'BEN_PRTT_ENRT_RSLT_F'
918: );
919: fnd_message.raise_error;
920: END IF;
921:

Line 1464: --** CN|c4|Fetch the prtt_enrt_rslt_id from ben_prtt_enrt_rslt_f associated with a per_in_ler_id.

1460: FROM ben_prtt_prem_by_mo_f
1461: WHERE prtt_prem_id = p_prtt_prem_id
1462: FOR UPDATE OF prtt_prem_by_mo_id;
1463: --** C|c4|p_person_id in number
1464: --** CN|c4|Fetch the prtt_enrt_rslt_id from ben_prtt_enrt_rslt_f associated with a per_in_ler_id.
1465: CURSOR c4 (
1466: p_per_in_ler_id IN NUMBER
1467: ) IS
1468: SELECT DISTINCT prtt_enrt_rslt_id

Line 1469: FROM ben_prtt_enrt_rslt_f

1465: CURSOR c4 (
1466: p_per_in_ler_id IN NUMBER
1467: ) IS
1468: SELECT DISTINCT prtt_enrt_rslt_id
1469: FROM ben_prtt_enrt_rslt_f
1470: WHERE per_in_ler_id = p_per_in_ler_id;
1471:
1472: --
1473: CURSOR c5 (

Line 1629: FROM ben_prtt_enrt_rslt_f b1, ben_elig_cvrd_dpnt b2

1625: CURSOR c22 (
1626: p_per_in_ler_id IN NUMBER
1627: ) IS
1628: SELECT DISTINCT elig_cvrd_dpnt_id
1629: FROM ben_prtt_enrt_rslt_f b1, ben_elig_cvrd_dpnt b2
1630: WHERE b1.per_in_ler_id = p_per_in_ler_id
1631: AND b2.prtt_enrt_rslt_id = b1.prtt_enrt_rslt_id;
1632:
1633: --

Line 1710: FROM ben_prtt_enrt_rslt_f

1706: CURSOR c31 (
1707: p_per_in_ler_id IN NUMBER
1708: ) IS
1709: SELECT prtt_enrt_rslt_id
1710: FROM ben_prtt_enrt_rslt_f
1711: WHERE per_in_ler_id = p_per_in_ler_id
1712: FOR UPDATE OF prtt_enrt_rslt_id;
1713:
1714: --

Line 2009: <>

2005: CLOSE c30;
2006: OPEN c31 (
2007: r1.per_in_ler_id
2008: );
2009: <>
2010: LOOP
2011: FETCH c31 INTO l_id;
2012: EXIT WHEN c31%NOTFOUND;
2013: DELETE FROM ben_prtt_enrt_rslt_f

Line 2013: DELETE FROM ben_prtt_enrt_rslt_f

2009: <>
2010: LOOP
2011: FETCH c31 INTO l_id;
2012: EXIT WHEN c31%NOTFOUND;
2013: DELETE FROM ben_prtt_enrt_rslt_f
2014: WHERE CURRENT OF c31;
2015: END LOOP ben_prtt_enrt_rslt_f;
2016: CLOSE c31;
2017: END LOOP;

Line 2015: END LOOP ben_prtt_enrt_rslt_f;

2011: FETCH c31 INTO l_id;
2012: EXIT WHEN c31%NOTFOUND;
2013: DELETE FROM ben_prtt_enrt_rslt_f
2014: WHERE CURRENT OF c31;
2015: END LOOP ben_prtt_enrt_rslt_f;
2016: CLOSE c31;
2017: END LOOP;
2018: hr_utility.set_location('Leaving: '||l_proc,999);
2019: END delete_life_events;

Line 2029: --** CN|c2|Fetch the prtt_enrt_rslt_id from ben_prtt_enrt_rslt_f associated with person_id.

2025: ) IS
2026: l_proc varchar2(100):= g_package||'delete_participant_information';
2027:
2028: --** C|c2|p_person_id in number
2029: --** CN|c2|Fetch the prtt_enrt_rslt_id from ben_prtt_enrt_rslt_f associated with person_id.
2030: CURSOR c1 (
2031: p_person_id IN NUMBER
2032: ) IS
2033: SELECT DISTINCT prtt_enrt_rslt_id

Line 2034: FROM ben_prtt_enrt_rslt_f

2030: CURSOR c1 (
2031: p_person_id IN NUMBER
2032: ) IS
2033: SELECT DISTINCT prtt_enrt_rslt_id
2034: FROM ben_prtt_enrt_rslt_f
2035: WHERE person_id = p_person_id
2036: and per_in_ler_id = nvl(p_per_in_ler_id,per_in_ler_id);
2037:
2038: --

Line 3152: FROM ben_prtt_enrt_rslt_f pen,

3148: CURSOR c_pen( p_person_id number ,
3149: p_effective_date date
3150: ) is
3151: SELECT 'Y'
3152: FROM ben_prtt_enrt_rslt_f pen,
3153: ben_ler_f ler
3154: WHERE pen.person_id=p_person_id and
3155: pen.prtt_enrt_rslt_stat_cd is null and
3156: -- pen.sspndd_flag='N' and Needs to resolve suspended record also

Line 3173: ben_prtt_enrt_rslt_f pen,

3169: p_effective_date date
3170: ) is
3171: SELECT 'Y'
3172: FROM ben_prtt_rt_val prv,
3173: ben_prtt_enrt_rslt_f pen,
3174: ben_ler_f ler
3175: WHERE
3176: pen.person_id=p_person_id and
3177: prv.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id and

Line 3197: ben_prtt_enrt_rslt_f pen

3193: SELECT 'Y'
3194: FROM ben_elig_cvrd_dpnt_f ecd,
3195: ben_per_in_ler pil,
3196: ben_ler_f ler,
3197: ben_prtt_enrt_rslt_f pen
3198: WHERE
3199: pil.person_id=p_person_id and
3200: pil.per_in_ler_id = ecd.per_in_ler_id and
3201: pil.business_group_id = ecd.business_group_id and

Line 3221: ben_prtt_enrt_rslt_f pen

3217: SELECT 'Y'
3218: FROM ben_elig_cvrd_dpnt_f ecd,
3219: ben_per_in_ler pil,
3220: ben_ler_f ler,
3221: ben_prtt_enrt_rslt_f pen
3222: WHERE
3223: ecd.dpnt_person_id = p_person_id and
3224: p_effective_date between ecd.cvg_strt_dt and cvg_thru_dt and
3225: ecd.effective_end_date = hr_api.g_eot

Line 3244: ben_prtt_enrt_rslt_f pen

3240: SELECT 'Y'
3241: FROM ben_pl_bnf_f pbn,
3242: ben_per_in_ler pil,
3243: ben_ler_f ler,
3244: ben_prtt_enrt_rslt_f pen
3245: WHERE
3246: pbn.bnf_person_id = p_person_id and
3247: p_effective_date between pbn.dsgn_strt_dt and pbn.dsgn_thru_dt and
3248: pbn.effective_end_date = hr_api.g_eot

Line 3376: ben_prtt_enrt_rslt_f pen,

3372:
3373:
3374: cursor c_chk_ele_entries is
3375: select '1' from
3376: ben_prtt_enrt_rslt_f pen,
3377: ben_per_in_ler pil, ben_ler_f ler,
3378: ben_prtt_rt_val prv
3379: where pen.person_id = p_person_id
3380: and pen.business_group_id = p_business_group_id

Line 3414: ben_prtt_enrt_rslt_f pen,

3410: distinct ele.element_entry_id ele_entry_id,
3411: ele.object_version_number ovn,
3412: ele.effective_start_date esd
3413: from
3414: ben_prtt_enrt_rslt_f pen,
3415: ben_per_in_ler pil,
3416: ben_ler_f ler,
3417: ben_prtt_rt_val prv,
3418: pay_element_entry_values_f elv,