53: -- Cursor to check the architecture used for the element created
54: CURSOR c_get_template_id(cp_element_name varchar2,
55: cp_business_group_id number) IS
56: select pset.template_id
57: from pay_shadow_element_types pset,
58: pay_element_templates pet
59: where pet.template_id = pset.template_id
60: and pet.template_type = 'U'
61: and pset.element_name = cp_element_name
88:
89: -- Code to get the architecture used for creating the element
90: -- currently being entered.
91: -- If we are able to find a template in the
92: -- PAY_SHADOW_ELEMENT_TYPES for the Involuntary Deduction element
93: -- being added, then the element was created using the new architecture.
94: open c_curr_elem_arch();
95: fetch c_curr_elem_arch into lv_element_name,
96: lv_elem_upg,