APPS.PAY_TCO_BUS dependencies on PAY_SHADOW_INPUT_VALUES

Line 241: from pay_shadow_input_values psiv

237: and pset.payroll_formula_id = p_shadow_object_id;
238: --
239: cursor csr_sfiv_belongs is
240: select null
241: from pay_shadow_input_values psiv
242: , pay_shadow_element_types pset
243: where pset.template_id = p_template_id
244: and pset.element_type_id = psiv.element_type_id
245: and psiv.formula_id = p_shadow_object_id;

Line 286: , pay_shadow_input_values siv

282: --
283: cursor csr_siv_belongs is
284: select null
285: from pay_shadow_element_types pset
286: , pay_shadow_input_values siv
287: where pset.template_id = p_template_id
288: and siv.element_type_id = pset.element_type_id
289: and siv.input_value_id = p_shadow_object_id;
290: --

Line 294: , pay_shadow_input_values siv

290: --
291: cursor csr_sbf_belongs is
292: select null
293: from pay_shadow_element_types pset
294: , pay_shadow_input_values siv
295: , pay_shadow_balance_feeds sbf
296: where pset.template_id = p_template_id
297: and siv.element_type_id = pset.element_type_id
298: and sbf.input_value_id = siv.input_value_id

Line 447: l_table := 'PAY_SHADOW_INPUT_VALUES';

443: raise l_error;
444: end if;
445: close csr_sbc_belongs;
446: elsif p_core_object_type = pay_tco_shd.g_siv_lookup_type then
447: l_table := 'PAY_SHADOW_INPUT_VALUES';
448: open csr_siv_belongs;
449: fetch csr_siv_belongs into l_exists;
450: if csr_siv_belongs%notfound then
451: close csr_siv_belongs;