APPS.PER_QH_MAINTAIN_QUERY dependencies on HR_FORM_TEMPLATES_B

Line 37: from hr_form_templates_b hft

33: --
34: cursor csr_template(p_legislation_code varchar2) is
35: select
36: hft.form_template_id
37: from hr_form_templates_b hft
38: , fnd_form ff
39: where
40: ff.form_name='PERWSQHM'
41: and ff.application_id=800

Line 47: l_form_template_id hr_form_templates_b.form_template_id%type;

43: and hft.template_name=p_template_name
44: and (hft.legislation_code = p_legislation_code
45: or hft.legislation_code is null);
46: --
47: l_form_template_id hr_form_templates_b.form_template_id%type;
48: --
49: l_default_value VARCHAR2(2000);
50: --
51: CURSOR csr_template_items