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 126: FROM ben_elig_per_f

122: CURSOR c17 (
123: p_person_id NUMBER
124: ) IS
125: SELECT 1
126: FROM ben_elig_per_f
127: WHERE person_id = p_person_id;
128: CURSOR c3 (
129: p_person_id NUMBER
130: ) IS

Line 551: -- Testing for values in BEN_ELIG_PER_F

547: --
548: CLOSE c16;
549:
550: --
551: -- Testing for values in BEN_ELIG_PER_F
552: --
553: OPEN c17 (
554: p_person_id
555: );

Line 567: 'BEN_ELIG_PER_F'

563: 'BEN_94121_DT_CHILD_EXISTS'
564: );
565: fnd_message.set_token (
566: 'TABLE_NAME',
567: 'BEN_ELIG_PER_F'
568: );
569: fnd_message.raise_error;
570: END IF;
571:

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

2332: FROM ben_reporting
2333: WHERE benefit_action_id = p_benefit_action_id
2334: FOR UPDATE OF benefit_action_id;
2335: --** C|c7
2336: --** CN|c7|Fetch the elig_per_id from ben_elig_per_f associated with a person_id.
2337: CURSOR c7 IS
2338: SELECT DISTINCT elig_per_id
2339: FROM ben_elig_per_f
2340: WHERE person_id = p_person_id

Line 2339: FROM ben_elig_per_f

2335: --** C|c7
2336: --** CN|c7|Fetch the elig_per_id from ben_elig_per_f associated with a person_id.
2337: CURSOR c7 IS
2338: SELECT DISTINCT elig_per_id
2339: FROM ben_elig_per_f
2340: WHERE person_id = p_person_id
2341: and per_in_ler_id = nvl(p_per_in_ler_id,per_in_ler_id);
2342: --** C|c9
2343: --** CN|c9|Fetch the element_entry_id from pay_element_entries_f associated with a person_id.

Line 2516: FROM ben_elig_per_f

2512: CURSOR c34 (
2513: p_person_id NUMBER
2514: ) IS
2515: SELECT elig_per_id
2516: FROM ben_elig_per_f
2517: WHERE person_id = p_person_id
2518: and per_in_ler_id = nvl(p_per_in_ler_id,per_in_ler_id)
2519: FOR UPDATE OF elig_per_id;
2520:

Line 2898: <>

2894: end if;
2895: OPEN c34 (
2896: p_person_id
2897: );
2898: <>
2899: LOOP
2900: FETCH c34 INTO l_id;
2901: EXIT WHEN c34%NOTFOUND;
2902: DELETE FROM ben_elig_per_f

Line 2902: DELETE FROM ben_elig_per_f

2898: <>
2899: LOOP
2900: FETCH c34 INTO l_id;
2901: EXIT WHEN c34%NOTFOUND;
2902: DELETE FROM ben_elig_per_f
2903: WHERE CURRENT OF c34;
2904: END LOOP ben_elig_per_f;
2905: CLOSE c34;
2906: if(p_per_in_ler_id is NULL) then

Line 2904: END LOOP ben_elig_per_f;

2900: FETCH c34 INTO l_id;
2901: EXIT WHEN c34%NOTFOUND;
2902: DELETE FROM ben_elig_per_f
2903: WHERE CURRENT OF c34;
2904: END LOOP ben_elig_per_f;
2905: CLOSE c34;
2906: if(p_per_in_ler_id is NULL) then
2907: OPEN c35 (
2908: p_person_id