APPS.HR_SOURCE_FORM_TEMPLATES_PKG dependencies on HR_API
Line 236: and nvl(form_template_id_from,hr_api.g_number) = nvl(x_form_template_id_from,hr_api.g_number);
232: select source_form_template_id
233: into x_source_form_template_id
234: from hr_source_form_templates
235: where form_template_id_to = x_form_template_id_to 236: and nvl(form_template_id_from,hr_api.g_number) = nvl(x_form_template_id_from,hr_api.g_number); 237:
238: exception
239: when no_data_found then
240: select hr_source_form_templates_s.nextval