DBA Data[Home] [Help]

APPS.HR_PERSON_ABSENCE_API dependencies on HR_API_TRANSACTIONS

Line 3200: from hr_api_transactions hat,

3196: hat.transaction_ref_id,
3197: pet.ELEMENT_TYPE_ID,
3198: abt.hours_or_days,
3199: decode (hrtsteps.INFORMATION9,'CONFIRMED','Y','N') CONFIRMED_FLAG
3200: from hr_api_transactions hat,
3201: HR_API_TRANSACTION_STEPS hrtsteps,
3202: per_absence_attendance_types abt,
3203: pay_input_values_f piv,
3204: pay_element_types_f pet

Line 3251: from hr_api_transactions hat,

3247: and p_end_date >= nvl(aba.date_start,aba.DATE_PROJECTED_START))
3248:
3249: and aba.absence_attendance_id not in
3250: ( select hat.transaction_ref_id
3251: from hr_api_transactions hat,
3252: HR_API_TRANSACTION_STEPS hrtsteps
3253: where
3254: hat.SELECTED_PERSON_ID = p_person_id
3255: --hat.creator_person_id = 125