DBA Data[Home] [Help]

APPS.PAY_FR_PTO_PKG dependencies on PER_ABSENCE_ATTENDANCE_TYPES

Line 2944: ,per_absence_attendance_types pat

2940: ,pivA.element_type_id ADJ_element_id
2941: ,pap.business_group_id business_Group_id
2942: from pay_accrual_plans pap
2943: ,per_absence_attendances paa
2944: ,per_absence_attendance_types pat
2945: ,pay_element_entries_f pee
2946: ,pay_input_values_f piv
2947: ,pay_input_values_f pivE
2948: ,pay_input_values_f pivO

Line 4611: ,per_absence_attendance_types pat

4607: ,pivA.element_type_id ADJ_element_id
4608: ,pap.business_group_id business_Group_id
4609: from pay_accrual_plans pap
4610: ,per_absence_attendances paa
4611: ,per_absence_attendance_types pat
4612: ,pay_element_entries_f pee
4613: ,pay_input_values_f piv
4614: ,pay_input_values_f pivE
4615: ,pay_input_values_f pivO

Line 5818: ,per_absence_attendance_types pat

5814: -- has taken a sick leave between LDW and ATD. Bug#2874154
5815: select 1
5816: from per_absence_attendances paa
5817: ,pay_element_entries_f pee
5818: ,per_absence_attendance_types pat
5819: where pee.creator_type = 'A'
5820: and paa.absence_attendance_id = pee.creator_id
5821: and fnd_date.date_to_canonical (paa.date_start) between fnd_date.date_to_canonical(p_start_date) and fnd_date.date_to_canonical(p_end_date)
5822: and pee.assignment_id = p_assignment_id