APPS.HR_PERSON_ABSENCE_API dependencies on PAY_ELEMENT_TYPES_F

Line 334: l_processing_type pay_element_types_f.processing_type%TYPE;

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

Line 1188: l_processing_type pay_element_types_f.processing_type%TYPE;

1184: l_assignment_id number;
1185: l_element_entry_id number;
1186: l_effective_start_date date;
1187: l_effective_end_date date;
1188: l_processing_type pay_element_types_f.processing_type%TYPE;
1189: l_dur_dys_less_warning boolean;
1190: l_dur_hrs_less_warning boolean;
1191: l_exceeds_pto_entit_warning boolean;
1192: l_exceeds_run_total_warning boolean;

Line 2605: ,pay_element_types_f pet

2601: from per_absence_attendances abs
2602: ,per_all_assignments_f asg
2603: ,per_absence_attendance_types abt
2604: ,pay_input_values_f piv
2605: ,pay_element_types_f pet
2606: ,pay_element_links_f pel
2607: ,pay_element_entries_f pee
2608: where abs.absence_attendance_id = p_absence_attendance_id
2609: and abs.person_id = asg.person_id

Line 2653: pay_element_types_f pet

2649: cursor c_get_processing_type is
2650: select upper(pet.processing_type)
2651: from per_absence_attendance_types abt,
2652: pay_input_values_f piv,
2653: pay_element_types_f pet
2654: where abt.absence_attendance_type_id = p_absence_attendance_type_id
2655: and abt.input_value_id = piv.input_value_id
2656: and piv.element_type_id = pet.element_type_id;
2657:

Line 2660: l_processing_type pay_element_types_f.processing_type%TYPE;

2656: and piv.element_type_id = pet.element_type_id;
2657:
2658:
2659: l_proc varchar2(72) := g_package||'get_processing_type';
2660: l_processing_type pay_element_types_f.processing_type%TYPE;
2661:
2662:
2663: begin
2664:

Line 2705: pay_element_types_f pet

2701: pet.processing_type
2702: from per_absence_attendances aba,
2703: per_absence_attendance_types abt,
2704: pay_input_values_f piv,
2705: pay_element_types_f pet
2706: where aba.absence_attendance_id = p_absence_attendance_id
2707: and aba.absence_attendance_type_id = abt.absence_attendance_type_id
2708: and abt.input_value_id = piv.input_value_id
2709: and piv.element_type_id = pet.element_type_id;

Line 2716: l_processing_type pay_element_types_f.processing_type%TYPE;

2712: l_proc varchar2(72) := g_package||'get_element_details';
2713: l_absence_hours per_absence_attendances.absence_hours%TYPE;
2714: l_absence_days per_absence_attendances.absence_days%TYPE;
2715: l_hours_or_days per_absence_attendance_types.hours_or_days%TYPE;
2716: l_processing_type pay_element_types_f.processing_type%TYPE;
2717: l_inc_or_dec_flag per_absence_attendance_types.increasing_or_decreasing_flag%TYPE;
2718:
2719:
2720: begin

Line 3204: pay_element_types_f pet

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
3205: where
3206: hat.SELECTED_PERSON_ID = p_person_id
3207: --hat.creator_person_id = 125
3208: and hat.TRANSACTION_REF_TABLE = 'PER_ABSENCE_ATTENDANCES'

Line 3241: pay_element_types_f pet

3237:
3238: from per_absence_attendances aba,
3239: per_absence_attendance_types abt,
3240: pay_input_values_f piv,
3241: pay_element_types_f pet
3242: where aba.person_id = p_person_id
3243: AND abt.absence_attendance_type_id= aba.absence_attendance_type_id
3244: and abt.input_value_id = piv.input_value_id (+)
3245: and piv.element_type_id = pet.element_type_id(+)