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_PER_IN_LER

Line 151: ben_per_in_ler pil

147: p_person_id NUMBER
148: ) IS
149: SELECT 1
150: FROM ben_le_clsn_n_rstr lct,
151: ben_per_in_ler pil
152: WHERE pil.person_id = p_person_id
153: AND pil.per_in_ler_id = lct.per_in_ler_id; /* Bug 4882374 : Perf */
154: CURSOR c27 (
155: p_person_id NUMBER

Line 182: FROM ben_per_in_ler

178: CURSOR c12 (
179: p_person_id NUMBER
180: ) IS
181: SELECT 1
182: FROM ben_per_in_ler
183: WHERE person_id = p_person_id;
184: CURSOR c9 (
185: p_person_id NUMBER
186: ) IS

Line 776: -- Testing for values in BEN_PER_IN_LER

772: --
773: CLOSE c8;
774:
775: --
776: -- Testing for values in BEN_PER_IN_LER
777: --
778: OPEN c12 (
779: p_person_id
780: );

Line 792: 'BEN_PER_IN_LER'

788: 'BEN_94121_DT_CHILD_EXISTS'
789: );
790: fnd_message.set_token (
791: 'TABLE_NAME',
792: 'BEN_PER_IN_LER'
793: );
794: fnd_message.raise_error;
795: END IF;
796:

Line 1442: --** CN|c1|Fetch the per_in_ler_id from ben_per_in_ler associated with a person_id.

1438: p_per_in_ler_id IN NUMBER default NULL
1439: ) IS
1440: l_proc varchar2(100):= g_package||'delete_life_events';
1441: --** C|c1
1442: --** CN|c1|Fetch the per_in_ler_id from ben_per_in_ler associated with a person_id.
1443: CURSOR c1 IS
1444: SELECT DISTINCT per_in_ler_id
1445: FROM ben_per_in_ler
1446: WHERE person_id = p_person_id

Line 1445: FROM ben_per_in_ler

1441: --** C|c1
1442: --** CN|c1|Fetch the per_in_ler_id from ben_per_in_ler associated with a person_id.
1443: CURSOR c1 IS
1444: SELECT DISTINCT per_in_ler_id
1445: FROM ben_per_in_ler
1446: WHERE person_id = p_person_id
1447: and per_in_ler_id = nvl(p_per_in_ler_id,per_in_ler_id);
1448: --** C|c2|p_per_in_ler_id in number
1449: --** CN|c2|Fetch the prtt_prem_id from ben_prtt_prem_f associated with a per_in_ler_id.

Line 2581: FROM ben_per_in_ler

2577: CURSOR c41 (
2578: p_person_id NUMBER
2579: ) IS
2580: SELECT per_in_ler_id
2581: FROM ben_per_in_ler
2582: WHERE person_id = p_person_id
2583: and per_in_ler_id = nvl(p_per_in_ler_id,per_in_ler_id)
2584: FOR UPDATE OF per_in_ler_id;
2585:

Line 2979: <>

2975: end if;
2976: OPEN c41 (
2977: p_person_id
2978: );
2979: <>
2980: LOOP
2981: FETCH c41 INTO l_id;
2982: EXIT WHEN c41%NOTFOUND;
2983: --Bug 4653271 Deletion of BEn - CWB information

Line 3011: DELETE FROM ben_per_in_ler

3007: DELETE FROM BEN_CWB_MGR_HRCHY_RBV WHERE EMP_ELIG_PER_ELCTBL_CHC_ID = l_elig_per_elctbl_chc_id;
3008: END LOOP ben_elig_per_elctbl_chc;
3009: CLOSE c50;
3010: -- End Bug 4653271
3011: DELETE FROM ben_per_in_ler
3012: WHERE CURRENT OF c41;
3013: END LOOP ben_per_in_ler;
3014: CLOSE c41;
3015:

Line 3013: END LOOP ben_per_in_ler;

3009: CLOSE c50;
3010: -- End Bug 4653271
3011: DELETE FROM ben_per_in_ler
3012: WHERE CURRENT OF c41;
3013: END LOOP ben_per_in_ler;
3014: CLOSE c41;
3015:
3016: --Bug 4653271 Deletion of BEn - CWB information
3017: if(p_per_in_ler_id is NULL) then

Line 3136: FROM ben_per_in_ler pil,

3132: CURSOR c_pil( p_person_id number ,
3133: p_effective_date date
3134: ) is
3135: SELECT 'Y'
3136: FROM ben_per_in_ler pil,
3137: ben_ler_f ler
3138: WHERE pil.person_id = p_person_id
3139: AND pil.per_in_ler_stat_cd = 'STRTD'
3140: AND pil.ler_id = ler.ler_id

Line 3195: ben_per_in_ler pil,

3191: p_effective_date date
3192: ) is
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

Line 3219: ben_per_in_ler pil,

3215: p_effective_date date
3216: ) is
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

Line 3242: ben_per_in_ler pil,

3238: p_effective_date date
3239: ) is
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

Line 3377: ben_per_in_ler pil, ben_ler_f ler,

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
3381: and pen.per_in_ler_id = pil.per_in_ler_id

Line 3415: ben_per_in_ler pil,

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,
3419: pay_element_entries_f ele

Line 3439: from ben_per_in_ler pil,

3435: order by ele.effective_start_date desc;
3436:
3437: cursor c_get_pil is
3438: select pil.per_in_ler_id
3439: from ben_per_in_ler pil,
3440: ben_ler_f ler
3441: where pil.ler_id = ler.ler_id
3442: and l_effective_date between ler.effective_start_date and ler.effective_end_date
3443: and pil.person_id = p_person_id