APPS.HR_CONTRACT_API dependencies on HR_GENERAL

Line 1228: and nvl(pps.actual_termination_date, hr_general.end_of_time);

1224: cursor csr_date is select pps.date_start
1225: from per_periods_of_service pps
1226: where p_person_id=pps.person_id
1227: and p_active_date between pps.date_start
1228: and nvl(pps.actual_termination_date, hr_general.end_of_time);
1229:
1230: -- set up the variables
1231:
1232: l_start_date per_periods_of_service.date_start%type;

Line 1336: l_other_start_date := hr_general.start_of_time;

1332: fetch csr_date_other into l_other_start_date;
1333: close csr_date_other;
1334:
1335: if l_other_start_date is null then
1336: l_other_start_date := hr_general.start_of_time;
1337: end if;
1338:
1339: if (l_active_start_date > l_other_start_date) then
1340: return(l_active_start_date);

Line 1398: l_other_end_date := hr_general.end_of_time;

1394: fetch csr_date_other into l_other_end_date;
1395: close csr_date_other;
1396:
1397: if l_other_end_date is null then
1398: l_other_end_date := hr_general.end_of_time;
1399: end if;
1400:
1401: if (l_active_end_date <= l_other_end_date) then
1402:

Line 1403: if (l_active_end_date = hr_general.end_of_time) then

1399: end if;
1400:
1401: if (l_active_end_date <= l_other_end_date) then
1402:
1403: if (l_active_end_date = hr_general.end_of_time) then
1404: l_active_end_date := null;
1405: end if;
1406: return(l_active_end_date);
1407: else