APPS.PAY_NO_ABS_VALIDATION dependencies on FND_DATE

Line 559: ,fnd_date.canonical_to_date(pceif.cei_information1) start_date

555:
556: CURSOR csr_contact_extra_info (p_con_relationship_id NUMBER) IS
557: SELECT pceif.effective_start_date
558: ,pceif.effective_end_date
559: ,fnd_date.canonical_to_date(pceif.cei_information1) start_date
560: ,fnd_date.canonical_to_date(pceif.cei_information2) end_date
561: FROM per_contact_extra_info_f pceif
562: WHERE pceif.contact_relationship_id = p_con_relationship_id
563: AND pceif.information_type = 'NO_CMS_DIS_DATE';

Line 560: ,fnd_date.canonical_to_date(pceif.cei_information2) end_date

556: CURSOR csr_contact_extra_info (p_con_relationship_id NUMBER) IS
557: SELECT pceif.effective_start_date
558: ,pceif.effective_end_date
559: ,fnd_date.canonical_to_date(pceif.cei_information1) start_date
560: ,fnd_date.canonical_to_date(pceif.cei_information2) end_date
561: FROM per_contact_extra_info_f pceif
562: WHERE pceif.contact_relationship_id = p_con_relationship_id
563: AND pceif.information_type = 'NO_CMS_DIS_DATE';
564:

Line 1115: l_date_of_birth := fnd_date.canonical_to_date(P_ABS_INFORMATION1) ;

1111:
1112: END IF;
1113: IF P_ABS_INFORMATION_CATEGORY IN ('NO_PA','NO_PTP') THEN
1114: -- Error - if the absence start date is earlier than the date of birth
1115: l_date_of_birth := fnd_date.canonical_to_date(P_ABS_INFORMATION1) ;
1116: IF l_date_of_birth > P_DATE_START THEN
1117: Fnd_message.set_name('PAY','PAY_376905_NO_DOB_ST_DT_CHECK');
1118: Fnd_message.raise_error;
1119: END IF;