DBA Data[Home] [Help]

APPS.PAY_US_ELEM_ENT_CHK_LEG_HOOK dependencies on PAY_SHADOW_ELEMENT_TYPES

Line 57: from pay_shadow_element_types pset,

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

Line 92: -- PAY_SHADOW_ELEMENT_TYPES for the Involuntary Deduction element

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,