APPS.PAY_TER_SHD dependencies on PAY_TEMPLATE_EXCLUSION_RULES

Line 61: from pay_template_exclusion_rules

57: flexfield_column,
58: exclusion_value,
59: description,
60: object_version_number
61: from pay_template_exclusion_rules
62: where exclusion_rule_id = p_exclusion_rule_id;
63: --
64: l_proc varchar2(72) := g_package||'api_updating';
65: l_fct_ret boolean;

Line 136: from pay_template_exclusion_rules

132: flexfield_column,
133: exclusion_value,
134: description,
135: object_version_number
136: from pay_template_exclusion_rules
137: where exclusion_rule_id = p_exclusion_rule_id
138: for update nowait;
139: --
140: l_proc varchar2(72) := g_package||'lck';

Line 185: hr_utility.set_message_token('TABLE_NAME', 'pay_template_exclusion_rules');

181: -- The object is locked therefore we need to supply a meaningful
182: -- error message.
183: --
184: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
185: hr_utility.set_message_token('TABLE_NAME', 'pay_template_exclusion_rules');
186: hr_utility.raise_error;
187: End lck;
188: --
189: -- ----------------------------------------------------------------------------