APPS.BEN_PERSON_DELETE dependencies on BEN_REPORTING

Line 224: FROM ben_reporting rep,

220: CURSOR c28 (
221: p_person_id NUMBER
222: ) IS
223: SELECT 1
224: FROM ben_reporting rep,
225: ben_person_actions pat
226: WHERE pat.person_id = p_person_id
227: AND rep.benefit_action_id = pat.benefit_action_id; /* Bug 4882374 : Perf */
228: CURSOR c29 (

Line 951: -- Testing for values in BEN_REPORTING

947: --
948: CLOSE c13;
949:
950: --
951: -- Testing for values in BEN_REPORTING
952: --
953: OPEN c28 (
954: p_person_id
955: );

Line 967: 'BEN_REPORTING'

963: 'BEN_94121_DT_CHILD_EXISTS'
964: );
965: fnd_message.set_token (
966: 'TABLE_NAME',
967: 'BEN_REPORTING'
968: );
969: fnd_message.raise_error;
970: END IF;
971:

Line 2212: FROM ben_reporting

2208: CURSOR c2 (
2209: p_benefit_action_id NUMBER
2210: ) IS
2211: SELECT reporting_id
2212: FROM ben_reporting
2213: WHERE benefit_action_id = p_benefit_action_id
2214: FOR UPDATE OF reporting_id;
2215: CURSOR c3 (
2216: p_benefit_action_id NUMBER

Line 2238: <>

2234: FOR r1 IN c1 LOOP
2235: OPEN c2 (
2236: r1.benefit_action_id
2237: );
2238: <>
2239: LOOP
2240: FETCH c2 INTO l_id;
2241: EXIT WHEN c2%NOTFOUND;
2242: DELETE FROM ben_reporting

Line 2242: DELETE FROM ben_reporting

2238: <>
2239: LOOP
2240: FETCH c2 INTO l_id;
2241: EXIT WHEN c2%NOTFOUND;
2242: DELETE FROM ben_reporting
2243: WHERE CURRENT OF c2;
2244: END LOOP ben_reporting;
2245: CLOSE c2;
2246: OPEN c3 (

Line 2244: END LOOP ben_reporting;

2240: FETCH c2 INTO l_id;
2241: EXIT WHEN c2%NOTFOUND;
2242: DELETE FROM ben_reporting
2243: WHERE CURRENT OF c2;
2244: END LOOP ben_reporting;
2245: CLOSE c2;
2246: OPEN c3 (
2247: r1.benefit_action_id
2248: );

Line 2332: FROM ben_reporting

2328: CURSOR c01 (
2329: p_benefit_action_id IN NUMBER
2330: ) IS
2331: SELECT benefit_action_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.

Line 2449: FROM ben_reporting rep,

2445: CURSOR c28 (
2446: p_person_id NUMBER
2447: ) IS
2448: SELECT reporting_id
2449: FROM ben_reporting rep,
2450: ben_person_actions pat,
2451: ben_benefit_actions b
2452: WHERE pat.person_id = p_person_id
2453: and pat.BENEFIT_ACTION_ID = b.BENEFIT_ACTION_ID

Line 2828: <>

2824: CLOSE c27;
2825: OPEN c28 (
2826: p_person_id
2827: );
2828: <>
2829: LOOP
2830: FETCH c28 INTO l_id;
2831: EXIT WHEN c28%NOTFOUND;
2832: DELETE FROM ben_reporting

Line 2832: DELETE FROM ben_reporting

2828: <>
2829: LOOP
2830: FETCH c28 INTO l_id;
2831: EXIT WHEN c28%NOTFOUND;
2832: DELETE FROM ben_reporting
2833: WHERE CURRENT OF c28;
2834: END LOOP ben_reporting;
2835: CLOSE c28;
2836: OPEN c29 (

Line 2834: END LOOP ben_reporting;

2830: FETCH c28 INTO l_id;
2831: EXIT WHEN c28%NOTFOUND;
2832: DELETE FROM ben_reporting
2833: WHERE CURRENT OF c28;
2834: END LOOP ben_reporting;
2835: CLOSE c28;
2836: OPEN c29 (
2837: p_person_id
2838: );