APPS.PQP_GB_UNPAID_TEMPLATE dependencies on PAY_SHADOW_ELEMENT_TYPES

Line 862: l_template_id pay_shadow_element_types.template_id%TYPE;

858: ----------------------------------------------------------------------*/
859: --
860:
861:
862: l_template_id pay_shadow_element_types.template_id%TYPE;
863: l_base_element_type_id pay_template_core_objects.core_object_id%TYPE;
864: l_source_template_id pay_element_templates.template_id%TYPE;
865: l_object_version_number pay_element_types_f.object_version_number%TYPE;
866:

Line 948: FROM pay_shadow_element_types

944:
945: CURSOR csr_get_ele_info (c_ele_name varchar2) is
946: SELECT element_type_id
947: ,object_version_number
948: FROM pay_shadow_element_types
949: WHERE template_id = l_template_id
950: AND element_name = c_ele_name;
951:
952: CURSOR csr_get_bal_info (c_bal_name varchar2) is

Line 2034: ,pay_shadow_element_types pset

2030: ,p_template_name VARCHAR2
2031: ) IS
2032: SELECT 'X'
2033: FROM pay_element_templates pets
2034: ,pay_shadow_element_types pset
2035: ,pay_template_core_objects ptco
2036: ,pay_element_type_extra_info peei
2037: WHERE pets.template_id <> c_te_usrstr_id
2038: -- For the given user structure