APPS.HR_SOURCE_FORM_TEMPLATES_PKG dependencies on HR_FORM_TEMPLATES_B

Line 47: p_ref_entity => 'HR_FORM_TEMPLATES_B',

43:
44: BEGIN
45: PER_RIC_PKG.chk_integrity (
46: p_entity_name => 'HR_SOURCE_FORM_TEMPLATES',
47: p_ref_entity => 'HR_FORM_TEMPLATES_B',
48: p_ref_column_info => PER_RIC_PKG.column_info_tbl(
49: PER_RIC_PKG.col_info_rec('FORM_TEMPLATE_ID',NULL,X_FORM_TEMPLATE_ID_TO,NULL),
50: PER_RIC_PKG.col_info_rec('FORM_TEMPLATE_ID',NULL,X_FORM_TEMPLATE_ID_FROM,NULL)
51: ),

Line 195: from hr_form_templates_b

191: and application_id = x_application_id;
192:
193: select form_template_id
194: into x_form_template_id_to
195: from hr_form_templates_b
196: where template_name = x_template_name_to
197: and ( (legislation_code is null and x_territory_short_name_to is null)
198: or (legislation_code = x_territory_short_name_to) )
199: and application_id = x_application_id

Line 219: from hr_form_templates_b

215: and application_id = x_application_id;
216:
217: select form_template_id
218: into x_form_template_id_from
219: from hr_form_templates_b
220: where template_name = x_template_name_from
221: and ( (legislation_code is null and x_territory_short_name_from is null)
222: or (legislation_code = x_territory_short_name_from) )
223: and application_id = x_application_id