DBA Data[Home] [Help]

APPS.PAY_AE_SI_REPORTS dependencies on PER_DISABILITIES_F

Line 264: FROM per_disabilities_f dis

260:
261: /* Cursor for fetching person's Disability */
262: CURSOR csr_p_disability_data (l_person_id number,l_effective_date date) IS
263: SELECT substr(dis.reason,1,60),dis.degree,dis.effective_start_date
264: FROM per_disabilities_f dis
265: WHERE dis.person_id = l_person_id
266: AND l_effective_date between dis.effective_start_date and dis.effective_end_date
267: -- AND dis.status = 'A'
268: AND dis.dis_information1 = 'Y';