APPS.BEN_PERSON_DELETE dependencies on BEN_ELIG_PER_ELCTBL_CHC

Line 1507: FROM ben_elig_per_elctbl_chc b1, ben_enrt_bnft b2

1503: CURSOR c15 (
1504: p_per_in_ler_id IN NUMBER
1505: ) IS
1506: SELECT DISTINCT enrt_bnft_id
1507: FROM ben_elig_per_elctbl_chc b1, ben_enrt_bnft b2
1508: WHERE b1.per_in_ler_id = p_per_in_ler_id
1509: AND b2.elig_per_elctbl_chc_id =
1510: b1.elig_per_elctbl_chc_id;
1511:

Line 1523: --** CN|c17|Fetch the elig_per_elctbl_chc_id from ben_elig_per_elctbl_chc associated with a per_in_ler_id.

1519: FOR UPDATE OF enrt_rt_id;
1520:
1521: --
1522: --** C|c17|p_per_in_ler_id in number
1523: --** CN|c17|Fetch the elig_per_elctbl_chc_id from ben_elig_per_elctbl_chc associated with a per_in_ler_id.
1524: CURSOR c17 (
1525: p_per_in_ler_id IN NUMBER
1526: ) IS
1527: SELECT DISTINCT elig_per_elctbl_chc_id

Line 1528: FROM ben_elig_per_elctbl_chc

1524: CURSOR c17 (
1525: p_per_in_ler_id IN NUMBER
1526: ) IS
1527: SELECT DISTINCT elig_per_elctbl_chc_id
1528: FROM ben_elig_per_elctbl_chc
1529: WHERE per_in_ler_id = p_per_in_ler_id;
1530: CURSOR c18 (
1531: p_elig_per_elctbl_chc_id NUMBER
1532: ) IS

Line 1608: FROM ben_elig_per_elctbl_chc

1604: CURSOR c26 (
1605: p_per_in_ler_id IN NUMBER
1606: ) IS
1607: SELECT elig_per_elctbl_chc_id
1608: FROM ben_elig_per_elctbl_chc
1609: WHERE per_in_ler_id = p_per_in_ler_id
1610: FOR UPDATE OF elig_per_elctbl_chc_id;
1611:
1612: --

Line 1897: <>

1893: OPEN c26 (
1894: r1.per_in_ler_id
1895: );
1896: hr_utility.set_location(l_proc,90);
1897: <>
1898: LOOP
1899: FETCH c26 INTO l_id;
1900: EXIT WHEN c26%NOTFOUND;
1901: DELETE FROM ben_elig_per_elctbl_chc

Line 1901: DELETE FROM ben_elig_per_elctbl_chc

1897: <>
1898: LOOP
1899: FETCH c26 INTO l_id;
1900: EXIT WHEN c26%NOTFOUND;
1901: DELETE FROM ben_elig_per_elctbl_chc
1902: WHERE CURRENT OF c26;
1903: END LOOP ben_elig_per_elctbl_chc;
1904: CLOSE c26;
1905: OPEN c27 (

Line 1903: END LOOP ben_elig_per_elctbl_chc;

1899: FETCH c26 INTO l_id;
1900: EXIT WHEN c26%NOTFOUND;
1901: DELETE FROM ben_elig_per_elctbl_chc
1902: WHERE CURRENT OF c26;
1903: END LOOP ben_elig_per_elctbl_chc;
1904: CLOSE c26;
1905: OPEN c27 (
1906: r1.per_in_ler_id
1907: );

Line 2571: FROM BEN_ELIG_PER_ELCTBL_CHC

2567: CURSOR c50 (
2568: p_per_in_ler_id NUMBER
2569: ) IS
2570: SELECT ELIG_PER_ELCTBL_CHC_ID
2571: FROM BEN_ELIG_PER_ELCTBL_CHC
2572: WHERE per_in_ler_id = p_per_in_ler_id
2573: FOR UPDATE OF ELIG_PER_ELCTBL_CHC_ID;
2574:
2575: --

Line 2871: <>

2867: END LOOP ben_pil_elctbl_chc_popl;
2868: CLOSE c49;
2869:
2870: OPEN c50(l_id);
2871: <>
2872: LOOP
2873: FETCH c50 INTO l_elig_per_elctbl_chc_id;
2874: EXIT WHEN c50%NOTFOUND;
2875: DELETE FROM BEN_CWB_MGR_HRCHY WHERE EMP_ELIG_PER_ELCTBL_CHC_ID = l_elig_per_elctbl_chc_id;

Line 2877: END LOOP ben_elig_per_elctbl_chc;

2873: FETCH c50 INTO l_elig_per_elctbl_chc_id;
2874: EXIT WHEN c50%NOTFOUND;
2875: DELETE FROM BEN_CWB_MGR_HRCHY WHERE EMP_ELIG_PER_ELCTBL_CHC_ID = l_elig_per_elctbl_chc_id;
2876: DELETE FROM BEN_CWB_MGR_HRCHY_RBV WHERE EMP_ELIG_PER_ELCTBL_CHC_ID = l_elig_per_elctbl_chc_id;
2877: END LOOP ben_elig_per_elctbl_chc;
2878: CLOSE c50;
2879: -- End Bug 4653271
2880: DELETE FROM ben_per_in_ler
2881: WHERE CURRENT OF c41;