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_PER_DLVRY_MTHD_F

Line 127: FROM ben_per_dlvry_mthd_f

123: CURSOR c8 (
124: p_person_id NUMBER
125: ) IS
126: SELECT 1
127: FROM ben_per_dlvry_mthd_f
128: WHERE person_id = p_person_id;
129: CURSOR c12 (
130: p_person_id NUMBER
131: ) IS

Line 702: -- Testing for values in BEN_PER_DLVRY_MTHD_F

698: --
699: CLOSE c19;
700:
701: --
702: -- Testing for values in BEN_PER_DLVRY_MTHD_F
703: --
704: OPEN c8 (
705: p_person_id
706: );

Line 718: 'BEN_PER_DLVRY_MTHD_F'

714: 'BEN_94121_DT_CHILD_EXISTS'
715: );
716: fnd_message.set_token (
717: 'TABLE_NAME',
718: 'BEN_PER_DLVRY_MTHD_F'
719: );
720: fnd_message.raise_error;
721: END IF;
722:

Line 2466: FROM ben_per_dlvry_mthd_f

2462: CURSOR c40 (
2463: p_person_id NUMBER
2464: ) IS
2465: SELECT per_dlvry_mthd_id
2466: FROM ben_per_dlvry_mthd_f
2467: WHERE person_id = p_person_id
2468: FOR UPDATE OF per_dlvry_mthd_id;
2469:
2470: --

Line 2837: <>

2833: CLOSE c39;
2834: OPEN c40 (
2835: p_person_id
2836: );
2837: <>
2838: LOOP
2839: FETCH c40 INTO l_id;
2840: EXIT WHEN c40%NOTFOUND;
2841: DELETE FROM ben_per_dlvry_mthd_f

Line 2841: DELETE FROM ben_per_dlvry_mthd_f

2837: <>
2838: LOOP
2839: FETCH c40 INTO l_id;
2840: EXIT WHEN c40%NOTFOUND;
2841: DELETE FROM ben_per_dlvry_mthd_f
2842: WHERE CURRENT OF c40;
2843: END LOOP ben_per_dlvry_mthd_f;
2844: CLOSE c40;
2845: OPEN c41 (

Line 2843: END LOOP ben_per_dlvry_mthd_f;

2839: FETCH c40 INTO l_id;
2840: EXIT WHEN c40%NOTFOUND;
2841: DELETE FROM ben_per_dlvry_mthd_f
2842: WHERE CURRENT OF c40;
2843: END LOOP ben_per_dlvry_mthd_f;
2844: CLOSE c40;
2845: OPEN c41 (
2846: p_person_id
2847: );