APPS.HR_TMPLT dependencies on HR_FORM_TEMPLATES_B

Line 148: from hr_form_templates_b

144: l_return := null;
145: else
146: select template_name
147: into l_return
148: from hr_form_templates_b
149: where form_template_id = p_form_template_id;
150: end if;
151: return l_return;
152: end get_template_name;

Line 165: from hr_form_templates_b hft,

161: l_return := null;
162: else
163: select application_short_name
164: into l_return
165: from hr_form_templates_b hft,
166: fnd_application fa
167: where hft.form_template_id = p_form_template_id
168: and fa.application_id = hft.application_id;
169: end if;

Line 184: from hr_form_templates_b hft,

180: l_return := null;
181: else
182: select form_name
183: into l_return
184: from hr_form_templates_b hft,
185: fnd_form ff
186: where hft.form_template_id = p_form_template_id
187: and ff.application_id = hft.application_id
188: and ff.form_id = hft.form_id;