APPS.IRC_UTILITIES_PKG dependencies on PER_PREVIOUS_EMPLOYERS

Line 119: l_employer PER_PREVIOUS_EMPLOYERS.EMPLOYER_NAME%TYPE;

115: RETURN VARCHAR2
116:
117: IS
118:
119: l_employer PER_PREVIOUS_EMPLOYERS.EMPLOYER_NAME%TYPE;
120:
121:
122: CURSOR c_current_employers(p_person_id PER_PREVIOUS_EMPLOYERS.PERSON_ID%TYPE,
123: p_date PER_PREVIOUS_EMPLOYERS.END_DATE%TYPE) IS

Line 122: CURSOR c_current_employers(p_person_id PER_PREVIOUS_EMPLOYERS.PERSON_ID%TYPE,

118:
119: l_employer PER_PREVIOUS_EMPLOYERS.EMPLOYER_NAME%TYPE;
120:
121:
122: CURSOR c_current_employers(p_person_id PER_PREVIOUS_EMPLOYERS.PERSON_ID%TYPE,
123: p_date PER_PREVIOUS_EMPLOYERS.END_DATE%TYPE) IS
124: SELECT empl.EMPLOYER_NAME
125: FROM PER_PREVIOUS_EMPLOYERS empl,
126: PER_ALL_PEOPLE_F ppf,

Line 123: p_date PER_PREVIOUS_EMPLOYERS.END_DATE%TYPE) IS

119: l_employer PER_PREVIOUS_EMPLOYERS.EMPLOYER_NAME%TYPE;
120:
121:
122: CURSOR c_current_employers(p_person_id PER_PREVIOUS_EMPLOYERS.PERSON_ID%TYPE,
123: p_date PER_PREVIOUS_EMPLOYERS.END_DATE%TYPE) IS
124: SELECT empl.EMPLOYER_NAME
125: FROM PER_PREVIOUS_EMPLOYERS empl,
126: PER_ALL_PEOPLE_F ppf,
127: PER_ALL_PEOPLE_F ppf2

Line 125: FROM PER_PREVIOUS_EMPLOYERS empl,

121:
122: CURSOR c_current_employers(p_person_id PER_PREVIOUS_EMPLOYERS.PERSON_ID%TYPE,
123: p_date PER_PREVIOUS_EMPLOYERS.END_DATE%TYPE) IS
124: SELECT empl.EMPLOYER_NAME
125: FROM PER_PREVIOUS_EMPLOYERS empl,
126: PER_ALL_PEOPLE_F ppf,
127: PER_ALL_PEOPLE_F ppf2
128: WHERE ppf.person_id = p_person_id
129: AND ppf.party_id = ppf2.party_id

Line 162: ,per_previous_employers ppe

158: IS
159: CURSOR c_current_employers IS
160: SELECT ppe.employer_name
161: FROM per_all_people_f ppf
162: ,per_previous_employers ppe
163: WHERE ppf.party_id = p_party_id
164: AND p_eff_date BETWEEN ppf.effective_start_date AND ppf.effective_end_date
165: AND p_eff_date BETWEEN ppe.start_date AND NVL(ppe.end_date,HR_GENERAL.end_of_time)
166: AND ppe.person_id = ppf.person_id