APPS.BEN_PERSON_DELETE dependencies on BEN_LE_CLSN_N_RSTR

Line 150: FROM ben_le_clsn_n_rstr lct,

146: CURSOR c11 (
147: p_person_id NUMBER
148: ) IS
149: SELECT 1
150: FROM ben_le_clsn_n_rstr lct,
151: ben_per_in_ler pil
152: WHERE pil.person_id = p_person_id
153: AND pil.per_in_ler_id = lct.per_in_ler_id; /* Bug 4882374 : Perf */
154: CURSOR c27 (

Line 651: -- Testing for values in BEN_LE_CLSN_N_RSTR

647: --
648: CLOSE c7;
649:
650: --
651: -- Testing for values in BEN_LE_CLSN_N_RSTR
652: --
653: OPEN c11 (
654: p_person_id
655: );

Line 667: 'BEN_LE_CLSN_N_RSTR'

663: 'BEN_94121_DT_CHILD_EXISTS'
664: );
665: fnd_message.set_token (
666: 'TABLE_NAME',
667: 'BEN_LE_CLSN_N_RSTR'
668: );
669: fnd_message.raise_error;
670: END IF;
671:

Line 1683: FROM ben_le_clsn_n_rstr

1679: CURSOR c28 (
1680: p_per_in_ler_id IN NUMBER
1681: ) IS
1682: SELECT bkup_tbl_id
1683: FROM ben_le_clsn_n_rstr
1684: WHERE per_in_ler_id = p_per_in_ler_id
1685: FOR UPDATE OF bkup_tbl_id;
1686:
1687: --

Line 1976: <>

1972: CLOSE c27;
1973: OPEN c28 (
1974: r1.per_in_ler_id
1975: );
1976: <>
1977: LOOP
1978: FETCH c28 INTO l_id;
1979: EXIT WHEN c28%NOTFOUND;
1980: DELETE FROM ben_le_clsn_n_rstr

Line 1980: DELETE FROM ben_le_clsn_n_rstr

1976: <>
1977: LOOP
1978: FETCH c28 INTO l_id;
1979: EXIT WHEN c28%NOTFOUND;
1980: DELETE FROM ben_le_clsn_n_rstr
1981: WHERE CURRENT OF c28;
1982: END LOOP ben_le_clsn_n_rstr;
1983: CLOSE c28;
1984: OPEN c29 (

Line 1982: END LOOP ben_le_clsn_n_rstr;

1978: FETCH c28 INTO l_id;
1979: EXIT WHEN c28%NOTFOUND;
1980: DELETE FROM ben_le_clsn_n_rstr
1981: WHERE CURRENT OF c28;
1982: END LOOP ben_le_clsn_n_rstr;
1983: CLOSE c28;
1984: OPEN c29 (
1985: r1.per_in_ler_id
1986: );