APPS.PAY_TER_BUS dependencies on PAY_SHADOW_INPUT_VALUES

Line 110: -- a default value column in PAY_SHADOW_INPUT_VALUES.

106: ,p_object_version_number in number
107: ) is
108: --
109: -- Cursor to ensure that the flexfield column is not being used as
110: -- a default value column in PAY_SHADOW_INPUT_VALUES.
111: --
112: cursor csr_default_value_clash is
113: select null
114: from pay_shadow_element_types pset

Line 115: , pay_shadow_input_values psiv

111: --
112: cursor csr_default_value_clash is
113: select null
114: from pay_shadow_element_types pset
115: , pay_shadow_input_values psiv
116: where pset.template_id = p_template_id
117: and psiv.element_type_id = pset.element_type_id
118: and nvl(upper(psiv.default_value_column), hr_api.g_varchar2) =
119: upper(p_flexfield_column);

Line 176: -- PAY_SHADOW_INPUT_VALUES.

172: fnd_message.raise_error;
173: end;
174: --
175: -- Check that there are no clashes with default_value columns in
176: -- PAY_SHADOW_INPUT_VALUES.
177: --
178: open csr_default_value_clash;
179: fetch csr_default_value_clash into l_clash;
180: if csr_default_value_clash%found then

Line 244: from pay_shadow_input_values siv

240: where sbt.exclusion_rule_id = p_exclusion_rule_id;
241: --
242: cursor csr_input_values is
243: select null
244: from pay_shadow_input_values siv
245: where siv.exclusion_rule_id = p_exclusion_rule_id;
246: --
247: cursor csr_balance_feeds is
248: select null