DBA Data[Home] [Help]

APPS.HR_PERSON_RECORD dependencies on PER_ESTABLISHMENT_ATTENDANCES

Line 1349: PER_QUALIFICATIONS pq,per_qualification_types_tl tl,PER_ESTABLISHMENT_ATTENDANCES pea

1345: QUA_INFORMATION18,
1346: QUA_INFORMATION19,
1347: QUA_INFORMATION20
1348: FROM
1349: PER_QUALIFICATIONS pq,per_qualification_types_tl tl,PER_ESTABLISHMENT_ATTENDANCES pea
1350: WHERE (pq.person_id = p_person_id or pea.person_id = p_person_id)
1351: and pq.business_group_id = p_business_group_id
1352: and pq.attendance_id = pea.attendance_id(+)
1353: and tl.qualification_type_id = pq.qualification_type_id

Line 2461: ,per_establishment_attendances pea

2457: select distinct ppf.person_id ,ppf.business_group_id,p_srch_criteria(i).p_effective_date
2458: from per_people_f ppf
2459: ,per_person_types ppt
2460: ,per_qualifications pq
2461: ,per_establishment_attendances pea
2462: where ppf.business_group_id = nvl(p_bus_group_id,ppf.business_group_id)
2463: and p_srch_criteria(i).p_effective_date between ppf.effective_start_date and ppf.effective_end_date
2464: and pq.attendance_id = pea.attendance_id(+)
2465: and (pq.person_id = ppf.person_id or pea.person_id = ppf.person_id)