592: ,DECODE(p_information28,hr_api.g_varchar2,fmp.information28,p_information28)
593: ,DECODE(p_information29,hr_api.g_varchar2,fmp.information29,p_information29)
594: ,DECODE(p_information30,hr_api.g_varchar2,fmp.information30,p_information30)
595: FROM hr_form_properties fmp
596: , fnd_application fnd
597: WHERE fmp.application_id (+) = fnd.application_id
598: AND fnd.application_id = p_application_id
599: AND fmp.form_id (+) = p_form_id;
600:
593: ,DECODE(p_information29,hr_api.g_varchar2,fmp.information29,p_information29)
594: ,DECODE(p_information30,hr_api.g_varchar2,fmp.information30,p_information30)
595: FROM hr_form_properties fmp
596: , fnd_application fnd
597: WHERE fmp.application_id (+) = fnd.application_id
598: AND fnd.application_id = p_application_id
599: AND fmp.form_id (+) = p_form_id;
600:
601: CURSOR cur_check
594: ,DECODE(p_information30,hr_api.g_varchar2,fmp.information30,p_information30)
595: FROM hr_form_properties fmp
596: , fnd_application fnd
597: WHERE fmp.application_id (+) = fnd.application_id
598: AND fnd.application_id = p_application_id
599: AND fmp.form_id (+) = p_form_id;
600:
601: CURSOR cur_check
602: IS