APPS.PAY_SSR_BUS dependencies on PAY_TCO_SHD

Line 71: where tco.core_object_type = pay_tco_shd.g_ssr_lookup_type

67: --
68: cursor csr_core_objects is
69: select null
70: from pay_template_core_objects tco
71: where tco.core_object_type = pay_tco_shd.g_ssr_lookup_type
72: and tco.shadow_object_id = p_sub_classification_rule_id;
73: --
74: l_proc varchar2(72) := g_package||'chk_delete';
75: l_error exception;

Line 111: where tco.core_object_type = pay_tco_shd.g_ssr_lookup_type

107: --
108: cursor csr_disallow_update is
109: select null
110: from pay_template_core_objects tco
111: where tco.core_object_type = pay_tco_shd.g_ssr_lookup_type
112: and tco.shadow_object_id = p_rec.sub_classification_rule_id;
113: --
114: l_proc varchar2(72) := g_package||'chk_non_updateable_args';
115: l_updating boolean;