DBA Data[Home] [Help]

APPS.PER_HU_ABS_REP_ARCHIVE_PKG dependencies on PER_DISABILITIES_F

Line 1173: FROM per_disabilities_f pdf ,per_all_people_f papf, per_all_assignments_f paaf

1169: ,p_period_start_date DATE
1170: ,p_period_end_date DATE) RETURN NUMBER IS
1171: CURSOR csr_disability is
1172: SELECT pdf.effective_start_date,pdf.effective_end_date
1173: FROM per_disabilities_f pdf ,per_all_people_f papf, per_all_assignments_f paaf
1174: WHERE paaf.assignment_id=p_assignment_id
1175: AND paaf.business_group_id=p_business_group_id
1176: AND paaf.person_id=papf.person_id
1177: AND papf.person_id=pdf.person_id