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.PER_ABSENCE_ATTENDANCES_PKG dependencies on HR_GENERAL

Line 66: 110.1 hr_general.end_of_time

62: pay_element_entry_values_f.input_value_id
63: Also included new Change List Header.
64:
65: 70.39 07-AUG-1997 Mbocutt Change hardcoded date usage to use
66: 110.1 hr_general.end_of_time
67: 70.40 23-OCT-1997 565478 ASAHAY modified cursor in b_check_auth_de
68: 110.1 and b_check_rep_de to check for
69: correct start date and end date
70: 70.42 05-MAY-1998 563202 AParkes Performance fix for SSP; Altered

Line 257: p_earliest_abs_start_date := hr_general.end_of_time;

253: c2_rec c2%ROWTYPE;
254: --
255: begin
256: p_nos_absences := 0;
257: p_earliest_abs_start_date := hr_general.end_of_time;
258: --
259: for c2_rec in c2 LOOP
260: p_nos_absences := p_nos_absences + 1;
261: --

Line 384: nvl(mpp_start_date,hr_general.end_of_time) MPP,

380: 'PB',ssp_pab_pkg.earliest_PPP_start_date(actual_birth_date),
381: ssp_smp_pkg.earliest_MPP_start_date (due_date))
382: earliest_MPP_start_date,
383: ssp_smp_pkg.qualifying_week (due_date) QW,
384: nvl(mpp_start_date,hr_general.end_of_time) MPP,
385: person_id,
386: leave_type,
387: placement_date,
388: due_date,

Line 395: l_end_date date := nvl (p_end_date, hr_general.end_of_time);

391: where maternity_id = p_maternity_id;
392: --
393: l_maternity csr_MPP%rowtype;
394: l_default_MPP_start_date date := null;
395: l_end_date date := nvl (p_end_date, hr_general.end_of_time);
396: l_current_mpp_start_date date := hr_general.end_of_time;
397: l_earliest_abs_start_date date;
398: l_ewc date;
399: l_earliest_mpp_start date;

Line 396: l_current_mpp_start_date date := hr_general.end_of_time;

392: --
393: l_maternity csr_MPP%rowtype;
394: l_default_MPP_start_date date := null;
395: l_end_date date := nvl (p_end_date, hr_general.end_of_time);
396: l_current_mpp_start_date date := hr_general.end_of_time;
397: l_earliest_abs_start_date date;
398: l_ewc date;
399: l_earliest_mpp_start date;
400: l_qw date;

Line 1669: hr_general.end_of_time) <> nvl (X_sickness_end_date,

1665: --
1666: if X_sickness_start_date is not null
1667: and (l_absence.sickness_start_date <> X_sickness_start_date
1668: or nvl (l_absence.sickness_end_date,
1669: hr_general.end_of_time) <> nvl (X_sickness_end_date,
1670: hr_general.end_of_time) )
1671: then
1672: --
1673: -- The sickness dates are being updated. Make sure that the PIW series is

Line 1670: hr_general.end_of_time) )

1666: if X_sickness_start_date is not null
1667: and (l_absence.sickness_start_date <> X_sickness_start_date
1668: or nvl (l_absence.sickness_end_date,
1669: hr_general.end_of_time) <> nvl (X_sickness_end_date,
1670: hr_general.end_of_time) )
1671: then
1672: --
1673: -- The sickness dates are being updated. Make sure that the PIW series is
1674: -- not affected as a result of the update.

Line 2701: pos.date_start AND nvl(pos.actual_termination_date,hr_general.end_of_time);

2697: from per_periods_of_service pos
2698: where pos.person_id = p_per_id
2699: and pos.date_start > p_curr_date_end
2700: and p_proj_start between
2701: pos.date_start AND nvl(pos.actual_termination_date,hr_general.end_of_time);
2702: --
2703: begin
2704: --
2705: hr_utility.set_location('per_absence_attendances_pkg.chk_serv_period',1);

Line 2836: nvl(mat.mpp_start_date,hr_general.end_of_time) MPP,

2832: Procedure check_val_abs_start (p_date_start in date,
2833: p_maternity_id in number) is
2834: Cursor csr_maternity is
2835: select ssp_smp_pkg.qualifying_week (mat.due_date) QW,
2836: nvl(mat.mpp_start_date,hr_general.end_of_time) MPP,
2837: nvl(mat.leave_type,'MA') leave_type
2838: from ssp_maternities MAT
2839: where mat.maternity_id = p_maternity_id;
2840: --