APPS.PAY_SGB_BUS dependencies on PAY_SHADOW_ELEMENT_TYPES

Line 91: from pay_shadow_element_types pset

87: -- Cursor to check that the source_id references an existing element type
88: --
89: cursor c_element_type_exists is
90: select null
91: from pay_shadow_element_types pset
92: where pset.element_type_id = p_source_id;
93: --
94: l_proc varchar2(72) := g_package||'chk_source_id';
95: l_exists varchar2(1);

Line 181: , pay_shadow_element_types pset

177: --
178: cursor c_bal_type_id_valid is
179: select null
180: from pay_shadow_balance_types sbt
181: , pay_shadow_element_types pset
182: where sbt.balance_type_id = p_balance_type_id
183: and sbt.template_id = pset.template_id
184: and pset.element_type_id = p_source_id;
185: --

Line 239: from pay_shadow_element_types pset

235: -- Cursor to check that the exclusion_rule_id is valid.
236: --
237: cursor c_exclusion_rule_id_valid is
238: select null
239: from pay_shadow_element_types pset
240: , pay_template_exclusion_rules ter
241: where ter.exclusion_rule_id = p_exclusion_rule_id
242: and ter.template_id = pset.template_id
243: and pset.element_type_id = p_source_id;