DBA Data[Home] [Help]

APPS.HR_TEMPLATE_DATA_GROUPS_API dependencies on HR_SOURCE_FORM_TEMPLATES

Line 49: FROM hr_source_form_templates hsf

45:
46: CURSOR cur_api_val
47: IS
48: SELECT source_form_template_id
49: FROM hr_source_form_templates hsf
50: WHERE hsf.form_template_id_to = p_form_template_id;
51:
52: l_form_data_group_id number;
53: -- the next 2 local vars are used only for storing the unused values

Line 241: FROM hr_source_form_templates hsf

237:
238: CURSOR cur_api_val
239: IS
240: SELECT source_form_template_id
241: FROM hr_source_form_templates hsf
242: WHERE hsf.form_template_id_to = p_form_template_id;
243:
244: l_proc varchar2(72) := g_package||'create_template_data_group';
245: l_template_data_group_id number;

Line 422: FROM hr_source_form_templates hsf

418:
419: CURSOR cur_api_val
420: IS
421: SELECT source_form_template_id
422: FROM hr_source_form_templates hsf
423: ,hr_template_data_groups tdg
424: WHERE hsf.form_template_id_to = tdg.form_template_id
425: AND tdg.template_data_group_id = p_template_data_group_id;
426: