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_PTNL_LER_FOR_PER

Line 169: FROM ben_ptnl_ler_for_per

165: CURSOR c13 (
166: p_person_id NUMBER
167: ) IS
168: SELECT 1
169: FROM ben_ptnl_ler_for_per
170: WHERE person_id = p_person_id;
171: CURSOR c28 (
172: p_person_id NUMBER
173: ) IS

Line 877: -- Testing for values in BEN_PTNL_LER_FOR_PER

873: --
874: CLOSE c18;
875:
876: --
877: -- Testing for values in BEN_PTNL_LER_FOR_PER
878: --
879: OPEN c13 (
880: p_person_id
881: );

Line 893: 'BEN_PTNL_LER_FOR_PER'

889: 'BEN_94121_DT_CHILD_EXISTS'
890: );
891: fnd_message.set_token (
892: 'TABLE_NAME',
893: 'BEN_PTNL_LER_FOR_PER'
894: );
895: fnd_message.raise_error;
896: END IF;
897:

Line 2511: FROM ben_ptnl_ler_for_per

2507: CURSOR c45 (
2508: p_person_id NUMBER
2509: ) IS
2510: SELECT ptnl_ler_for_per_id
2511: FROM ben_ptnl_ler_for_per
2512: WHERE person_id = p_person_id
2513: FOR UPDATE OF ptnl_ler_for_per_id;
2514:
2515: --

Line 2931: <>

2927:
2928: OPEN c45 (
2929: p_person_id
2930: );
2931: <>
2932: LOOP
2933: FETCH c45 INTO l_id;
2934: EXIT WHEN c45%NOTFOUND;
2935: DELETE FROM ben_ptnl_ler_for_per

Line 2935: DELETE FROM ben_ptnl_ler_for_per

2931: <>
2932: LOOP
2933: FETCH c45 INTO l_id;
2934: EXIT WHEN c45%NOTFOUND;
2935: DELETE FROM ben_ptnl_ler_for_per
2936: WHERE CURRENT OF c45;
2937: END LOOP ben_ptnl_ler_for_per;
2938: CLOSE c45;
2939: OPEN c46 (

Line 2937: END LOOP ben_ptnl_ler_for_per;

2933: FETCH c45 INTO l_id;
2934: EXIT WHEN c45%NOTFOUND;
2935: DELETE FROM ben_ptnl_ler_for_per
2936: WHERE CURRENT OF c45;
2937: END LOOP ben_ptnl_ler_for_per;
2938: CLOSE c45;
2939: OPEN c46 (
2940: p_person_id
2941: );