APPS.PAY_SIV_BUS dependencies on PAY_SHADOW_INPUT_VALUES

Line 198: from pay_shadow_input_values siv

194: -- already has.
195: --
196: cursor csr_input_value_count is
197: select count(siv.input_value_id)
198: from pay_shadow_input_values siv
199: where siv.element_type_id = p_element_type_id
200: and siv.exclusion_rule_id is null
201: ;
202: --

Line 446: from pay_shadow_input_values siv

442: -- element type.
443: --
444: cursor csr_name_exists is
445: select null
446: from pay_shadow_input_values siv
447: where siv.element_type_id = p_element_type_id
448: and upper(siv.name) = upper(p_name);
449: --
450: l_proc varchar2(72) := g_package||'chk_name';

Line 898: , pay_shadow_input_values psiv

894: --
895: cursor csr_inconsistent_def_val is
896: select null
897: from pay_shadow_element_types pset
898: , pay_shadow_input_values psiv
899: where pset.template_id = p_template_id
900: and psiv.element_type_id = pset.element_type_id
901: and nvl(upper(psiv.default_value_column), hr_api.g_varchar2) =
902: upper(p_default_value_column)

Line 1152: from pay_shadow_input_values psiv , pay_shadow_element_types pset

1148: and sf.formula_type_name = pay_sf_shd.g_input_val_formula_type
1149: and sf.business_group_id = p_business_group_id
1150: and not exists
1151: (select null
1152: from pay_shadow_input_values psiv , pay_shadow_element_types pset
1153: where psiv.formula_id = p_formula_id
1154: and pset.element_type_id = psiv.element_type_id
1155: and pset.template_id <> p_template_id);
1156: --