APPS.BEN_PERSON_DELETE dependencies on BEN_PIL_ELCTBL_CHC_POPL

Line 1635: FROM ben_pil_elctbl_chc_popl

1631: CURSOR c29 (
1632: p_per_in_ler_id IN NUMBER
1633: ) IS
1634: SELECT pil_elctbl_chc_popl_id
1635: FROM ben_pil_elctbl_chc_popl
1636: WHERE per_in_ler_id = p_per_in_ler_id
1637: FOR UPDATE OF pil_elctbl_chc_popl_id;
1638:
1639: --

Line 1930: <>

1926: CLOSE c28;
1927: OPEN c29 (
1928: r1.per_in_ler_id
1929: );
1930: <>
1931: LOOP
1932: FETCH c29 INTO l_id;
1933: EXIT WHEN c29%NOTFOUND;
1934: DELETE FROM ben_pil_elctbl_chc_popl

Line 1934: DELETE FROM ben_pil_elctbl_chc_popl

1930: <>
1931: LOOP
1932: FETCH c29 INTO l_id;
1933: EXIT WHEN c29%NOTFOUND;
1934: DELETE FROM ben_pil_elctbl_chc_popl
1935: WHERE CURRENT OF c29;
1936: END LOOP ben_pil_elctbl_chc_popl;
1937: CLOSE c29;
1938: OPEN c30 (

Line 1936: END LOOP ben_pil_elctbl_chc_popl;

1932: FETCH c29 INTO l_id;
1933: EXIT WHEN c29%NOTFOUND;
1934: DELETE FROM ben_pil_elctbl_chc_popl
1935: WHERE CURRENT OF c29;
1936: END LOOP ben_pil_elctbl_chc_popl;
1937: CLOSE c29;
1938: OPEN c30 (
1939: r1.per_in_ler_id
1940: );

Line 2558: FROM ben_pil_elctbl_chc_popl

2554: CURSOR c49 (
2555: p_per_in_ler_id NUMBER
2556: ) IS
2557: SELECT PIL_ELCTBL_CHC_POPL_ID
2558: FROM ben_pil_elctbl_chc_popl
2559: WHERE per_in_ler_id = p_per_in_ler_id
2560: FOR UPDATE OF PIL_ELCTBL_CHC_POPL_ID;
2561:
2562:

Line 2862: <>

2858:
2859: DELETE FROM BEN_CWB_PERSON_TASKS WHERE group_per_in_ler_id=l_id;
2860:
2861: OPEN c49(l_id);
2862: <>
2863: LOOP
2864: FETCH c49 INTO l_pil_elctbl_chc_popl_id;
2865: EXIT WHEN c49%NOTFOUND;
2866: DELETE FROM BEN_CWB_HRCHY WHERE EMP_PIL_ELCTBL_CHC_POPL_ID = l_pil_elctbl_chc_popl_id;

Line 2867: END LOOP ben_pil_elctbl_chc_popl;

2863: LOOP
2864: FETCH c49 INTO l_pil_elctbl_chc_popl_id;
2865: EXIT WHEN c49%NOTFOUND;
2866: DELETE FROM BEN_CWB_HRCHY WHERE EMP_PIL_ELCTBL_CHC_POPL_ID = l_pil_elctbl_chc_popl_id;
2867: END LOOP ben_pil_elctbl_chc_popl;
2868: CLOSE c49;
2869:
2870: OPEN c50(l_id);
2871: <>