DBA Data[Home] [Help]

APPS.PAY_SET_BUS dependencies on PAY_TCO_SHD

Line 63: where (tco.core_object_type = pay_tco_shd.g_set_lookup_type or

59: --
60: cursor csr_disallow_update is
61: select null
62: from pay_template_core_objects tco
63: where (tco.core_object_type = pay_tco_shd.g_set_lookup_type or
64: tco.core_object_type = pay_tco_shd.g_spr_lookup_type)
65: and tco.shadow_object_id = p_rec.element_type_id;
66: --
67: l_proc varchar2(72) := g_package||'chk_non_updateable_args';

Line 64: tco.core_object_type = pay_tco_shd.g_spr_lookup_type)

60: cursor csr_disallow_update is
61: select null
62: from pay_template_core_objects tco
63: where (tco.core_object_type = pay_tco_shd.g_set_lookup_type or
64: tco.core_object_type = pay_tco_shd.g_spr_lookup_type)
65: and tco.shadow_object_id = p_rec.element_type_id;
66: --
67: l_proc varchar2(72) := g_package||'chk_non_updateable_args';
68: l_error exception;

Line 1046: where (tco.core_object_type = pay_tco_shd.g_set_lookup_type or

1042: --
1043: cursor csr_core_objects is
1044: select null
1045: from pay_template_core_objects tco
1046: where (tco.core_object_type = pay_tco_shd.g_set_lookup_type or
1047: tco.core_object_type = pay_tco_shd.g_spr_lookup_type)
1048: and tco.shadow_object_id = p_element_type_id;
1049: --
1050: cursor csr_formula_rules is

Line 1047: tco.core_object_type = pay_tco_shd.g_spr_lookup_type)

1043: cursor csr_core_objects is
1044: select null
1045: from pay_template_core_objects tco
1046: where (tco.core_object_type = pay_tco_shd.g_set_lookup_type or
1047: tco.core_object_type = pay_tco_shd.g_spr_lookup_type)
1048: and tco.shadow_object_id = p_element_type_id;
1049: --
1050: cursor csr_formula_rules is
1051: select null