APPS.BEN_PERSON_DELETE dependencies on BEN_ELIG_PER_ELCTBL_CHC

Line 1564: FROM ben_elig_per_elctbl_chc b1, ben_enrt_bnft b2

1560: CURSOR c15 (
1561: p_per_in_ler_id IN NUMBER
1562: ) IS
1563: SELECT DISTINCT enrt_bnft_id
1564: FROM ben_elig_per_elctbl_chc b1, ben_enrt_bnft b2
1565: WHERE b1.per_in_ler_id = p_per_in_ler_id
1566: AND b2.elig_per_elctbl_chc_id =
1567: b1.elig_per_elctbl_chc_id;
1568:

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

1576: FOR UPDATE OF enrt_rt_id;
1577:
1578: --
1579: --** C|c17|p_per_in_ler_id in number
1580: --** CN|c17|Fetch the elig_per_elctbl_chc_id from ben_elig_per_elctbl_chc associated with a per_in_ler_id.
1581: CURSOR c17 (
1582: p_per_in_ler_id IN NUMBER
1583: ) IS
1584: SELECT DISTINCT elig_per_elctbl_chc_id

Line 1585: FROM ben_elig_per_elctbl_chc

1581: CURSOR c17 (
1582: p_per_in_ler_id IN NUMBER
1583: ) IS
1584: SELECT DISTINCT elig_per_elctbl_chc_id
1585: FROM ben_elig_per_elctbl_chc
1586: WHERE per_in_ler_id = p_per_in_ler_id;
1587: CURSOR c18 (
1588: p_elig_per_elctbl_chc_id NUMBER
1589: ) IS

Line 1665: FROM ben_elig_per_elctbl_chc

1661: CURSOR c26 (
1662: p_per_in_ler_id IN NUMBER
1663: ) IS
1664: SELECT elig_per_elctbl_chc_id
1665: FROM ben_elig_per_elctbl_chc
1666: WHERE per_in_ler_id = p_per_in_ler_id
1667: FOR UPDATE OF elig_per_elctbl_chc_id;
1668:
1669: --

Line 1954: <>

1950: OPEN c26 (
1951: r1.per_in_ler_id
1952: );
1953: hr_utility.set_location(l_proc,90);
1954: <>
1955: LOOP
1956: FETCH c26 INTO l_id;
1957: EXIT WHEN c26%NOTFOUND;
1958: DELETE FROM ben_elig_per_elctbl_chc

Line 1958: DELETE FROM ben_elig_per_elctbl_chc

1954: <>
1955: LOOP
1956: FETCH c26 INTO l_id;
1957: EXIT WHEN c26%NOTFOUND;
1958: DELETE FROM ben_elig_per_elctbl_chc
1959: WHERE CURRENT OF c26;
1960: END LOOP ben_elig_per_elctbl_chc;
1961: CLOSE c26;
1962: OPEN c27 (

Line 1960: END LOOP ben_elig_per_elctbl_chc;

1956: FETCH c26 INTO l_id;
1957: EXIT WHEN c26%NOTFOUND;
1958: DELETE FROM ben_elig_per_elctbl_chc
1959: WHERE CURRENT OF c26;
1960: END LOOP ben_elig_per_elctbl_chc;
1961: CLOSE c26;
1962: OPEN c27 (
1963: r1.per_in_ler_id
1964: );

Line 2682: FROM BEN_ELIG_PER_ELCTBL_CHC

2678: CURSOR c50 (
2679: p_per_in_ler_id NUMBER
2680: ) IS
2681: SELECT ELIG_PER_ELCTBL_CHC_ID
2682: FROM BEN_ELIG_PER_ELCTBL_CHC
2683: WHERE per_in_ler_id = nvl(p_per_in_ler_id,per_in_ler_id)
2684: FOR UPDATE OF ELIG_PER_ELCTBL_CHC_ID;
2685:
2686: --

Line 3002: <>

2998: END LOOP ben_pil_elctbl_chc_popl;
2999: CLOSE c49;
3000:
3001: OPEN c50(l_id);
3002: <>
3003: LOOP
3004: FETCH c50 INTO l_elig_per_elctbl_chc_id;
3005: EXIT WHEN c50%NOTFOUND;
3006: DELETE FROM BEN_CWB_MGR_HRCHY WHERE EMP_ELIG_PER_ELCTBL_CHC_ID = l_elig_per_elctbl_chc_id;

Line 3008: END LOOP ben_elig_per_elctbl_chc;

3004: FETCH c50 INTO l_elig_per_elctbl_chc_id;
3005: EXIT WHEN c50%NOTFOUND;
3006: DELETE FROM BEN_CWB_MGR_HRCHY WHERE EMP_ELIG_PER_ELCTBL_CHC_ID = l_elig_per_elctbl_chc_id;
3007: DELETE FROM BEN_CWB_MGR_HRCHY_RBV WHERE EMP_ELIG_PER_ELCTBL_CHC_ID = l_elig_per_elctbl_chc_id;
3008: END LOOP ben_elig_per_elctbl_chc;
3009: CLOSE c50;
3010: -- End Bug 4653271
3011: DELETE FROM ben_per_in_ler
3012: WHERE CURRENT OF c41;