DBA Data[Home] [Help]

APPS.HR_ITP_BUS dependencies on HR_ITEM_PROPERTIES_B

Line 61: ,hr_item_properties_b itp

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
64: and itp.item_property_id = p_item_property_id
65: union

Line 70: ,hr_item_properties_b itp

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
72: and tim.template_item_id = tic.template_item_id
73: and tic.template_item_context_id = itp.template_item_context_id
74: and itp.item_property_id = p_item_property_id;