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_PERSON_ACTIONS

Line 109: FROM ben_person_actions

105: CURSOR c27 (
106: p_person_id NUMBER
107: ) IS
108: SELECT 1
109: FROM ben_person_actions
110: WHERE person_id = p_person_id;
111: CURSOR c4 (
112: p_person_id NUMBER
113: ) IS

Line 176: ben_person_actions pat

172: p_person_id NUMBER
173: ) IS
174: SELECT 1
175: FROM ben_reporting rep,
176: ben_person_actions pat
177: WHERE pat.person_id = p_person_id
178: AND rep.benefit_action_id = pat.benefit_action_id; /* Bug 4882374 : Perf */
179: CURSOR c29 (
180: p_person_id NUMBER

Line 627: -- Testing for values in BEN_PERSON_ACTIONS

623: --
624: CLOSE c11;
625:
626: --
627: -- Testing for values in BEN_PERSON_ACTIONS
628: --
629: OPEN c27 (
630: p_person_id
631: );

Line 643: 'BEN_PERSON_ACTIONS'

639: 'BEN_94121_DT_CHILD_EXISTS'
640: );
641: fnd_message.set_token (
642: 'TABLE_NAME',
643: 'BEN_PERSON_ACTIONS'
644: );
645: fnd_message.raise_error;
646: END IF;
647:

Line 2153: FROM ben_person_actions

2149: CURSOR c3 (
2150: p_benefit_action_id NUMBER
2151: ) IS
2152: SELECT person_action_id
2153: FROM ben_person_actions
2154: WHERE benefit_action_id = p_benefit_action_id
2155: FOR UPDATE OF person_action_id;
2156: CURSOR c4 (
2157: p_benefit_action_id NUMBER

Line 2183: <>

2179: CLOSE c2;
2180: OPEN c3 (
2181: r1.benefit_action_id
2182: );
2183: <>
2184: LOOP
2185: FETCH c3 INTO l_id;
2186: EXIT WHEN c3%NOTFOUND;
2187: DELETE FROM ben_person_actions

Line 2187: DELETE FROM ben_person_actions

2183: <>
2184: LOOP
2185: FETCH c3 INTO l_id;
2186: EXIT WHEN c3%NOTFOUND;
2187: DELETE FROM ben_person_actions
2188: WHERE CURRENT OF c3;
2189: END LOOP ben_person_actions;
2190: CLOSE c3;
2191: OPEN c4 (

Line 2189: END LOOP ben_person_actions;

2185: FETCH c3 INTO l_id;
2186: EXIT WHEN c3%NOTFOUND;
2187: DELETE FROM ben_person_actions
2188: WHERE CURRENT OF c3;
2189: END LOOP ben_person_actions;
2190: CLOSE c3;
2191: OPEN c4 (
2192: r1.benefit_action_id
2193: );

Line 2355: ben_person_actions pat

2351: p_person_id NUMBER
2352: ) IS
2353: SELECT reporting_id
2354: FROM ben_reporting rep,
2355: ben_person_actions pat
2356: WHERE pat.person_id = p_person_id
2357: AND rep.benefit_action_id = pat.benefit_action_id /* Bug 4882374 : Perf */
2358: FOR UPDATE OF rep.reporting_id;
2359:

Line 2365: FROM ben_person_actions

2361: CURSOR c29 (
2362: p_person_id NUMBER
2363: ) IS
2364: SELECT person_action_id
2365: FROM ben_person_actions
2366: WHERE person_id = p_person_id
2367: FOR UPDATE OF person_action_id;
2368:
2369: --

Line 2716: <>

2712: CLOSE c28;
2713: OPEN c29 (
2714: p_person_id
2715: );
2716: <>
2717: LOOP
2718: FETCH c29 INTO l_id;
2719: EXIT WHEN c29%NOTFOUND;
2720: DELETE FROM ben_person_actions

Line 2720: DELETE FROM ben_person_actions

2716: <>
2717: LOOP
2718: FETCH c29 INTO l_id;
2719: EXIT WHEN c29%NOTFOUND;
2720: DELETE FROM ben_person_actions
2721: WHERE CURRENT OF c29;
2722: END LOOP ben_person_actions;
2723: CLOSE c29;
2724: OPEN c30 (

Line 2722: END LOOP ben_person_actions;

2718: FETCH c29 INTO l_id;
2719: EXIT WHEN c29%NOTFOUND;
2720: DELETE FROM ben_person_actions
2721: WHERE CURRENT OF c29;
2722: END LOOP ben_person_actions;
2723: CLOSE c29;
2724: OPEN c30 (
2725: p_person_id
2726: );