The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT profile_option_value
FROM fnd_profile_option_values fpov
,fnd_profile_options fpo
WHERE fpo.profile_option_name = 'OSS_COUNTRY_CODE'
AND fpov.profile_option_id = fpo.profile_option_id
AND fpov.level_id = p_level_id
AND fpov.level_value = p_level_value;
details are updated and stop further processing.
Known limitations,enhancements,remarks:
Change History
Who When What
smaddali 27-aug-03 Modified procedure for bug#3114604 , to consider other possibel cases for date overlapping
pkpatel 9-Nov-2004 Bug 3993967 (Stubbed the procedure since Start/End date of Residency is no longer needed)
***************************************************************** */
BEGIN
NULL;