APPS.HR_TIM_BUS dependencies on HR_TEMPLATE_ITEMS_B

Line 52: ,hr_template_items_b tim

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: --
56: -- Declare local variables

Line 341: from hr_template_items_b tim, hr_form_items_b fim

337: where fim.form_item_id = p_form_item_id;
338: --
339: cursor csr_flex_on_template(p_block varchar2, p_flex_name varchar2) is
340: select 1
341: from hr_template_items_b tim, hr_form_items_b fim
342: where tim.form_item_id = fim.form_item_id
343: and tim.form_template_id = p_form_template_id
344: and fim.full_item_name = p_block||'.'||p_flex_name;
345: --

Line 348: from hr_template_items_b tim, hr_form_items_b fim

344: and fim.full_item_name = p_block||'.'||p_flex_name;
345: --
346: cursor csr_segment_on_template(p_block varchar2, p_segment varchar2) is
347: select 1
348: from hr_template_items_b tim, hr_form_items_b fim
349: where tim.form_item_id = fim.form_item_id
350: and tim.form_template_id = p_form_template_id
351: and fim.full_item_name like p_block||'.'||p_segment||'%';
352: --

Line 360: from hr_template_items_b tim, hr_form_items_b fim

356: -- 'COUNTRY_OF_BIRTH','REGION_OF_BIRTH', 'COUNTRYn_MEANING'
357: --
358: cursor csr_address_segs_exist(p_block varchar2) is
359: select 1
360: from hr_template_items_b tim, hr_form_items_b fim
361: where tim.form_item_id = fim.form_item_id
362: and tim.form_template_id = p_form_template_id
363: and ((fim.full_item_name like p_block||'.ADDRESS_LINE%'
364: or fim.full_item_name like p_block||'.REGION_%'