APPS.PER_SUPPLEMENTARY_ROLE_API dependencies on PER_ELECTION_CANDIDATES

Line 663: l_election_candidate_id per_election_candidates.election_candidate_id%TYPE;

659: --
660: -- Declare cursors and local variables
661: --
662: l_proc varchar2(72) := g_package||'delete_role';
663: l_election_candidate_id per_election_candidates.election_candidate_id%TYPE;
664: l_election_ovn per_election_candidates.object_version_number%TYPE;
665: l_election_role_id per_election_candidates.role_id%TYPE;
666: --
667: -- Cursor to select candidates to have the role id removed from

Line 664: l_election_ovn per_election_candidates.object_version_number%TYPE;

660: -- Declare cursors and local variables
661: --
662: l_proc varchar2(72) := g_package||'delete_role';
663: l_election_candidate_id per_election_candidates.election_candidate_id%TYPE;
664: l_election_ovn per_election_candidates.object_version_number%TYPE;
665: l_election_role_id per_election_candidates.role_id%TYPE;
666: --
667: -- Cursor to select candidates to have the role id removed from
668: --

Line 665: l_election_role_id per_election_candidates.role_id%TYPE;

661: --
662: l_proc varchar2(72) := g_package||'delete_role';
663: l_election_candidate_id per_election_candidates.election_candidate_id%TYPE;
664: l_election_ovn per_election_candidates.object_version_number%TYPE;
665: l_election_role_id per_election_candidates.role_id%TYPE;
666: --
667: -- Cursor to select candidates to have the role id removed from
668: --
669: cursor csr_candidate_update (p_role_id number) is

Line 671: from per_election_candidates

667: -- Cursor to select candidates to have the role id removed from
668: --
669: cursor csr_candidate_update (p_role_id number) is
670: select election_candidate_id, object_version_number
671: from per_election_candidates
672: where role_id = p_role_id;
673: --
674: begin
675: hr_utility.set_location('Entering:'|| l_proc, 5);