APPS.HR_PERSON_ABSENCE_API dependencies on PAY_ELEMENT_TYPES_F

Line 332: l_processing_type pay_element_types_f.processing_type%TYPE;

328: l_absence_attendance_id number;
329: l_assignment_id number;
330: l_element_entry_id number;
331: l_object_version_number number;
332: l_processing_type pay_element_types_f.processing_type%TYPE;
333: l_dur_dys_less_warning boolean;
334: l_dur_hrs_less_warning boolean;
335: l_exceeds_pto_entit_warning boolean;
336: l_exceeds_run_total_warning boolean;

Line 1027: l_processing_type pay_element_types_f.processing_type%TYPE;

1023: l_assignment_id number;
1024: l_element_entry_id number;
1025: l_effective_start_date date;
1026: l_effective_end_date date;
1027: l_processing_type pay_element_types_f.processing_type%TYPE;
1028: l_dur_dys_less_warning boolean;
1029: l_dur_hrs_less_warning boolean;
1030: l_exceeds_pto_entit_warning boolean;
1031: l_exceeds_run_total_warning boolean;

Line 2017: ,pay_element_types_f pet

2013: from per_absence_attendances abs
2014: ,per_all_assignments_f asg
2015: ,per_absence_attendance_types abt
2016: ,pay_input_values_f piv
2017: ,pay_element_types_f pet
2018: ,pay_element_links_f pel
2019: ,pay_element_entries_f pee
2020: where abs.absence_attendance_id = p_absence_attendance_id
2021: and abs.person_id = asg.person_id

Line 2065: pay_element_types_f pet

2061: cursor c_get_processing_type is
2062: select upper(pet.processing_type)
2063: from per_absence_attendance_types abt,
2064: pay_input_values_f piv,
2065: pay_element_types_f pet
2066: where abt.absence_attendance_type_id = p_absence_attendance_type_id
2067: and abt.input_value_id = piv.input_value_id
2068: and piv.element_type_id = pet.element_type_id;
2069:

Line 2072: l_processing_type pay_element_types_f.processing_type%TYPE;

2068: and piv.element_type_id = pet.element_type_id;
2069:
2070:
2071: l_proc varchar2(72) := g_package||'get_processing_type';
2072: l_processing_type pay_element_types_f.processing_type%TYPE;
2073:
2074:
2075: begin
2076:

Line 2117: pay_element_types_f pet

2113: pet.processing_type
2114: from per_absence_attendances aba,
2115: per_absence_attendance_types abt,
2116: pay_input_values_f piv,
2117: pay_element_types_f pet
2118: where aba.absence_attendance_id = p_absence_attendance_id
2119: and aba.absence_attendance_type_id = abt.absence_attendance_type_id
2120: and abt.input_value_id = piv.input_value_id
2121: and piv.element_type_id = pet.element_type_id;

Line 2128: l_processing_type pay_element_types_f.processing_type%TYPE;

2124: l_proc varchar2(72) := g_package||'get_element_details';
2125: l_absence_hours per_absence_attendances.absence_hours%TYPE;
2126: l_absence_days per_absence_attendances.absence_days%TYPE;
2127: l_hours_or_days per_absence_attendance_types.hours_or_days%TYPE;
2128: l_processing_type pay_element_types_f.processing_type%TYPE;
2129: l_inc_or_dec_flag per_absence_attendance_types.increasing_or_decreasing_flag%TYPE;
2130:
2131:
2132: begin