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_ELIG_PER_F

Line 77: FROM ben_elig_per_f

73: CURSOR c17 (
74: p_person_id NUMBER
75: ) IS
76: SELECT 1
77: FROM ben_elig_per_f
78: WHERE person_id = p_person_id;
79: CURSOR c3 (
80: p_person_id NUMBER
81: ) IS

Line 502: -- Testing for values in BEN_ELIG_PER_F

498: --
499: CLOSE c16;
500:
501: --
502: -- Testing for values in BEN_ELIG_PER_F
503: --
504: OPEN c17 (
505: p_person_id
506: );

Line 518: 'BEN_ELIG_PER_F'

514: 'BEN_94121_DT_CHILD_EXISTS'
515: );
516: fnd_message.set_token (
517: 'TABLE_NAME',
518: 'BEN_ELIG_PER_F'
519: );
520: fnd_message.raise_error;
521: END IF;
522:

Line 2266: --** CN|c7|Fetch the elig_per_id from ben_elig_per_f associated with a person_id.

2262: FROM ben_reporting
2263: WHERE benefit_action_id = p_benefit_action_id
2264: FOR UPDATE OF benefit_action_id;
2265: --** C|c7
2266: --** CN|c7|Fetch the elig_per_id from ben_elig_per_f associated with a person_id.
2267: CURSOR c7 IS
2268: SELECT DISTINCT elig_per_id
2269: FROM ben_elig_per_f
2270: WHERE person_id = p_person_id;

Line 2269: FROM ben_elig_per_f

2265: --** C|c7
2266: --** CN|c7|Fetch the elig_per_id from ben_elig_per_f associated with a person_id.
2267: CURSOR c7 IS
2268: SELECT DISTINCT elig_per_id
2269: FROM ben_elig_per_f
2270: WHERE person_id = p_person_id;
2271: --** C|c9
2272: --** CN|c9|Fetch the element_entry_id from pay_element_entries_f associated with a person_id.
2273: CURSOR c9 IS

Line 2412: FROM ben_elig_per_f

2408: CURSOR c34 (
2409: p_person_id NUMBER
2410: ) IS
2411: SELECT elig_per_id
2412: FROM ben_elig_per_f
2413: WHERE person_id = p_person_id
2414: FOR UPDATE OF elig_per_id;
2415:
2416: --

Line 2771: <>

2767: CLOSE c33;
2768: OPEN c34 (
2769: p_person_id
2770: );
2771: <>
2772: LOOP
2773: FETCH c34 INTO l_id;
2774: EXIT WHEN c34%NOTFOUND;
2775: DELETE FROM ben_elig_per_f

Line 2775: DELETE FROM ben_elig_per_f

2771: <>
2772: LOOP
2773: FETCH c34 INTO l_id;
2774: EXIT WHEN c34%NOTFOUND;
2775: DELETE FROM ben_elig_per_f
2776: WHERE CURRENT OF c34;
2777: END LOOP ben_elig_per_f;
2778: CLOSE c34;
2779: OPEN c35 (

Line 2777: END LOOP ben_elig_per_f;

2773: FETCH c34 INTO l_id;
2774: EXIT WHEN c34%NOTFOUND;
2775: DELETE FROM ben_elig_per_f
2776: WHERE CURRENT OF c34;
2777: END LOOP ben_elig_per_f;
2778: CLOSE c34;
2779: OPEN c35 (
2780: p_person_id
2781: );