APPS.PQP_GB_OMP_TEMPLATE dependencies on PAY_SHADOW_ELEMENT_TYPES

Line 86: l_template_id pay_shadow_element_types.template_id%TYPE;

82: p_abse_type_lookup_value (C) - Collection of Absence Types
83: p_bg_id (N) - Business Group id
84: ----------------------------------------------------------------------*/
85: --
86: l_template_id pay_shadow_element_types.template_id%TYPE;
87: l_base_element_type_id pay_template_core_objects.core_object_id%TYPE;
88: l_source_template_id pay_element_templates.template_id%TYPE;
89: l_object_version_number pay_element_types_f.object_version_number%TYPE;
90: l_proc_name VARCHAR2(80) :=

Line 202: FROM pay_shadow_element_types

198:
199: CURSOR csr_get_ele_info (c_ele_name varchar2) is
200: SELECT element_type_id
201: ,object_version_number
202: FROM pay_shadow_element_types
203: WHERE template_id = l_template_id
204: AND element_name = c_ele_name;
205:
206: CURSOR csr_get_bal_info (c_bal_name varchar2) is

Line 1714: ,pay_shadow_element_types pset

1710: ,c_template_name VARCHAR2
1711: ,c_days_hours VARCHAR2) IS
1712: SELECT 'x'
1713: FROM pay_element_templates pets
1714: ,pay_shadow_element_types pset
1715: ,pay_template_core_objects ptco
1716: ,pay_element_type_extra_info peei
1717: WHERE pets.template_id <> c_te_usrstr_id
1718: -- For the given user structure