APPS.PQP_GB_PENSIONS_TEMPLATE dependencies on PAY_SHADOW_ELEMENT_TYPES

Line 65: l_template_id pay_shadow_element_types.template_id%TYPE;

61: p_ele_eff_end_date (D) - Trunc(end date)
62: p_bg_id (N) - Business group id
63: ----------------------------------------------------------------------*/
64: --
65: l_template_id pay_shadow_element_types.template_id%TYPE;
66: l_base_element_type_id pay_template_core_objects.core_object_id%TYPE;
67: l_source_template_id pay_element_templates.template_id%TYPE;
68: l_object_version_number NUMBER(9);
69: l_proc VARCHAR2(80) :=

Line 123: FROM pay_shadow_element_types

119: l_sub t_sub_ele;
120:
121: CURSOR c1 (c_ele_name varchar2) is
122: SELECT element_type_id, object_version_number
123: FROM pay_shadow_element_types
124: WHERE template_id = l_template_id
125: AND element_name = c_ele_name;
126: --
127: -- cursor to fetch the core element id

Line 131: FROM pay_shadow_element_types psbt,

127: -- cursor to fetch the core element id
128: --
129: CURSOR c5 (c_element_name in varchar2) is
130: SELECT ptco.core_object_id
131: FROM pay_shadow_element_types psbt,
132: pay_template_core_objects ptco
133: WHERE psbt.template_id = l_template_id
134: AND psbt.element_name = c_element_name
135: AND ptco.template_id = psbt.template_id