APPS.HR_PREVIOUS_EMPLOYMENT_SWI dependencies on PER_ALL_PEOPLE_F

Line 104: l_party_id per_all_people_f.party_id%type := p_party_id;

100: --
101: -- Other variables
102: l_previous_employer_id number;
103: l_proc varchar2(72) := g_package ||'create_previous_employer';
104: l_party_id per_all_people_f.party_id%type := p_party_id;
105: --
106: cursor csr_get_party_id is
107: select party_id
108: from per_all_people_f per

Line 108: from per_all_people_f per

104: l_party_id per_all_people_f.party_id%type := p_party_id;
105: --
106: cursor csr_get_party_id is
107: select party_id
108: from per_all_people_f per
109: where per.person_id = p_person_id
110: and trunc(p_effective_date)
111: between per.effective_start_date
112: and per.effective_end_date;