APPS.PQP_GB_PENSIONS_TEMPLATE dependencies on PAY_ELEMENT_TEMPLATES

Line 67: l_source_template_id pay_element_templates.template_id%TYPE;

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) :=
70: 'pqp_gb_pensions_template.create_user_template';
71: l_flat_rate VARCHAR2(3);

Line 151: FROM pay_element_templates

147: l_proc varchar2(60) := 'pqp_gb_pensions_template.get_template_id';
148: --
149: CURSOR c4 is
150: SELECT template_id
151: FROM pay_element_templates
152: WHERE template_name = l_template_name
153: AND legislation_code = p_legislation_code
154: AND template_type = 'T'
155: AND business_group_id is NULL;

Line 724: FROM pay_element_templates

720:
721:
722: CURSOR c1 is
723: SELECT template_id
724: FROM pay_element_templates
725: WHERE base_name = p_ele_name
726: AND business_group_id = p_business_group_id
727: AND template_type = 'U';
728: --