APPS.PQP_GB_OSP_TEMPLATE dependencies on PAY_SHADOW_ELEMENT_TYPES

Line 705: l_template_id pay_shadow_element_types.template_id%TYPE;

701: ----------------------------------------------------------------------*/
702: --
703:
704:
705: l_template_id pay_shadow_element_types.template_id%TYPE;
706: l_base_element_type_id pay_template_core_objects.core_object_id%TYPE;
707: l_source_template_id pay_element_templates.template_id%TYPE;
708: l_object_version_number pay_element_types_f.object_version_number%TYPE;
709:

Line 870: FROM pay_shadow_element_types

866:
867: CURSOR csr_get_ele_info (c_ele_name varchar2) is
868: SELECT element_type_id
869: ,object_version_number
870: FROM pay_shadow_element_types
871: WHERE template_id = l_template_id
872: AND element_name = c_ele_name;
873:
874: CURSOR csr_get_bal_info (c_bal_name varchar2) is

Line 3321: ,pay_shadow_element_types pset

3317: ,p_days_hours VARCHAR2
3318: ) IS
3319: SELECT 'X'
3320: FROM pay_element_templates pets
3321: ,pay_shadow_element_types pset
3322: ,pay_template_core_objects ptco
3323: ,pay_element_type_extra_info peei
3324: WHERE pets.template_id <> c_te_usrstr_id
3325: -- For the given user structure