DBA Data[Home] [Help]

APPS.HR_ITP_BUS dependencies on HR_FORM_TEMPLATES_B

Line 59: from hr_form_templates_b tmp

55: -- Declare cursor
56: --
57: cursor csr_leg_code is
58: select tmp.legislation_code
59: from hr_form_templates_b tmp
60: ,hr_template_items_b tim
61: ,hr_item_properties_b itp
62: where tmp.form_template_id = tim.form_template_id
63: and tim.template_item_id = itp.template_item_id

Line 67: from hr_form_templates_b tmp

63: and tim.template_item_id = itp.template_item_id
64: and itp.item_property_id = p_item_property_id
65: union
66: select tmp.legislation_code
67: from hr_form_templates_b tmp
68: ,hr_template_items_b tim
69: ,hr_template_item_contexts_b tic
70: ,hr_item_properties_b itp
71: where tmp.form_template_id = tim.form_template_id