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_BENEFIT_ACTIONS

Line 59: FROM ben_benefit_actions

55: CURSOR c26 (
56: p_person_id NUMBER
57: ) IS
58: SELECT 1
59: FROM ben_benefit_actions
60: WHERE person_id = p_person_id;
61: CURSOR c15 (
62: p_person_id NUMBER
63: ) IS

Line 427: -- Testing for values in BEN_BENEFIT_ACTIONS

423: --
424: CLOSE c25;
425:
426: --
427: -- Testing for values in BEN_BENEFIT_ACTIONS
428: --
429: OPEN c26 (
430: p_person_id
431: );

Line 443: 'BEN_BENEFIT_ACTIONS'

439: 'BEN_94121_DT_CHILD_EXISTS'
440: );
441: fnd_message.set_token (
442: 'TABLE_NAME',
443: 'BEN_BENEFIT_ACTIONS'
444: );
445: fnd_message.raise_error;
446: END IF;
447:

Line 2135: --** CN|c1|Fetch the benefit_action_id from ben_benefit_actions associated with a person_id for a particular business group.

2131: ) IS
2132:
2133: l_proc varchar2(100):= g_package||'delete_benefit_action_children';
2134: --** C|c1
2135: --** CN|c1|Fetch the benefit_action_id from ben_benefit_actions associated with a person_id for a particular business group.
2136: CURSOR c1 IS
2137: SELECT DISTINCT benefit_action_id
2138: FROM ben_benefit_actions
2139: WHERE person_id = p_person_id;

Line 2138: FROM ben_benefit_actions

2134: --** C|c1
2135: --** CN|c1|Fetch the benefit_action_id from ben_benefit_actions associated with a person_id for a particular business group.
2136: CURSOR c1 IS
2137: SELECT DISTINCT benefit_action_id
2138: FROM ben_benefit_actions
2139: WHERE person_id = p_person_id;
2140:
2141: --
2142: CURSOR c2 (

Line 2374: FROM ben_benefit_actions

2370: CURSOR c30 (
2371: p_person_id NUMBER
2372: ) IS
2373: SELECT benefit_action_id
2374: FROM ben_benefit_actions
2375: WHERE person_id = p_person_id
2376: FOR UPDATE OF benefit_action_id;
2377:
2378: --

Line 2727: <>

2723: CLOSE c29;
2724: OPEN c30 (
2725: p_person_id
2726: );
2727: <>
2728: LOOP
2729: FETCH c30 INTO l_id;
2730: EXIT WHEN c30%NOTFOUND;
2731: DELETE FROM ben_benefit_actions

Line 2731: DELETE FROM ben_benefit_actions

2727: <>
2728: LOOP
2729: FETCH c30 INTO l_id;
2730: EXIT WHEN c30%NOTFOUND;
2731: DELETE FROM ben_benefit_actions
2732: WHERE CURRENT OF c30;
2733: END LOOP ben_benefit_actions;
2734: CLOSE c30;
2735: OPEN c31 (

Line 2733: END LOOP ben_benefit_actions;

2729: FETCH c30 INTO l_id;
2730: EXIT WHEN c30%NOTFOUND;
2731: DELETE FROM ben_benefit_actions
2732: WHERE CURRENT OF c30;
2733: END LOOP ben_benefit_actions;
2734: CLOSE c30;
2735: OPEN c31 (
2736: p_person_id
2737: );