APPS.PAY_TER_BUS dependencies on PAY_SHADOW_ELEMENT_TYPES

Line 114: from pay_shadow_element_types pset

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
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) =

Line 234: from pay_shadow_element_types pset

230: -- Cursors to check for rows referencing the exclusion rule.
231: --
232: cursor csr_element_types is
233: select null
234: from pay_shadow_element_types pset
235: where pset.exclusion_rule_id = p_exclusion_rule_id;
236: --
237: cursor csr_balance_types is
238: select null