APPS.BEN_EPE_BUS dependencies on BEN_PER_IN_LER

Line 1144: from ben_per_in_ler a

1140: l_dummy varchar2(1);
1141: --
1142: cursor c1 is
1143: select null
1144: from ben_per_in_ler a
1145: where a.per_in_ler_id = p_per_in_ler_id
1146: and a.per_in_ler_stat_cd not in ('BCKDT', 'VOIDD');
1147: --
1148: Begin

Line 1162: -- check if per_in_ler_id value exists in ben_per_in_ler table, and that

1158: <> nvl(ben_epe_shd.g_old_rec.per_in_ler_id,hr_api.g_number)
1159: or not l_api_updating) and
1160: p_per_in_ler_id is not null then
1161: --
1162: -- check if per_in_ler_id value exists in ben_per_in_ler table, and that
1163: -- the status of the per-in-ler_id that is being updated is a valid one.
1164: --
1165: open c1;
1166: --

Line 1172: -- raise error as FK does not relate to PK in ben_per_in_ler

1168: if c1%notfound then
1169: --
1170: close c1;
1171: --
1172: -- raise error as FK does not relate to PK in ben_per_in_ler
1173: -- table.
1174: --
1175: ben_epe_shd.constraint_error('BEN_ELIG_PER_ELCTBL_CHC_DT6');
1176: --