DBA Data[Home] [Help]

APPS.HR_TIM_BUS dependencies on HR_FORM_TEMPLATES_B

Line 51: from hr_form_templates_b tmp

47: -- Declare cursor
48: --
49: cursor csr_leg_code is
50: select tmp.legislation_code
51: from hr_form_templates_b tmp
52: ,hr_template_items_b tim
53: where tmp.form_template_id = tim.form_template_id
54: and tim.template_item_id = p_template_item_id;
55: --

Line 255: from hr_form_templates_b tmp

251: --
252: cursor csr_form_template is
253: select tmp.application_id
254: ,tmp.form_id
255: from hr_form_templates_b tmp
256: where tmp.form_template_id = p_form_template_id;
257: --
258: l_proc varchar2(72) := g_package || 'chk_item_and_template';
259: l_api_updating boolean;