APPS.GHR_UTILITY dependencies on FND_DATE

Line 876: select nvl(max(fnd_date.canonical_to_date(rei_information3))+1,p_effective_date)

872: p_effective_date in ghr_pa_requests.effective_date%type,
873: p_pa_request_id in ghr_pa_requests.pa_request_id%type)
874: is
875: cursor get_next_auth_date is
876: select nvl(max(fnd_date.canonical_to_date(rei_information3))+1,p_effective_date)
877: authentication_date
878: from ghr_pa_requests par, ghr_pa_request_extra_info rei
879: where par.person_id in ( select person_id from ghr_pa_requests where
880: pa_request_id = p_pa_request_id )

Line 891: l_rei_rec.rei_information3 := fnd_date.date_to_canonical(c_ad_rec.authentication_date);

887: begin
888: for c_ad_rec in get_next_auth_date loop
889: l_rei_rec.information_type := 'GHR_US_PAR_NFC_INFO';
890: l_rei_rec.pa_request_id := p_pa_request_id;
891: l_rei_rec.rei_information3 := fnd_date.date_to_canonical(c_ad_rec.authentication_date);
892: GHR_NON_SF52_EXTRA_INFO.generic_populate_extra_info
893: (p_rei_rec => l_rei_rec,
894: p_org_rec => l_org_rec,
895: p_flag => 'C'