APPS.PAY_AE_SI_REPORTS dependencies on PER_PREVIOUS_EMPLOYERS

Line 228: FROM per_previous_employers pr

224:
225: /* Cursor for fetching the person's ex-employer's name */
226: CURSOR csr_p_ex_emp_data (l_person_id number) IS
227: SELECT pr.employer_name ,pr.previous_employer_id,pr.employer_type, pr.PEM_INFORMATION1 , fnd_date.canonical_to_date(pr.PEM_INFORMATION2),pr.PEM_INFORMATION3,pr.PEM_INFORMATION4
228: FROM per_previous_employers pr
229: WHERE pr.person_id = l_person_id
230: AND pr.PEM_INFORMATION_CATEGORY ='AE'
231: AND nvl(pr.end_date,sysdate) in (SELECT nvl(max(end_date),sysdate)
232: FROM per_previous_employers

Line 232: FROM per_previous_employers

228: FROM per_previous_employers pr
229: WHERE pr.person_id = l_person_id
230: AND pr.PEM_INFORMATION_CATEGORY ='AE'
231: AND nvl(pr.end_date,sysdate) in (SELECT nvl(max(end_date),sysdate)
232: FROM per_previous_employers
233: WHERE person_id = l_person_id ) order by nvl(start_date,sysdate) desc,employer_name desc ;
234:
235: /* Cursor for fetching the person's spouse's ex-employer's name */
236: CURSOR csr_p_s_ex_emp_data (l_person_id number) IS

Line 238: FROM per_previous_employers pr

234:
235: /* Cursor for fetching the person's spouse's ex-employer's name */
236: CURSOR csr_p_s_ex_emp_data (l_person_id number) IS
237: SELECT pr.employer_name ,pr.previous_employer_id
238: FROM per_previous_employers pr
239: WHERE pr.person_id = l_person_id
240: AND nvl(pr.end_date,sysdate) in (SELECT nvl(max(end_date),sysdate)
241: FROM per_previous_employers
242: WHERE person_id = l_person_id ) order by nvl(start_date,sysdate) desc,employer_name desc ;

Line 241: FROM per_previous_employers

237: SELECT pr.employer_name ,pr.previous_employer_id
238: FROM per_previous_employers pr
239: WHERE pr.person_id = l_person_id
240: AND nvl(pr.end_date,sysdate) in (SELECT nvl(max(end_date),sysdate)
241: FROM per_previous_employers
242: WHERE person_id = l_person_id ) order by nvl(start_date,sysdate) desc,employer_name desc ;
243:
244: /* Cursor for fetching the person's ex-employer's transfer date */
245: CURSOR csr_p_ex_emp_date_data (l_person_id number,l_ex_emp_id number) IS

Line 247: FROM per_previous_employers pr

243:
244: /* Cursor for fetching the person's ex-employer's transfer date */
245: CURSOR csr_p_ex_emp_date_data (l_person_id number,l_ex_emp_id number) IS
246: SELECT pr.end_date
247: FROM per_previous_employers pr
248: WHERE pr.person_id = l_person_id
249: AND pr.previous_employer_id = l_ex_emp_id
250: AND pr.employer_type = 'FG'
251: AND pr.PEM_INFORMATION1 = 'EMP_TRANS';