APPS.SSP_MAT_BUS dependencies on HR_GENERAL

Line 661: nvl(p_mother_death_date,hr_general.end_of_time))

657: fnd_message.raise_error;
658: end if;
659:
660: if p_aspp_start_date < least(ssp_apab_pkg.EARLIEST_ASPPP_START_DATE(p_birth_date),
661: nvl(p_mother_death_date,hr_general.end_of_time))
662: then
663: fnd_message.set_name('SSP','SSP_36796_APL_BIR_START_EARLY');
664: fnd_message.raise_error;
665: end if;

Line 697: nvl(p_mother_death_date,hr_general.end_of_time))

693: fnd_message.raise_error;
694: end if;
695:
696: if p_aspp_start_date < least(ssp_apad_pkg.EARLIEST_ASPPP_START_DATE(p_placement_date),
697: nvl(p_mother_death_date,hr_general.end_of_time))
698: then
699: fnd_message.set_name('SSP','SSP_36798_APL_ADO_START_EARLY');
700: fnd_message.raise_error;
701: end if;

Line 753: if nvl(p_partner_return, hr_general.end_of_time) < p_partner_mpp_start then

749: end if;
750: end if;
751:
752: if p_partner_mpp_start is not null then
753: if nvl(p_partner_return, hr_general.end_of_time) < p_partner_mpp_start then
754: fnd_message.set_name('SSP','SSP_36806_APL_INV_PAR_RET');
755: fnd_message.raise_error;
756: end if;
757: if nvl(p_partner_death, hr_general.end_of_time) < p_partner_mpp_start then

Line 757: if nvl(p_partner_death, hr_general.end_of_time) < p_partner_mpp_start then

753: if nvl(p_partner_return, hr_general.end_of_time) < p_partner_mpp_start then
754: fnd_message.set_name('SSP','SSP_36806_APL_INV_PAR_RET');
755: fnd_message.raise_error;
756: end if;
757: if nvl(p_partner_death, hr_general.end_of_time) < p_partner_mpp_start then
758: fnd_message.set_name('SSP','SSP_36807_APL_INV_DEATH');
759: fnd_message.raise_error;
760: end if;
761: end if;