APPS.BEN_PERSON_DELETE dependencies on BEN_PRTT_PREM_BY_MO_F

Line 1460: FROM ben_prtt_prem_by_mo_f

1456: CURSOR c3 (
1457: p_prtt_prem_id NUMBER
1458: ) IS
1459: SELECT prtt_prem_by_mo_id
1460: FROM ben_prtt_prem_by_mo_f
1461: WHERE prtt_prem_id = p_prtt_prem_id
1462: FOR UPDATE OF prtt_prem_by_mo_id;
1463: --** C|c4|p_person_id in number
1464: --** CN|c4|Fetch the prtt_enrt_rslt_id from ben_prtt_enrt_rslt_f associated with a per_in_ler_id.

Line 1725: <>

1721: ) LOOP
1722: OPEN c3 (
1723: r2.prtt_prem_id
1724: );
1725: <>
1726: LOOP
1727: FETCH c3 INTO l_id;
1728: EXIT WHEN c3%NOTFOUND;
1729: DELETE FROM ben_prtt_prem_by_mo_f

Line 1729: DELETE FROM ben_prtt_prem_by_mo_f

1725: <>
1726: LOOP
1727: FETCH c3 INTO l_id;
1728: EXIT WHEN c3%NOTFOUND;
1729: DELETE FROM ben_prtt_prem_by_mo_f
1730: WHERE CURRENT OF c3;
1731: END LOOP ben_prtt_prem_by_mo_f;
1732: CLOSE c3;
1733: END LOOP;

Line 1731: END LOOP ben_prtt_prem_by_mo_f;

1727: FETCH c3 INTO l_id;
1728: EXIT WHEN c3%NOTFOUND;
1729: DELETE FROM ben_prtt_prem_by_mo_f
1730: WHERE CURRENT OF c3;
1731: END LOOP ben_prtt_prem_by_mo_f;
1732: CLOSE c3;
1733: END LOOP;
1734: FOR r4 IN c4 (
1735: r1.per_in_ler_id