eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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 158: ,PER_ABSENCE_ATTENDANCES PAA

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

Line 191: ,PER_ABSENCE_ATTENDANCES PAA

187: BEGIN
188: SELECT Meaning
189: INTO p_input_value5
190: FROM FND_LOOKUP_VALUES_VL LKP
191: ,PER_ABSENCE_ATTENDANCES PAA
192: ,PER_ABS_ATTENDANCE_REASONS PAR
193: WHERE PAA.ABSENCE_ATTENDANCE_TYPE_ID = PAR.ABSENCE_ATTENDANCE_TYPE_ID
194: AND PAA.ABSENCE_ATTENDANCE_ID = p_absence_attendance_id
195: AND PAR.ABS_ATTENDANCE_REASON_ID = l_absent_reason

Line 399: FROM PER_ABSENCE_ATTENDANCES PAA

395: abs_information9 post_birth_duration,
396: abs_information10 maternity_weeks_transfer,
397: abs_information6 holiday_accrual,
398: abs_information7 payment_during_leave -- 11694807
399: FROM PER_ABSENCE_ATTENDANCES PAA
400: WHERE PAA.ABSENCE_ATTENDANCE_ID = p_abs_attendance_id;
401:
402: CURSOR csr_asg_le IS SELECT
403: nvl(asg.normal_hours,hoi.org_information3) hours

Line 477: FROM per_absence_attendances ABS

473: CURSOR get_abs_details IS
474: SELECT
475: ABS.abs_information7
476: ,ABS.abs_information5
477: FROM per_absence_attendances ABS
478: WHERE ABS.absence_attendance_id = p_abs_attendance_id;
479: l_abs_details get_abs_details%ROWTYPE ;
480:
481: BEGIN

Line 630: FROM PER_ABSENCE_ATTENDANCES PAA

626: abs_information9 post_adopt_duration,
627: abs_information10 adoption_weeks_transfer,
628: abs_information11 weeks_from_mother,
629: abs_information6 hol_accrual_elig
630: FROM PER_ABSENCE_ATTENDANCES PAA
631: WHERE PAA.ABSENCE_ATTENDANCE_ID = p_abs_attendance_id;
632:
633: CURSOR csr_person_details IS
634: SELECT papf.sex FROM per_all_people_f papf,per_all_assignments_f paaf

Line 801: FROM PER_ABSENCE_ATTENDANCES PAA

797: fnd_date.canonical_to_date(abs_information4) actual_dob,
798: abs_information7 duration_override,
799: abs_information10 parental_type,
800: abs_information5 holiday_accrual
801: FROM PER_ABSENCE_ATTENDANCES PAA
802: WHERE PAA.ABSENCE_ATTENDANCE_ID = p_abs_attendance_id;
803: l_count VARCHAR2(2):='N';
804: Begin
805: FOR csr_abs_details in csr_absence

Line 1081: FROM PER_ABSENCE_ATTENDANCES PAA

1077: fnd_number.canonical_to_number(abs_information7) part_time_hours,
1078: abs_information8 part_time_hrs_freq,
1079: abs_information5 holiday_accrual
1080: ,abs_information6 payment_during_leave -- 11694807
1081: FROM PER_ABSENCE_ATTENDANCES PAA
1082: WHERE PAA.ABSENCE_ATTENDANCE_ID = p_abs_attendance_id;
1083: l_count VARCHAR2(2):='N';
1084: Begin
1085: FOR csr_abs_details in csr_absence