APPS.BEN_PERSON_DELETE dependencies on BEN_REPORTING

Line 175: FROM ben_reporting rep,

171: CURSOR c28 (
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 (

Line 902: -- Testing for values in BEN_REPORTING

898: --
899: CLOSE c13;
900:
901: --
902: -- Testing for values in BEN_REPORTING
903: --
904: OPEN c28 (
905: p_person_id
906: );

Line 918: 'BEN_REPORTING'

914: 'BEN_94121_DT_CHILD_EXISTS'
915: );
916: fnd_message.set_token (
917: 'TABLE_NAME',
918: 'BEN_REPORTING'
919: );
920: fnd_message.raise_error;
921: END IF;
922:

Line 2146: FROM ben_reporting

2142: CURSOR c2 (
2143: p_benefit_action_id NUMBER
2144: ) IS
2145: SELECT reporting_id
2146: FROM ben_reporting
2147: WHERE benefit_action_id = p_benefit_action_id
2148: FOR UPDATE OF reporting_id;
2149: CURSOR c3 (
2150: p_benefit_action_id NUMBER

Line 2172: <>

2168: FOR r1 IN c1 LOOP
2169: OPEN c2 (
2170: r1.benefit_action_id
2171: );
2172: <>
2173: LOOP
2174: FETCH c2 INTO l_id;
2175: EXIT WHEN c2%NOTFOUND;
2176: DELETE FROM ben_reporting

Line 2176: DELETE FROM ben_reporting

2172: <>
2173: LOOP
2174: FETCH c2 INTO l_id;
2175: EXIT WHEN c2%NOTFOUND;
2176: DELETE FROM ben_reporting
2177: WHERE CURRENT OF c2;
2178: END LOOP ben_reporting;
2179: CLOSE c2;
2180: OPEN c3 (

Line 2178: END LOOP ben_reporting;

2174: FETCH c2 INTO l_id;
2175: EXIT WHEN c2%NOTFOUND;
2176: DELETE FROM ben_reporting
2177: WHERE CURRENT OF c2;
2178: END LOOP ben_reporting;
2179: CLOSE c2;
2180: OPEN c3 (
2181: r1.benefit_action_id
2182: );

Line 2262: FROM ben_reporting

2258: CURSOR c01 (
2259: p_benefit_action_id IN NUMBER
2260: ) IS
2261: SELECT benefit_action_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.

Line 2354: FROM ben_reporting rep,

2350: CURSOR c28 (
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;

Line 2705: <>

2701: CLOSE c27;
2702: OPEN c28 (
2703: p_person_id
2704: );
2705: <>
2706: LOOP
2707: FETCH c28 INTO l_id;
2708: EXIT WHEN c28%NOTFOUND;
2709: DELETE FROM ben_reporting

Line 2709: DELETE FROM ben_reporting

2705: <>
2706: LOOP
2707: FETCH c28 INTO l_id;
2708: EXIT WHEN c28%NOTFOUND;
2709: DELETE FROM ben_reporting
2710: WHERE CURRENT OF c28;
2711: END LOOP ben_reporting;
2712: CLOSE c28;
2713: OPEN c29 (

Line 2711: END LOOP ben_reporting;

2707: FETCH c28 INTO l_id;
2708: EXIT WHEN c28%NOTFOUND;
2709: DELETE FROM ben_reporting
2710: WHERE CURRENT OF c28;
2711: END LOOP ben_reporting;
2712: CLOSE c28;
2713: OPEN c29 (
2714: p_person_id
2715: );