APPS.PAY_SIR_BUS dependencies on PAY_SHADOW_ELEMENT_TYPES

Line 89: from pay_shadow_element_types pset

85: -- Cursor to check that the element type exists.
86: --
87: cursor c_element_type_exists is
88: select null
89: from pay_shadow_element_types pset
90: where pset.element_type_id = p_element_type_id;
91: --
92: l_proc varchar2(72) := g_package||'chk_element_type_id';
93: l_exists varchar2(1);

Line 179: from pay_shadow_element_types pset

175: -- template as the element type).
176: --
177: cursor c_input_value_exists is
178: select null
179: from pay_shadow_element_types pset
180: , pay_shadow_element_types pset1
181: , pay_shadow_input_values psiv
182: where pset.element_type_id = p_element_type_id
183: and pset1.template_id = pset.template_id

Line 180: , pay_shadow_element_types pset1

176: --
177: cursor c_input_value_exists is
178: select null
179: from pay_shadow_element_types pset
180: , pay_shadow_element_types pset1
181: , pay_shadow_input_values psiv
182: where pset.element_type_id = p_element_type_id
183: and pset1.template_id = pset.template_id
184: and psiv.input_value_id = p_input_value_id

Line 325: from pay_shadow_element_types pset

321: -- Cursor to check that the exclusion rule is valid.
322: --
323: cursor c_exclusion_rule_is_valid is
324: select null
325: from pay_shadow_element_types pset
326: , pay_template_exclusion_rules ter
327: where pset.element_type_id = p_element_type_id
328: and ter.template_id = pset.template_id
329: and ter.exclusion_rule_id = p_exclusion_rule_id;