APPS.OTA_FR_TRG_SUM dependencies on PER_ABSENCE_ATTENDANCES

Line 498: per_absence_attendances paa,

494: fnd_number.canonical_to_number(nvl(paa.ABS_INFORMATION20,0)) C_O_O_HR, --Hours Outside Working Hours
495: OTA_FR_TRG_SUM.get_lookup_value('FR_TRAINING_SUBSIDY_TYPE',paa.ABS_INFORMATION5) SUBSI_TYPE, --Subsidized Type
496: hfov.name SUBSI_ORG --Subsidizing Organization
497: from per_all_people_f papf,
498: per_absence_attendances paa,
499: per_absence_attendance_types paat,
500: po_vendors pv,
501: HR_FR_OPCA_V hfov
502: where papf.person_id=l_p_person_id

Line 523: per_absence_attendances paa

519: Select sum(fnd_number.canonical_to_number(nvl(paa.ABSENCE_HOURS,0))) O_TOT_HOURS ,
520: sum(fnd_number.canonical_to_number(nvl(paa.ABS_INFORMATION20,0))) O_TOT_OUT_WK_HR,
521: (paa.ABS_INFORMATION19) LEGAL_CATG --i)JOB_ADAPT ii) JOB_EVOL , iii)COMP_DEV
522: from per_all_people_f papf,
523: per_absence_attendances paa
524: where papf.person_id=l_p_person_id
525: and papf.person_id=paa.person_id
526: and papf.business_group_id=paa.business_group_id
527: and paa.ABS_INFORMATION_CATEGORY='FR_TRAINING_ABSENCE' -- Absence Should be Training Leave category