APPS.PER_ABS_BUS dependencies on PER_ABSENCE_ATTENDANCE_TYPES

Line 81: per_absence_attendance_types abt

77: to_char(abs.date_end,'YYYY'),'DD/MM/YYYY'),
78: abt.hours_or_days,
79: abt.increasing_or_decreasing_flag
80: from per_absence_attendances abs,
81: per_absence_attendance_types abt
82: where abs.person_id = p_person_id
83: and abs.absence_attendance_type_id = abt.absence_attendance_type_id
84: and abs.date_end is not null
85: and abs.date_end <= p_effective_date

Line 88: from per_absence_attendance_types abt2

84: and abs.date_end is not null
85: and abs.date_end <= p_effective_date
86: and abt.input_value_id is not null
87: and abt.input_value_id = (select abt2.input_value_id
88: from per_absence_attendance_types abt2
89: where abt2.absence_attendance_type_id
90: = p_absence_attendance_type_id);
91:
92: cursor c_get_hours_or_days is

Line 94: from per_absence_attendance_types abt

90: = p_absence_attendance_type_id);
91:
92: cursor c_get_hours_or_days is
93: select abt.hours_or_days
94: from per_absence_attendance_types abt
95: where abt.absence_attendance_type_id = p_absence_attendance_type_id;
96:
97: cursor c_get_upload_elements is
98: -- select /*+ leading(PAA) */ nvl(fnd_number.canonical_to_number(pev.screen_entry_value), 0),

Line 105: per_absence_attendance_types abt

101: pev.effective_end_date
102: from pay_element_entry_values_f pev,
103: pay_element_entries_f pee,
104: per_all_assignments_f paa,
105: per_absence_attendance_types abt
106: where pev.element_entry_id = pee.element_entry_id
107: and pev.input_value_id = abt.input_value_id
108: and pee.assignment_id = paa.assignment_id
109: and paa.person_id = p_person_id

Line 965: from per_absence_attendance_types abt,

961:
962: cursor c_get_absence_info is
963: select abt.hours_or_days,
964: piv.element_type_id
965: from per_absence_attendance_types abt,
966: pay_input_values_f piv
967: where abt.absence_attendance_type_id = p_absence_attendance_type_id
968: and abt.input_value_id = piv.input_value_id(+);
969: --

Line 1130: from per_absence_attendance_types abt,

1126:
1127: cursor c_get_absence_info is
1128: select abt.hours_or_days,
1129: piv.element_type_id
1130: from per_absence_attendance_types abt,
1131: pay_input_values_f piv
1132: where abt.absence_attendance_type_id = p_absence_attendance_type_id
1133: and abt.input_value_id = piv.input_value_id(+);
1134: --

Line 1818: -- per_absence_attendance_types for the same business group and that it

1814: -- ---------------------------------------------------------------------------
1815: --
1816: -- Description:
1817: -- Validates that the absence_attendance_type_id exists in
1818: -- per_absence_attendance_types for the same business group and that it
1819: -- is effective for the entire absence duration.
1820: --
1821: -- Pre-conditions:
1822: -- None.

Line 1862: from per_absence_attendance_types abt

1858: --
1859:
1860: cursor c_absence_within_type_dates is
1861: select null
1862: from per_absence_attendance_types abt
1863: where abt.absence_attendance_type_id = p_absence_attendance_type_id
1864: and abt.business_group_id = p_business_group_id
1865: and (p_date_projected_start is null or p_date_projected_start
1866: between abt.date_effective and nvl(abt.date_end,hr_api.g_eot))

Line 2272: from per_absence_attendance_types abt

2268: cursor c_get_absence_type_info is
2269: select abt.hours_or_days,
2270: abt.increasing_or_decreasing_flag,
2271: abt.absence_overlap_flag
2272: from per_absence_attendance_types abt
2273: where abt.absence_attendance_type_id = p_absence_attendance_type_id;
2274:
2275: -- Added for Bug11902652
2276: cursor c_abs_overlap_another is

Line 2294: per_absence_attendance_types abt

2290:
2291: cursor c_abs_day_after_another is
2292: select null
2293: from per_absence_attendances abs,
2294: per_absence_attendance_types abt
2295: where abs.person_id = p_person_id
2296: and abs.absence_attendance_type_id = abt.absence_attendance_type_id
2297: and (p_absence_attendance_id is null or
2298: p_absence_attendance_id <> abs.absence_attendance_id)

Line 2309: per_absence_attendance_types abt,

2305: pay_element_links_f pel,
2306: pay_element_types_f pet,
2307: pay_input_values_f piv,
2308: per_all_assignments_f asg,
2309: per_absence_attendance_types abt,
2310: pay_accrual_plans pap
2311: where abt.absence_attendance_type_id = p_absence_attendance_type_id
2312: and abt.input_value_id = piv.input_value_id
2313: and piv.input_value_id = pap.pto_input_value_id

Line 3759: select absence_category from per_absence_attendance_types

3755:
3756: ----Check the gender of the person in case of maternity leave bug# 6505054
3757:
3758: cursor c_absence_cat(p_absence_attendance_type_id in number) is
3759: select absence_category from per_absence_attendance_types
3760: where absence_attendance_type_id = p_absence_attendance_type_id;
3761:
3762: l_ssp_installed boolean;
3763: l_absence_category varchar2(30);