APPS.PAY_SFR_BUS dependencies on PAY_SHADOW_ELEMENT_TYPES

Line 91: from pay_shadow_element_types pset

87: -- Cursor to check that the element type exists.
88: --
89: cursor csr_shadow_element_type_exists is
90: select null
91: from pay_shadow_element_types pset
92: where pset.element_type_id = p_shadow_element_type_id;
93: --
94: l_proc varchar2(72) := g_package||'chk_shadow_element_type_id';
95: l_exists varchar2(1);

Line 188: from pay_shadow_element_types pset

184: -- template as the shadow element type).
185: --
186: cursor csr_element_type_exists is
187: select null
188: from pay_shadow_element_types pset
189: , pay_shadow_element_types pset1
190: where pset.element_type_id = p_shadow_element_type_id
191: and pset1.element_type_id = p_element_type_id
192: and pset1.template_id = pset.template_id;

Line 189: , pay_shadow_element_types pset1

185: --
186: cursor csr_element_type_exists is
187: select null
188: from pay_shadow_element_types pset
189: , pay_shadow_element_types pset1
190: where pset.element_type_id = p_shadow_element_type_id
191: and pset1.element_type_id = p_element_type_id
192: and pset1.template_id = pset.template_id;
193: --

Line 250: from pay_shadow_element_types pset

246: -- template as the shadow element type).
247: --
248: cursor csr_input_value_exists is
249: select null
250: from pay_shadow_element_types pset
251: , pay_shadow_element_types pset1
252: , pay_shadow_input_values psiv
253: where pset.element_type_id = p_shadow_element_type_id
254: and pset1.template_id = pset.template_id

Line 251: , pay_shadow_element_types pset1

247: --
248: cursor csr_input_value_exists is
249: select null
250: from pay_shadow_element_types pset
251: , pay_shadow_element_types pset1
252: , pay_shadow_input_values psiv
253: where pset.element_type_id = p_shadow_element_type_id
254: and pset1.template_id = pset.template_id
255: and psiv.input_value_id = p_input_value_id

Line 413: from pay_shadow_element_types pset

409: -- Cursor to check that the exclusion_rule_id is valid.
410: --
411: cursor csr_exclusion_rule_id_valid is
412: select null
413: from pay_shadow_element_types pset
414: , pay_template_exclusion_rules ter
415: where pset.element_type_id = p_shadow_element_type_id
416: and ter.template_id = pset.template_id
417: and ter.exclusion_rule_id = p_exclusion_rule_id;