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_ELIG_CVRD_DPNT_F

Line 183: FROM ben_elig_cvrd_dpnt_f

179: CURSOR c29 (
180: p_person_id NUMBER
181: ) IS
182: SELECT 1
183: FROM ben_elig_cvrd_dpnt_f
184: WHERE dpnt_person_id = p_person_id;
185: CURSOR c30 (
186: p_person_id NUMBER
187: ) IS

Line 926: -- Testing for values in BEN_ELIG_CVRD_DPNT_F

922:
923: --
924: CLOSE c28;
925: --
926: -- Testing for values in BEN_ELIG_CVRD_DPNT_F
927: --
928: OPEN c29 (
929: p_person_id
930: );

Line 942: 'BEN_ELIG_CVRD_DPNT_F'

938: 'BEN_94121_DT_CHILD_EXISTS'
939: );
940: fnd_message.set_token (
941: 'TABLE_NAME',
942: 'BEN_ELIG_CVRD_DPNT_F'
943: );
944: fnd_message.raise_error;
945: END IF;
946:

Line 1099: FROM ben_elig_cvrd_dpnt_f

1095: l_proc varchar2(100):= g_package||'delete_dependent_information';
1096: --
1097: CURSOR c_ecd IS
1098: SELECT elig_cvrd_dpnt_id, dpnt_person_id
1099: FROM ben_elig_cvrd_dpnt_f
1100: WHERE dpnt_person_id = p_person_id
1101: FOR UPDATE OF elig_cvrd_dpnt_id,dpnt_person_id;
1102:
1103: --

Line 1153: FROM ben_elig_cvrd_dpnt_f

1149: CURSOR c4 (
1150: p_elig_cvrd_dpnt_id NUMBER
1151: ) IS
1152: SELECT elig_cvrd_dpnt_id
1153: FROM ben_elig_cvrd_dpnt_f
1154: WHERE elig_cvrd_dpnt_id = p_elig_cvrd_dpnt_id
1155: FOR UPDATE OF elig_cvrd_dpnt_id;
1156:
1157: --

Line 1250: <>

1246: hr_utility.set_location(l_proc, 35);
1247: /* OPEN c4 (
1248: l_ecd.elig_cvrd_dpnt_id
1249: );
1250: <>
1251: LOOP
1252: FETCH c4 INTO l_id;
1253: EXIT WHEN c4%NOTFOUND;
1254: DELETE ben_elig_cvrd_dpnt_f

Line 1254: DELETE ben_elig_cvrd_dpnt_f

1250: <>
1251: LOOP
1252: FETCH c4 INTO l_id;
1253: EXIT WHEN c4%NOTFOUND;
1254: DELETE ben_elig_cvrd_dpnt_f
1255: WHERE CURRENT OF c4;
1256: END LOOP ben_elig_cvrd_dpnt_f;
1257: CLOSE c4; */
1258: hr_utility.set_location(l_proc, 40);

Line 1256: END LOOP ben_elig_cvrd_dpnt_f;

1252: FETCH c4 INTO l_id;
1253: EXIT WHEN c4%NOTFOUND;
1254: DELETE ben_elig_cvrd_dpnt_f
1255: WHERE CURRENT OF c4;
1256: END LOOP ben_elig_cvrd_dpnt_f;
1257: CLOSE c4; */
1258: hr_utility.set_location(l_proc, 40);
1259: OPEN c5 (
1260: l_ecd.elig_cvrd_dpnt_id

Line 1294: DELETE ben_elig_cvrd_dpnt_f

1290: DELETE ben_elig_dpnt
1291: WHERE CURRENT OF c7;
1292: END LOOP ben_elig_dpnt;
1293: CLOSE c7;
1294: DELETE ben_elig_cvrd_dpnt_f
1295: WHERE CURRENT OF c_ecd;
1296: END LOOP;
1297: hr_utility.set_location('Leaving: '||l_proc,999);
1298: END delete_dependent_information;

Line 1438: FROM ben_elig_cvrd_dpnt_f

1434: CURSOR c7 (
1435: p_prtt_enrt_rslt_id NUMBER
1436: ) IS
1437: SELECT elig_cvrd_dpnt_id
1438: FROM ben_elig_cvrd_dpnt_f
1439: WHERE prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
1440: FOR UPDATE OF elig_cvrd_dpnt_id;
1441:
1442: --

Line 1705: <>

1701: CLOSE c6;
1702: OPEN c7 (
1703: r4.prtt_enrt_rslt_id
1704: );
1705: <>
1706: LOOP
1707: FETCH c7 INTO l_id;
1708: EXIT WHEN c7%NOTFOUND;
1709: DELETE FROM ben_elig_cvrd_dpnt_f

Line 1709: DELETE FROM ben_elig_cvrd_dpnt_f

1705: <>
1706: LOOP
1707: FETCH c7 INTO l_id;
1708: EXIT WHEN c7%NOTFOUND;
1709: DELETE FROM ben_elig_cvrd_dpnt_f
1710: WHERE CURRENT OF c7;
1711: END LOOP ben_elig_cvrd_dpnt_f;
1712: CLOSE c7;
1713: OPEN c8 (

Line 1711: END LOOP ben_elig_cvrd_dpnt_f;

1707: FETCH c7 INTO l_id;
1708: EXIT WHEN c7%NOTFOUND;
1709: DELETE FROM ben_elig_cvrd_dpnt_f
1710: WHERE CURRENT OF c7;
1711: END LOOP ben_elig_cvrd_dpnt_f;
1712: CLOSE c7;
1713: OPEN c8 (
1714: r4.prtt_enrt_rslt_id
1715: );

Line 2003: FROM ben_elig_cvrd_dpnt_f

1999: CURSOR c4 (
2000: p_prtt_enrt_rslt_id NUMBER
2001: ) IS
2002: SELECT elig_cvrd_dpnt_id
2003: FROM ben_elig_cvrd_dpnt_f
2004: WHERE prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
2005: FOR UPDATE OF elig_cvrd_dpnt_id;
2006:
2007: --

Line 2072: <>

2068: CLOSE c3;
2069: OPEN c4 (
2070: r1.prtt_enrt_rslt_id
2071: );
2072: <>
2073: LOOP
2074: FETCH c4 INTO l_id;
2075: EXIT WHEN c4%NOTFOUND;
2076: DELETE FROM ben_elig_cvrd_dpnt_f

Line 2076: DELETE FROM ben_elig_cvrd_dpnt_f

2072: <>
2073: LOOP
2074: FETCH c4 INTO l_id;
2075: EXIT WHEN c4%NOTFOUND;
2076: DELETE FROM ben_elig_cvrd_dpnt_f
2077: WHERE CURRENT OF c4;
2078: END LOOP ben_elig_cvrd_dpnt_f;
2079: CLOSE c4;
2080: OPEN c5 (

Line 2078: END LOOP ben_elig_cvrd_dpnt_f;

2074: FETCH c4 INTO l_id;
2075: EXIT WHEN c4%NOTFOUND;
2076: DELETE FROM ben_elig_cvrd_dpnt_f
2077: WHERE CURRENT OF c4;
2078: END LOOP ben_elig_cvrd_dpnt_f;
2079: CLOSE c4;
2080: OPEN c5 (
2081: r1.prtt_enrt_rslt_id
2082: );

Line 3056: FROM ben_elig_cvrd_dpnt_f ecd,

3052: CURSOR c_ecd( p_person_id number ,
3053: p_effective_date date
3054: ) is
3055: SELECT 'Y'
3056: FROM ben_elig_cvrd_dpnt_f ecd,
3057: ben_per_in_ler pil,
3058: ben_ler_f ler,
3059: ben_prtt_enrt_rslt_f pen
3060: WHERE

Line 3080: FROM ben_elig_cvrd_dpnt_f ecd,

3076: CURSOR c_ecdpn( p_person_id number ,
3077: p_effective_date date
3078: ) is
3079: SELECT 'Y'
3080: FROM ben_elig_cvrd_dpnt_f ecd,
3081: ben_per_in_ler pil,
3082: ben_ler_f ler,
3083: ben_prtt_enrt_rslt_f pen
3084: WHERE