APPS.PAY_SSR_BUS dependencies on PAY_SHADOW_ELEMENT_TYPES

Line 25: , pay_shadow_element_types bt

21: --
22: cursor csr_exclusion_rule_id_valid is
23: select null
24: from pay_template_exclusion_rules ter
25: , pay_shadow_element_types bt
26: where bt.element_type_id = p_element_type_id
27: and ter.exclusion_rule_id = p_exclusion_rule_id
28: and ter.template_id = bt.template_id
29: ;

Line 179: from pay_shadow_element_types sbt

175: -- Cursor to check that the element type exists.
176: --
177: cursor csr_element_type_exists is
178: select null
179: from pay_shadow_element_types sbt
180: where sbt.element_type_id = p_element_type_id;
181: --
182: l_proc varchar2(72) := g_package||'chk_element_type_id';
183: l_exists varchar2(1);