APPS.BEN_PERSON_DELETE dependencies on BEN_PRTT_PREM_BY_MO_F

Line 1403: FROM ben_prtt_prem_by_mo_f

1399: CURSOR c3 (
1400: p_prtt_prem_id NUMBER
1401: ) IS
1402: SELECT prtt_prem_by_mo_id
1403: FROM ben_prtt_prem_by_mo_f
1404: WHERE prtt_prem_id = p_prtt_prem_id
1405: FOR UPDATE OF prtt_prem_by_mo_id;
1406: --** C|c4|p_person_id in number
1407: --** CN|c4|Fetch the prtt_enrt_rslt_id from ben_prtt_enrt_rslt_f associated with a per_in_ler_id.

Line 1668: <>

1664: ) LOOP
1665: OPEN c3 (
1666: r2.prtt_prem_id
1667: );
1668: <>
1669: LOOP
1670: FETCH c3 INTO l_id;
1671: EXIT WHEN c3%NOTFOUND;
1672: DELETE FROM ben_prtt_prem_by_mo_f

Line 1672: DELETE FROM ben_prtt_prem_by_mo_f

1668: <>
1669: LOOP
1670: FETCH c3 INTO l_id;
1671: EXIT WHEN c3%NOTFOUND;
1672: DELETE FROM ben_prtt_prem_by_mo_f
1673: WHERE CURRENT OF c3;
1674: END LOOP ben_prtt_prem_by_mo_f;
1675: CLOSE c3;
1676: END LOOP;

Line 1674: END LOOP ben_prtt_prem_by_mo_f;

1670: FETCH c3 INTO l_id;
1671: EXIT WHEN c3%NOTFOUND;
1672: DELETE FROM ben_prtt_prem_by_mo_f
1673: WHERE CURRENT OF c3;
1674: END LOOP ben_prtt_prem_by_mo_f;
1675: CLOSE c3;
1676: END LOOP;
1677: FOR r4 IN c4 (
1678: r1.per_in_ler_id