DBA Data[Home] [Help]

APPS.IRC_UTILITIES_PKG dependencies on PER_ESTABLISHMENT_ATTENDANCES

Line 216: PER_ESTABLISHMENT_ATTENDANCES ESTAB,

212: ,p_max_rank number) IS
213: SELECT QTYP.NAME
214: FROM PER_QUALIFICATION_TYPES QTYP,
215: PER_QUALIFICATIONS QUAL,
216: PER_ESTABLISHMENT_ATTENDANCES ESTAB,
217: PER_ALL_PEOPLE_F ppf,
218: PER_ALL_PEOPLE_F ppf2
219: WHERE ppf.person_id = p_person
220: AND ppf.party_id = ppf2.party_id

Line 276: PER_ESTABLISHMENT_ATTENDANCES ESTAB,

272: CURSOR c_qual_types2 IS
273: SELECT /*+ FIRST_ROWS */ QTYP.NAME
274: FROM PER_QUALIFICATION_TYPES QTYP,
275: PER_QUALIFICATIONS QUAL,
276: PER_ESTABLISHMENT_ATTENDANCES ESTAB,
277: PER_ALL_PEOPLE_F ppf
278: WHERE ppf.party_id = p_party_id
279: AND trunc(sysdate) BETWEEN ppf.effective_start_date and ppf.effective_end_date
280: AND ppf.person_id = ESTAB.PERSON_ID