APPS.BEN_COP_BUS dependencies on BEN_OIPL_F

Line 1955: FROM ben_oipl_f cop

1951: l_exists varchar2(1);
1952: --
1953: CURSOR c1 IS
1954: SELECT NULL
1955: FROM ben_oipl_f cop
1956: WHERE cop.opt_id = p_opt_id
1957: AND cop.pl_id = p_pl_id
1958: AND cop.oipl_id <> nvl(p_oipl_id, hr_api.g_number)
1959: AND cop.business_group_id = p_business_group_id

Line 2059: from ben_oipl_f

2055: l_exists varchar2(1);
2056: --
2057: cursor c1 is
2058: select null
2059: from ben_oipl_f
2060: where ordr_num = p_ordr_num
2061: and pl_id = p_pl_id
2062: and oipl_id <> nvl(p_oipl_id, hr_api.g_number)
2063: and business_group_id + 0 = p_business_group_id

Line 2307: from ben_oipl_f cop

2303: l_Dummy number;
2304: --
2305: cursor c1 is
2306: select cop.opt_id
2307: from ben_oipl_f cop
2308: where cop.oipl_id = p_oipl_id;
2309: --
2310: cursor c_epe is
2311: select null

Line 2929: ben_oipl_f b

2925: --
2926: cursor csr_leg_code is
2927: select a.legislation_code
2928: from per_business_groups a,
2929: ben_oipl_f b
2930: where b.oipl_id = p_oipl_id
2931: and a.business_group_id = b.business_group_id;
2932: --
2933: -- Declare local variables