DBA Data[Home] [Help]

APPS.PER_ECO_BUS dependencies on PER_ELECTION_CANDIDATES

Line 228: from per_election_candidates pec

224: --
225: --
226: cursor csr_valid_can_exists is
227: select pec.election_id
228: from per_election_candidates pec
229: where pec.election_id = p_election_id;
230: --
231: begin
232: hr_utility.set_location(l_proc, 20);

Line 237: -- valid candidate on per_election_candidates

233: --
234: hr_utility.set_location(l_proc, 30);
235: --
236: -- Check that the Election ID is not linked to a
237: -- valid candidate on per_election_candidates
238: --
239: open csr_valid_can_exists;
240: fetch csr_valid_can_exists into l_election_id_a;
241: if csr_valid_can_exists%found then