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 104: per_absence_attendance_types abt

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

Line 961: from per_absence_attendance_types abt,

957:
958: cursor c_get_absence_info is
959: select abt.hours_or_days,
960: piv.element_type_id
961: from per_absence_attendance_types abt,
962: pay_input_values_f piv
963: where abt.absence_attendance_type_id = p_absence_attendance_type_id
964: and abt.input_value_id = piv.input_value_id(+);
965: --

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

1627: -- ---------------------------------------------------------------------------
1628: --
1629: -- Description:
1630: -- Validates that the absence_attendance_type_id exists in
1631: -- per_absence_attendance_types for the same business group and that it
1632: -- is effective for the entire absence duration.
1633: --
1634: -- Pre-conditions:
1635: -- None.

Line 1675: from per_absence_attendance_types abt

1671: --
1672:
1673: cursor c_absence_within_type_dates is
1674: select null
1675: from per_absence_attendance_types abt
1676: where abt.absence_attendance_type_id = p_absence_attendance_type_id
1677: and abt.business_group_id = p_business_group_id
1678: and (p_date_projected_start is null or p_date_projected_start
1679: between abt.date_effective and nvl(abt.date_end,hr_api.g_eot))

Line 1918: from per_absence_attendance_types abt

1914: cursor c_get_absence_type_info is
1915: select abt.hours_or_days,
1916: abt.increasing_or_decreasing_flag,
1917: abt.absence_overlap_flag
1918: from per_absence_attendance_types abt
1919: where abt.absence_attendance_type_id = p_absence_attendance_type_id;
1920:
1921: cursor c_abs_overlap_another is
1922: select null

Line 1952: per_absence_attendance_types abt

1948:
1949: cursor c_abs_day_after_another is
1950: select null
1951: from per_absence_attendances abs,
1952: per_absence_attendance_types abt
1953: where abs.person_id = p_person_id
1954: and abs.absence_attendance_type_id = abt.absence_attendance_type_id
1955: and (p_absence_attendance_id is null or
1956: p_absence_attendance_id <> abs.absence_attendance_id)

Line 1967: per_absence_attendance_types abt,

1963: pay_element_links_f pel,
1964: pay_element_types_f pet,
1965: pay_input_values_f piv,
1966: per_all_assignments_f asg,
1967: per_absence_attendance_types abt,
1968: pay_accrual_plans pap
1969: where abt.absence_attendance_type_id = p_absence_attendance_type_id
1970: and abt.input_value_id = piv.input_value_id
1971: and piv.input_value_id = pap.pto_input_value_id

Line 3327: select absence_category from per_absence_attendance_types

3323:
3324: ----Check the gender of the person in case of maternity leave bug# 6505054
3325:
3326: cursor c_absence_cat(p_absence_attendance_type_id in number) is
3327: select absence_category from per_absence_attendance_types
3328: where absence_attendance_type_id = p_absence_attendance_type_id;
3329:
3330: l_ssp_installed boolean;
3331: l_absence_category varchar2(30);