APPS.HR_TIM_BUS dependencies on HR_FORM_ITEMS_B

Line 249: from hr_form_items_b fim

245: --
246: cursor csr_form_item is
247: select fim.application_id
248: ,fim.form_id
249: from hr_form_items_b fim
250: where fim.form_item_id = p_form_item_id;
251: --
252: cursor csr_form_template is
253: select tmp.application_id

Line 336: from hr_form_items_b fim

332: ) is
333: --
334: cursor csr_derive_item_name is
335: select fim.full_item_name
336: from 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

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_%'