APPS.PQP_GB_OMP_TEMPLATE dependencies on PAY_ELEMENT_TEMPLATES

Line 88: l_source_template_id pay_element_templates.template_id%TYPE;

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) :=
91: g_proc_name || 'create_user_template';
92:

Line 93: l_template_name pay_element_templates.template_name%TYPE ;

89: l_object_version_number pay_element_types_f.object_version_number%TYPE;
90: l_proc_name VARCHAR2(80) :=
91: g_proc_name || 'create_user_template';
92:
93: l_template_name pay_element_templates.template_name%TYPE ;
94: l_days_hours VARCHAR2(10) ;
95:
96: l_element_type_id NUMBER;
97: l_balance_type_id NUMBER;

Line 115: l_base_name pay_element_templates.base_name%TYPE

111: y NUMBER := 0;
112: l_exists VARCHAR2(1);
113:
114: l_exc_sec_days_bf VARCHAR2(1);
115: l_base_name pay_element_templates.base_name%TYPE
116: := UPPER(TRANSLATE(TRIM(p_pri_ele_name),' ','_'));
117:
118: TYPE t_ele_name IS TABLE OF pay_element_types_f.element_name%TYPE
119: INDEX BY BINARY_INTEGER;

Line 246: FROM PAY_ELEMENT_TEMPLATES

242: p_template_name IN VARCHAR2
243: ,p_leg_code IN VARCHAR2
244: ) IS
245: SELECT template_id
246: FROM PAY_ELEMENT_TEMPLATES
247: WHERE template_name = p_template_name
248: AND legislation_code = p_leg_code
249: AND template_type = 'T'
250: AND business_group_id IS NULL;

Line 1713: FROM pay_element_templates pets

1709: CURSOR csr_chk_sec_ele (c_te_usrstr_id NUMBER
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

Line 1734: FROM pay_element_templates

1730: -- find the eei info
1731:
1732: CURSOR csr_get_template_id (p_template_name IN VARCHAR2) is
1733: SELECT template_id
1734: FROM pay_element_templates
1735: WHERE base_name = p_pri_ele_name
1736: AND template_name = p_template_name --'PQP OMP Template'
1737: AND business_group_id = p_business_group_id
1738: AND template_type = 'U';

Line 1740: l_template_name pay_element_templates.template_name%TYPE ;

1736: AND template_name = p_template_name --'PQP OMP Template'
1737: AND business_group_id = p_business_group_id
1738: AND template_type = 'U';
1739:
1740: l_template_name pay_element_templates.template_name%TYPE ;
1741:
1742: -- Cursor to retrieve lookup code for a given
1743: -- lookup type
1744:

Line 1775: -- ,pay_element_templates pet

1771: IS
1772: SELECT DISTINCT(pete.eei_information20) lookup_type
1773: FROM pay_element_type_extra_info pete
1774: ,pay_element_types_f petf
1775: -- ,pay_element_templates pet
1776: WHERE pete.element_type_id = petf.element_type_id
1777: AND pete.information_type = 'PQP_GB_OMP_ABSENCE_PLAN_INFO'
1778: AND pete.eei_information17 = 'Y'
1779: AND petf.element_name = c_base_name||p_days_hours|| ' OMP Absence'

Line 1789: FROM pay_element_templates pet

1785: ;
1786:
1787: CURSOR csr_template_names IS
1788: SELECT pet.base_name
1789: FROM pay_element_templates pet
1790: WHERE pet.template_name = p_template_name
1791: AND pet.template_type = 'U'
1792: AND pet.business_group_id = p_business_group_id ;
1793:

Line 1799: l_base_name pay_element_templates.base_name%TYPE ;

1795: l_number NUMBER;
1796: l_lookup_code fnd_lookup_values_vl.lookup_code%TYPE;
1797: l_lookup_type fnd_lookup_types_vl.lookup_type%TYPE;
1798: l_proc_name VARCHAR2(72) := g_proc_name || 'get_other_lookups';
1799: l_base_name pay_element_templates.base_name%TYPE ;
1800:
1801: --
1802: BEGIN
1803: