APPS.PAY_DK_ABSENCE_USER dependencies on PER_ABSENCE_ATTENDANCES

Line 107: FROM per_absence_attendances abs

103: ,l_start_time
104: ,l_end_time
105: ,l_intial_absence
106: ,l_initial_abs_creator_id
107: FROM per_absence_attendances abs
108: WHERE abs.absence_attendance_id = p_absence_attendance_id;
109: EXCEPTION
110: WHEN OTHERS THEN
111: NULL;

Line 129: ,PER_ABSENCE_ATTENDANCES PAA

125: BEGIN
126: SELECT Meaning
127: INTO p_input_value5
128: FROM FND_LOOKUP_VALUES_VL LKP
129: ,PER_ABSENCE_ATTENDANCES PAA
130: ,PER_ABS_ATTENDANCE_REASONS PAR
131: WHERE PAA.ABSENCE_ATTENDANCE_TYPE_ID = PAR.ABSENCE_ATTENDANCE_TYPE_ID
132: AND PAA.ABSENCE_ATTENDANCE_ID = p_absence_attendance_id
133: AND PAR.ABS_ATTENDANCE_REASON_ID = l_absent_reason

Line 161: ,PER_ABSENCE_ATTENDANCES PAA

157: BEGIN
158: SELECT Meaning
159: INTO p_input_value5
160: FROM FND_LOOKUP_VALUES_VL LKP
161: ,PER_ABSENCE_ATTENDANCES PAA
162: ,PER_ABS_ATTENDANCE_REASONS PAR
163: WHERE PAA.ABSENCE_ATTENDANCE_TYPE_ID = PAR.ABSENCE_ATTENDANCE_TYPE_ID
164: AND PAA.ABSENCE_ATTENDANCE_ID = p_absence_attendance_id
165: AND PAR.ABS_ATTENDANCE_REASON_ID = l_absent_reason

Line 365: FROM PER_ABSENCE_ATTENDANCES PAA

361: abs_information8 pre_birth_duration,
362: abs_information9 post_birth_duration,
363: abs_information10 maternity_weeks_transfer,
364: abs_information6 holiday_accrual
365: FROM PER_ABSENCE_ATTENDANCES PAA
366: WHERE PAA.ABSENCE_ATTENDANCE_ID = p_abs_attendance_id;
367:
368: CURSOR csr_asg_le IS SELECT
369: nvl(asg.normal_hours,hoi.org_information3) hours

Line 442: FROM per_absence_attendances ABS

438: CURSOR get_abs_details IS
439: SELECT
440: ABS.abs_information7
441: ,ABS.abs_information5
442: FROM per_absence_attendances ABS
443: WHERE ABS.absence_attendance_id = p_abs_attendance_id;
444: l_abs_details get_abs_details%ROWTYPE ;
445:
446: BEGIN

Line 595: FROM PER_ABSENCE_ATTENDANCES PAA

591: abs_information9 post_adopt_duration,
592: abs_information10 adoption_weeks_transfer,
593: abs_information11 weeks_from_mother,
594: abs_information6 hol_accrual_elig
595: FROM PER_ABSENCE_ATTENDANCES PAA
596: WHERE PAA.ABSENCE_ATTENDANCE_ID = p_abs_attendance_id;
597:
598: CURSOR csr_person_details IS
599: SELECT papf.sex FROM per_all_people_f papf,per_all_assignments_f paaf

Line 766: FROM PER_ABSENCE_ATTENDANCES PAA

762: fnd_date.canonical_to_date(abs_information4) actual_dob,
763: abs_information7 duration_override,
764: abs_information10 parental_type,
765: abs_information5 holiday_accrual
766: FROM PER_ABSENCE_ATTENDANCES PAA
767: WHERE PAA.ABSENCE_ATTENDANCE_ID = p_abs_attendance_id;
768: l_count VARCHAR2(2):='N';
769: Begin
770: FOR csr_abs_details in csr_absence

Line 1044: FROM PER_ABSENCE_ATTENDANCES PAA

1040: fnd_date.canonical_to_date(abs_information4) actual_dob,
1041: fnd_number.canonical_to_number(abs_information7) part_time_hours,
1042: abs_information8 part_time_hrs_freq,
1043: abs_information5 holiday_accrual
1044: FROM PER_ABSENCE_ATTENDANCES PAA
1045: WHERE PAA.ABSENCE_ATTENDANCE_ID = p_abs_attendance_id;
1046: l_count VARCHAR2(2):='N';
1047: Begin
1048: FOR csr_abs_details in csr_absence