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_SE_ABSENCE dependencies on PER_ABSENCE_ATTENDANCES

Line 128: FROM PER_ABSENCE_ATTENDANCES PAA

124: AND PER.EFFECTIVE_END_DATE;
125:
126: CURSOR csr_Absence_Hourly_Rate IS
127: SELECT PAA.ABS_INFORMATION1 AS Hourly_Rate --Daily Rate Calculation
128: FROM PER_ABSENCE_ATTENDANCES PAA
129: WHERE PAA.ABSENCE_ATTENDANCE_ID =l_abs_attendance_id;
130:
131:
132: CURSOR csr_Absence_Salary_Rate IS

Line 134: FROM PER_ABSENCE_ATTENDANCES PAA

130:
131:
132: CURSOR csr_Absence_Salary_Rate IS
133: SELECT PAA.ABS_INFORMATION2 AS Salary_Rate --Daily Rate Calculation
134: FROM PER_ABSENCE_ATTENDANCES PAA
135: WHERE PAA.ABSENCE_ATTENDANCE_ID =l_abs_attendance_id;
136:
137:
138: CURSOR csr_abs_attendance_id (l_asg_id number, l_eff_dt date, l_inp_val_name varchar2, l_start_dt date, l_end_dt date) IS

Line 403: FROM per_absence_attendances paa,

399: ,nvl(paa.date_end,p_abs_end_date) date_end
400: ,paa.time_start
401: ,paa.time_end
402: ,DECODE(paa.date_start, paa.date_end, 1, (paa.date_end-paa.date_start)+1) AS days_diff
403: FROM per_absence_attendances paa,
404: per_absence_attendance_types pat
405: WHERE paa.person_id = l_person_id
406: AND ((paa.date_start between l_st_date and p_abs_end_date)
407: OR (paa.date_end between l_st_date and p_abs_end_date))

Line 423: FROM per_absence_attendances paa,

419: ,paa.time_start
420: ,paa.time_end
421: ,DECODE(paa.date_start,least(nvl(paa.date_end,p_abs_end_date),nvl((select actual_termination_date from per_periods_of_service where person_id=l_person_id),p_abs_end_date)), 1,
422: (least(nvl(paa.date_end,p_abs_end_date),nvl((select actual_termination_date from per_periods_of_service where person_id=l_person_id),p_abs_end_date))-paa.date_start)+1) AS days_diff
423: FROM per_absence_attendances paa,
424: per_absence_attendance_types pat
425: WHERE paa.person_id = l_person_id
426: /*AND paa.date_start >=p_abs_start_date
427: AND nvl(paa.date_end,p_abs_end_date)<=p_abs_end_date*/

Line 684: FROM per_absence_attendances paa,

680: ,nvl(paa.date_end,p_abs_end_date) date_end
681: ,paa.time_start
682: ,paa.time_end
683: ,DECODE(paa.date_start, paa.date_end, 1, (paa.date_end-paa.date_start)+1) AS days_diff
684: FROM per_absence_attendances paa,
685: per_absence_attendance_types pat
686: WHERE paa.person_id = l_person_id
687: AND paa.date_start >=p_abs_start_date
688: AND nvl(paa.date_end,p_abs_end_date)<=p_abs_end_date

Line 702: FROM per_absence_attendances paa,

698: ,paa.time_start
699: ,paa.time_end
700: ,DECODE(paa.date_start,least(nvl(paa.date_end,p_abs_end_date),nvl((select actual_termination_date from per_periods_of_service where person_id=l_person_id),p_abs_end_date)), 1,
701: (least(nvl(paa.date_end,p_abs_end_date),nvl((select actual_termination_date from per_periods_of_service where person_id=l_person_id),p_abs_end_date))-paa.date_start)+1) AS days_diff
702: FROM per_absence_attendances paa,
703: per_absence_attendance_types pat
704: WHERE paa.person_id = l_person_id
705: AND paa.date_start >=p_abs_start_date
706: AND paa.date_start<=p_abs_end_date

Line 3478: FROM per_absence_attendances paa,

3474: ,least(nvl(paa.date_end,csr_v_payroll_end_date),nvl((select actual_termination_date from per_periods_of_service where person_id=csr_v_person_id),csr_v_payroll_end_date)) date_end
3475: ,paa.time_start
3476: ,paa.time_end
3477: --,(date_end-date_start) date_diff
3478: FROM per_absence_attendances paa,
3479: per_absence_attendance_types pat
3480: WHERE paa.person_id = csr_v_person_id --37732
3481: AND paa.date_start <= csr_v_payroll_end_date--'31-mar-2000' --p_abs_end_date
3482: AND least(nvl(paa.date_end,csr_v_payroll_end_date),csr_v_payroll_end_date)>=greatest(paa.date_start,csr_v_fourteenth_date,csr_v_payroll_start_date)--'01-mar-2000' --p_abs_end_date

Line 3574: FROM per_absence_attendances paa,

3570: ,least(nvl(paa.date_end,csr_v_end_date),nvl((select actual_termination_date from per_periods_of_service where person_id=csr_v_person_id),csr_v_end_date)) date_end
3571: ,paa.time_start
3572: ,paa.time_end
3573: --,(date_end-date_start) date_diff
3574: FROM per_absence_attendances paa,
3575: per_absence_attendance_types pat
3576: WHERE paa.person_id = csr_v_person_id --37732
3577: AND paa.date_start <= csr_v_end_date--'31-mar-2000' --p_abs_end_date
3578: AND least(nvl(paa.date_end,csr_v_end_date),csr_v_end_date)>=greatest(paa.date_start,csr_v_start_date)--'01-mar-2000' --p_abs_end_date

Line 3630: FROM per_absence_attendances paa,

3626: ,paa.time_start
3627: ,paa.time_end
3628: ,DECODE(paa.date_start,least(nvl(paa.date_end,csr_v_end_date),nvl((select actual_termination_date from per_periods_of_service where person_id=csr_v_person_id),csr_v_end_date)), 1,
3629: (least(nvl(paa.date_end,csr_v_end_date),nvl((select actual_termination_date from per_periods_of_service where person_id=csr_v_person_id),csr_v_end_date))-paa.date_start)+1) AS days_diff
3630: FROM per_absence_attendances paa,
3631: per_absence_attendance_types pat
3632: WHERE paa.person_id = csr_v_person_id
3633: AND paa.date_start >=csr_v_start_date
3634: AND paa.date_start<=csr_v_end_date