APPS.HR_TEMPLATE_DATA_GROUPS_API dependencies on HR_TEMPLATE_ITEMS_B

Line 30: -- Bug # 3648566. Modified the cursor text to use base table hr_template_items_b

26: SELECT tdg.form_data_group_id
27: FROM hr_template_data_groups tdg
28: WHERE tdg.template_data_group_id = p_template_data_group_id_from;
29:
30: -- Bug # 3648566. Modified the cursor text to use base table hr_template_items_b
31: -- instead of view hr_template_items.
32: CURSOR cur_tmplt_item
33: IS
34: SELECT tit1.template_item_id

Line 35: FROM hr_template_items_b tit2

31: -- instead of view hr_template_items.
32: CURSOR cur_tmplt_item
33: IS
34: SELECT tit1.template_item_id
35: FROM hr_template_items_b tit2
36: ,hr_template_items_b tit1
37: ,hr_template_data_groups tdg
38: WHERE tit2.template_item_id IS NULL
39: AND tit2.form_template_id (+) = p_form_template_id

Line 36: ,hr_template_items_b tit1

32: CURSOR cur_tmplt_item
33: IS
34: SELECT tit1.template_item_id
35: FROM hr_template_items_b tit2
36: ,hr_template_items_b tit1
37: ,hr_template_data_groups tdg
38: WHERE tit2.template_item_id IS NULL
39: AND tit2.form_template_id (+) = p_form_template_id
40: AND tit2.form_item_id (+) = tit1.form_item_id