DBA Data[Home] [Help]

APPS.HR_PERSON_RECORD dependencies on PER_QUALIFICATIONS

Line 1370: PER_QUALIFICATIONS pq,per_qualification_types_tl tl,PER_ESTABLISHMENT_ATTENDANCES pea

1366: QUA_INFORMATION18,
1367: QUA_INFORMATION19,
1368: QUA_INFORMATION20
1369: FROM
1370: PER_QUALIFICATIONS pq,per_qualification_types_tl tl,PER_ESTABLISHMENT_ATTENDANCES pea
1371: WHERE (pq.person_id = p_person_id or pea.person_id = p_person_id)
1372: and pq.business_group_id = p_business_group_id
1373: and pq.attendance_id = pea.attendance_id(+)
1374: and tl.qualification_type_id = pq.qualification_type_id

Line 1619: ,per_qualifications pq

1615:
1616: select distinct ppf.person_id ,ppf.business_group_id,p_srch_criteria(i).p_effective_date
1617: from per_people_f ppf
1618: ,per_person_types ppt
1619: ,per_qualifications pq
1620: ,per_establishment_attendances pea
1621: where ppf.business_group_id = nvl(p_bus_group_id,ppf.business_group_id)
1622: and p_srch_criteria(i).p_effective_date between ppf.effective_start_date and ppf.effective_end_date
1623: and pq.attendance_id = pea.attendance_id(+)