DBA Data[Home] [Help]

APPS.HR_SOURCE_FORM_TEMPLATES_PKG dependencies on HR_FORM_TEMPLATES_B

Line 174: from hr_form_templates_b

170: and application_id = x_application_id;
171:
172: select form_template_id
173: into x_form_template_id_to
174: from hr_form_templates_b
175: where template_name = x_template_name_to
176: and ( (legislation_code is null and x_territory_short_name_to is null)
177: or (legislation_code = x_territory_short_name_to) )
178: and application_id = x_application_id

Line 198: from hr_form_templates_b

194: and application_id = x_application_id;
195:
196: select form_template_id
197: into x_form_template_id_from
198: from hr_form_templates_b
199: where template_name = x_template_name_from
200: and ( (legislation_code is null and x_territory_short_name_from is null)
201: or (legislation_code = x_territory_short_name_from) )
202: and application_id = x_application_id