APPS.PER_PCE_BUS dependencies on HR_GENERAL

Line 1043: ,hr_general.end_of_time,hr_general.start_of_time

1039: SELECT 'X'
1040: FROM per_cagr_entitlement_lines_f pcl
1041: WHERE pcl.cagr_entitlement_id = p_cagr_entitlement_id
1042: AND DECODE(pcl.effective_end_date
1043: ,hr_general.end_of_time,hr_general.start_of_time
1044: ,pcl.effective_end_date) > NVL(p_end_date,hr_general.end_of_time);
1045: --
1046: l_proc VARCHAR2(72) := g_package||'chk_end_date';
1047: l_dummy VARCHAR2(1);

Line 1044: ,pcl.effective_end_date) > NVL(p_end_date,hr_general.end_of_time);

1040: FROM per_cagr_entitlement_lines_f pcl
1041: WHERE pcl.cagr_entitlement_id = p_cagr_entitlement_id
1042: AND DECODE(pcl.effective_end_date
1043: ,hr_general.end_of_time,hr_general.start_of_time
1044: ,pcl.effective_end_date) > NVL(p_end_date,hr_general.end_of_time);
1045: --
1046: l_proc VARCHAR2(72) := g_package||'chk_end_date';
1047: l_dummy VARCHAR2(1);
1048: --

Line 1062: NVL(p_end_date,hr_general.end_of_time)))) THEN*/

1058: /*
1059: IF ( (p_cagr_entitlement_id IS NULL) OR
1060: ((p_cagr_entitlement_id IS NOT NULL) AND
1061: (per_pce_shd.g_old_rec.end_date <>
1062: NVL(p_end_date,hr_general.end_of_time)))) THEN*/
1063: --
1064: hr_utility.set_location(l_proc,20);
1065: --
1066: -- Check that start_date IS not after the end_date

Line 1068: IF NVL(p_end_date,hr_general.end_of_time) < p_start_date THEN

1064: hr_utility.set_location(l_proc,20);
1065: --
1066: -- Check that start_date IS not after the end_date
1067: --
1068: IF NVL(p_end_date,hr_general.end_of_time) < p_start_date THEN
1069: --
1070: hr_utility.set_message(800, 'HR_289271_EDATE_AFTER_ST_DATE');
1071: hr_utility.raise_error;
1072: --

Line 1097: IF NVL(p_end_date,hr_general.end_of_time) < p_effective_date THEN

1093: --
1094: -- Check that the end_date is not being set
1095: -- to a date before the effective date
1096: --
1097: IF NVL(p_end_date,hr_general.end_of_time) < p_effective_date THEN
1098: --
1099: hr_utility.set_message(800, 'HR_289394_EDATE_BEFORE_EFF_DAT');
1100: hr_utility.raise_error;
1101: --