APPS.PAY_SBF_BUS dependencies on PAY_SHADOW_INPUT_VALUES

Line 22: from pay_shadow_input_values siv

18: -- Cursor to get the template information.
19: --
20: cursor csr_get_template_info is
21: select pet.template_id
22: from pay_shadow_input_values siv
23: , pay_shadow_element_types pset
24: , pay_element_templates pet
25: where siv.input_value_id = p_input_value_id
26: and pset.element_type_id = siv.element_type_id

Line 121: from pay_shadow_input_values siv

117: -- Cursor to check that the element type exists.
118: --
119: cursor csr_input_value_exists is
120: select null
121: from pay_shadow_input_values siv
122: where siv.input_value_id = p_input_value_id;
123: --
124: l_proc varchar2(72) := g_package||'chk_input_value_id';
125: l_exists varchar2(1);

Line 177: from pay_shadow_input_values siv

173: -- the input value (same uom and from the same template).
174: --
175: cursor csr_compatible is
176: select null
177: from pay_shadow_input_values siv
178: , pay_shadow_balance_types sbt
179: where siv.input_value_id = p_input_value_id
180: and sbt.balance_type_id = p_balance_type_id
181: and upper(siv.uom) = upper(sbt.balance_uom)