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 163: FROM ben_prtt_enrt_rslt_f

159: CURSOR c18 (
160: p_person_id NUMBER
161: ) IS
162: SELECT 1
163: FROM ben_prtt_enrt_rslt_f
164: WHERE person_id = p_person_id;
165: CURSOR c13 (
166: p_person_id NUMBER
167: ) IS

Line 852: -- Testing for values in BEN_PRTT_ENRT_RSLT_F

848: --
849: CLOSE c14;
850:
851: --
852: -- Testing for values in BEN_PRTT_ENRT_RSLT_F
853: --
854: OPEN c18 (
855: p_person_id
856: );

Line 868: 'BEN_PRTT_ENRT_RSLT_F'

864: 'BEN_94121_DT_CHILD_EXISTS'
865: );
866: fnd_message.set_token (
867: 'TABLE_NAME',
868: 'BEN_PRTT_ENRT_RSLT_F'
869: );
870: fnd_message.raise_error;
871: END IF;
872:

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

1403: FROM ben_prtt_prem_by_mo_f
1404: WHERE prtt_prem_id = p_prtt_prem_id
1405: FOR UPDATE OF prtt_prem_by_mo_id;
1406: --** C|c4|p_person_id in number
1407: --** CN|c4|Fetch the prtt_enrt_rslt_id from ben_prtt_enrt_rslt_f associated with a per_in_ler_id.
1408: CURSOR c4 (
1409: p_per_in_ler_id IN NUMBER
1410: ) IS
1411: SELECT DISTINCT prtt_enrt_rslt_id

Line 1412: FROM ben_prtt_enrt_rslt_f

1408: CURSOR c4 (
1409: p_per_in_ler_id IN NUMBER
1410: ) IS
1411: SELECT DISTINCT prtt_enrt_rslt_id
1412: FROM ben_prtt_enrt_rslt_f
1413: WHERE per_in_ler_id = p_per_in_ler_id;
1414:
1415: --
1416: CURSOR c5 (

Line 1572: FROM ben_prtt_enrt_rslt_f b1, ben_elig_cvrd_dpnt b2

1568: CURSOR c22 (
1569: p_per_in_ler_id IN NUMBER
1570: ) IS
1571: SELECT DISTINCT elig_cvrd_dpnt_id
1572: FROM ben_prtt_enrt_rslt_f b1, ben_elig_cvrd_dpnt b2
1573: WHERE b1.per_in_ler_id = p_per_in_ler_id
1574: AND b2.prtt_enrt_rslt_id = b1.prtt_enrt_rslt_id;
1575:
1576: --

Line 1653: FROM ben_prtt_enrt_rslt_f

1649: CURSOR c31 (
1650: p_per_in_ler_id IN NUMBER
1651: ) IS
1652: SELECT prtt_enrt_rslt_id
1653: FROM ben_prtt_enrt_rslt_f
1654: WHERE per_in_ler_id = p_per_in_ler_id
1655: FOR UPDATE OF prtt_enrt_rslt_id;
1656:
1657: --

Line 1952: <>

1948: CLOSE c30;
1949: OPEN c31 (
1950: r1.per_in_ler_id
1951: );
1952: <>
1953: LOOP
1954: FETCH c31 INTO l_id;
1955: EXIT WHEN c31%NOTFOUND;
1956: DELETE FROM ben_prtt_enrt_rslt_f

Line 1956: DELETE FROM ben_prtt_enrt_rslt_f

1952: <>
1953: LOOP
1954: FETCH c31 INTO l_id;
1955: EXIT WHEN c31%NOTFOUND;
1956: DELETE FROM ben_prtt_enrt_rslt_f
1957: WHERE CURRENT OF c31;
1958: END LOOP ben_prtt_enrt_rslt_f;
1959: CLOSE c31;
1960: END LOOP;

Line 1958: END LOOP ben_prtt_enrt_rslt_f;

1954: FETCH c31 INTO l_id;
1955: EXIT WHEN c31%NOTFOUND;
1956: DELETE FROM ben_prtt_enrt_rslt_f
1957: WHERE CURRENT OF c31;
1958: END LOOP ben_prtt_enrt_rslt_f;
1959: CLOSE c31;
1960: END LOOP;
1961: hr_utility.set_location('Leaving: '||l_proc,999);
1962: END delete_life_events;

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

1967: ) IS
1968: l_proc varchar2(100):= g_package||'delete_participant_information';
1969:
1970: --** C|c2|p_person_id in number
1971: --** CN|c2|Fetch the prtt_enrt_rslt_id from ben_prtt_enrt_rslt_f associated with person_id.
1972: CURSOR c1 (
1973: p_person_id IN NUMBER
1974: ) IS
1975: SELECT DISTINCT prtt_enrt_rslt_id

Line 1976: FROM ben_prtt_enrt_rslt_f

1972: CURSOR c1 (
1973: p_person_id IN NUMBER
1974: ) IS
1975: SELECT DISTINCT prtt_enrt_rslt_id
1976: FROM ben_prtt_enrt_rslt_f
1977: WHERE person_id = p_person_id;
1978:
1979: --
1980: CURSOR c2 (

Line 3014: FROM ben_prtt_enrt_rslt_f pen,

3010: CURSOR c_pen( p_person_id number ,
3011: p_effective_date date
3012: ) is
3013: SELECT 'Y'
3014: FROM ben_prtt_enrt_rslt_f pen,
3015: ben_ler_f ler
3016: WHERE pen.person_id=p_person_id and
3017: pen.prtt_enrt_rslt_stat_cd is null and
3018: -- pen.sspndd_flag='N' and Needs to resolve suspended record also

Line 3035: ben_prtt_enrt_rslt_f pen,

3031: p_effective_date date
3032: ) is
3033: SELECT 'Y'
3034: FROM ben_prtt_rt_val prv,
3035: ben_prtt_enrt_rslt_f pen,
3036: ben_ler_f ler
3037: WHERE
3038: pen.person_id=p_person_id and
3039: prv.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id and

Line 3059: ben_prtt_enrt_rslt_f pen

3055: SELECT 'Y'
3056: FROM ben_elig_cvrd_dpnt_f ecd,
3057: ben_per_in_ler pil,
3058: ben_ler_f ler,
3059: ben_prtt_enrt_rslt_f pen
3060: WHERE
3061: pil.person_id=p_person_id and
3062: pil.per_in_ler_id = ecd.per_in_ler_id and
3063: pil.business_group_id = ecd.business_group_id and

Line 3083: ben_prtt_enrt_rslt_f pen

3079: SELECT 'Y'
3080: FROM ben_elig_cvrd_dpnt_f ecd,
3081: ben_per_in_ler pil,
3082: ben_ler_f ler,
3083: ben_prtt_enrt_rslt_f pen
3084: WHERE
3085: ecd.dpnt_person_id = p_person_id and
3086: p_effective_date between ecd.cvg_strt_dt and cvg_thru_dt and
3087: ecd.effective_end_date = hr_api.g_eot

Line 3106: ben_prtt_enrt_rslt_f pen

3102: SELECT 'Y'
3103: FROM ben_pl_bnf_f pbn,
3104: ben_per_in_ler pil,
3105: ben_ler_f ler,
3106: ben_prtt_enrt_rslt_f pen
3107: WHERE
3108: pbn.bnf_person_id = p_person_id and
3109: p_effective_date between pbn.dsgn_strt_dt and pbn.dsgn_thru_dt and
3110: pbn.effective_end_date = hr_api.g_eot