DBA Data[Home] [Help]

APPS.HR_FORM_PROPERTIES_PKG dependencies on HR_FORM_TEMPLATES_B

Line 191: p_ref_entity => 'HR_FORM_TEMPLATES_B',

187:
188: BEGIN
189: PER_RIC_PKG.chk_integrity (
190: p_entity_name => 'HR_FORM_PROPERTIES',
191: p_ref_entity => 'HR_FORM_TEMPLATES_B',
192: p_ref_column_name => 'FORM_TEMPLATE_ID',
193: p_ref_col_value_number => X_FORM_TEMPLATE_ID,
194: p_ref_col_value_varchar => NULL,
195: p_ref_col_value_date => NULL,

Line 633: from hr_form_templates_b

629: IF ltrim(rtrim(x_template_name)) is not null then
630:
631: select form_template_id
632: into x_form_template_id
633: from hr_form_templates_b
634: where application_id = X_APPLICATION_ID
635: and form_id = X_FORM_ID
636: and template_name = X_TEMPLATE_NAME
637: and ( (legislation_code is null and x_territory_short_name is null)