APPS.HR_CONTRACT_API dependencies on HR_GENERAL

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

1201: cursor csr_date is select pps.date_start
1202: from per_periods_of_service pps
1203: where p_person_id=pps.person_id
1204: and p_active_date between pps.date_start
1205: and nvl(pps.actual_termination_date, hr_general.end_of_time);
1206:
1207: -- set up the variables
1208:
1209: l_start_date per_periods_of_service.date_start%type;

Line 1313: l_other_start_date := hr_general.start_of_time;

1309: fetch csr_date_other into l_other_start_date;
1310: close csr_date_other;
1311:
1312: if l_other_start_date is null then
1313: l_other_start_date := hr_general.start_of_time;
1314: end if;
1315:
1316: if (l_active_start_date > l_other_start_date) then
1317: return(l_active_start_date);

Line 1375: l_other_end_date := hr_general.end_of_time;

1371: fetch csr_date_other into l_other_end_date;
1372: close csr_date_other;
1373:
1374: if l_other_end_date is null then
1375: l_other_end_date := hr_general.end_of_time;
1376: end if;
1377:
1378: if (l_active_end_date <= l_other_end_date) then
1379:

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

1376: end if;
1377:
1378: if (l_active_end_date <= l_other_end_date) then
1379:
1380: if (l_active_end_date = hr_general.end_of_time) then
1381: l_active_end_date := null;
1382: end if;
1383: return(l_active_end_date);
1384: else