APPS.OTA_CPR_UTILITY dependencies on FND_PROFILE

Line 857: and ( (oav.END_DATE is null ) or (trunc(oav.END_DATE) > trunc(to_date(p_pre_req_crs_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')))) )

853: where ocp.activity_version_id = oav.activity_version_id
854: and oav.activity_version_id = oavt.activity_version_id
855: and oavt.language = userenv('LANG')
856: and ocp.prerequisite_course_id = p_act_ver_id
857: and ( (oav.END_DATE is null ) or (trunc(oav.END_DATE) > trunc(to_date(p_pre_req_crs_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')))) )
858: Order By Dependant_Course_Name desc;
859: --
860: l_depend_course_names varchar2(4000);
861: Begin