APPS.PAY_TCO_BUS dependencies on PAY_SHADOW_GU_BAL_EXCLUSIONS

Line 328: , pay_shadow_gu_bal_exclusions sgb

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;
332: --

Line 492: l_table := 'PAY_SHADOW_GU_BAL_EXCLUSIONS';

488: raise l_error;
489: end if;
490: close csr_seu_belongs;
491: elsif p_core_object_type = pay_tco_shd.g_sgb_lookup_type then
492: l_table := 'PAY_SHADOW_GU_BAL_EXCLUSIONS';
493: open csr_sgb_belongs;
494: fetch csr_sgb_belongs into l_exists;
495: if csr_sgb_belongs%notfound then
496: close csr_sgb_belongs;