APPS.HR_FORM_PROPERTIES_BSI dependencies on HR_FORM_TEMPLATES

Line 604: FROM hr_form_templates tmp

600:
601: CURSOR cur_check
602: IS
603: SELECT 1
604: FROM hr_form_templates tmp
605: WHERE tmp.form_template_id = p_form_template_id
606: AND tmp.application_id = p_application_id
607: AND tmp.form_id = p_form_id;
608:

Line 846: ,hr_form_templates_b hft

842: ,DECODE(p_information28,hr_api.g_varchar2,fmp.information28,p_information28)
843: ,DECODE(p_information29,hr_api.g_varchar2,fmp.information29,p_information29)
844: ,DECODE(p_information30,hr_api.g_varchar2,fmp.information30,p_information30)
845: FROM hr_form_properties fmp
846: ,hr_form_templates_b hft
847: WHERE fmp.form_template_id (+) = hft.form_template_id
848: AND hft.form_template_id = p_form_template_id_from;
849:
850: --

Line 855: FROM hr_form_templates tmp

851: CURSOR cur_check
852: IS
853: SELECT tmp.application_id
854: ,tmp.form_id
855: FROM hr_form_templates tmp
856: WHERE tmp.form_template_id = p_form_template_id_from
857: INTERSECT
858: SELECT tmp.application_id
859: ,tmp.form_id

Line 860: FROM hr_form_templates tmp

856: WHERE tmp.form_template_id = p_form_template_id_from
857: INTERSECT
858: SELECT tmp.application_id
859: ,tmp.form_id
860: FROM hr_form_templates tmp
861: WHERE tmp.form_template_id = p_form_template_id_to;
862:
863: l_application_id number;
864: l_form_id number;