APPS.PAY_TCO_BUS dependencies on PAY_SHADOW_ELEMENT_TYPES

Line 235: from pay_shadow_element_types pset

231: -- specified by template_id.
232: --
233: cursor csr_sf_belongs is
234: select null
235: from pay_shadow_element_types pset
236: where pset.template_id = p_template_id
237: and pset.payroll_formula_id = p_shadow_object_id;
238: --
239: cursor csr_sfiv_belongs is

Line 242: , pay_shadow_element_types pset

238: --
239: cursor csr_sfiv_belongs is
240: select null
241: from pay_shadow_input_values psiv
242: , pay_shadow_element_types pset
243: where pset.template_id = p_template_id
244: and pset.element_type_id = psiv.element_type_id
245: and psiv.formula_id = p_shadow_object_id;
246: --

Line 263: from pay_shadow_element_types pset

259: and sdb.defined_balance_id = p_shadow_object_id;
260: --
261: cursor csr_set_belongs is
262: select null
263: from pay_shadow_element_types pset
264: where pset.template_id = p_template_id
265: and pset.element_type_id = p_shadow_object_id;
266: --
267: cursor csr_ssr_belongs is

Line 269: from pay_shadow_element_types pset

265: and pset.element_type_id = p_shadow_object_id;
266: --
267: cursor csr_ssr_belongs is
268: select null
269: from pay_shadow_element_types pset
270: , pay_shadow_sub_classi_rules scr
271: where pset.template_id = p_template_id
272: and scr.element_type_id = pset.element_type_id
273: and scr.sub_classification_rule_id = p_shadow_object_id;

Line 285: from pay_shadow_element_types pset

281: and sbc.balance_classification_id = p_shadow_object_id;
282: --
283: cursor csr_siv_belongs is
284: select null
285: from pay_shadow_element_types pset
286: , pay_shadow_input_values siv
287: where pset.template_id = p_template_id
288: and siv.element_type_id = pset.element_type_id
289: and siv.input_value_id = p_shadow_object_id;

Line 293: from pay_shadow_element_types pset

289: and siv.input_value_id = p_shadow_object_id;
290: --
291: cursor csr_sbf_belongs is
292: select null
293: from pay_shadow_element_types pset
294: , pay_shadow_input_values siv
295: , pay_shadow_balance_feeds sbf
296: where pset.template_id = p_template_id
297: and siv.element_type_id = pset.element_type_id

Line 303: from pay_shadow_element_types pset

299: and sbf.balance_feed_id = p_shadow_object_id;
300: --
301: cursor csr_sfr_belongs is
302: select null
303: from pay_shadow_element_types pset
304: , pay_shadow_formula_rules sfr
305: where pset.template_id = p_template_id
306: and sfr.shadow_element_type_id = pset.element_type_id
307: and sfr.formula_result_rule_id = p_shadow_object_id;

Line 311: from pay_shadow_element_types pset

307: and sfr.formula_result_rule_id = p_shadow_object_id;
308: --
309: cursor csr_sir_belongs is
310: select null
311: from pay_shadow_element_types pset
312: , pay_shadow_iterative_rules sir
313: where pset.template_id = p_template_id
314: and sir.element_type_id = pset.element_type_id
315: and sir.iterative_rule_id = p_shadow_object_id;

Line 319: from pay_shadow_element_types pset

315: and sir.iterative_rule_id = p_shadow_object_id;
316: --
317: cursor csr_seu_belongs is
318: select null
319: from pay_shadow_element_types pset
320: , pay_shadow_ele_type_usages etu
321: where pset.template_id = p_template_id
322: and etu.element_type_id = pset.element_type_id
323: and etu.element_type_usage_id = p_shadow_object_id;

Line 327: from pay_shadow_element_types pset

323: and etu.element_type_usage_id = p_shadow_object_id;
324: --
325: cursor csr_sgb_belongs is
326: select null
327: from pay_shadow_element_types pset
328: , pay_shadow_gu_bal_exclusions sgb
329: where pset.template_id = p_template_id
330: and sgb.source_id = pset.element_type_id
331: and sgb.grossup_balances_id = p_shadow_object_id;

Line 420: l_table := 'PAY_SHADOW_ELEMENT_TYPES';

416: close csr_sdb_belongs;
417: elsif p_core_object_type = pay_tco_shd.g_set_lookup_type or
418: p_core_object_type = pay_tco_shd.g_spr_lookup_type
419: then
420: l_table := 'PAY_SHADOW_ELEMENT_TYPES';
421: open csr_set_belongs;
422: fetch csr_set_belongs into l_exists;
423: if csr_set_belongs%notfound then
424: close csr_set_belongs;