APPS.PQP_GB_PROFESSIONAL_BODY_TEMP dependencies on PAY_ELEMENT_TEMPLATES

Line 45: l_source_template_id pay_element_templates.template_id%TYPE;

41: ----------------------------------------------------------------------*/
42: --
43: l_template_id pay_shadow_element_types.template_id%TYPE;
44: l_base_element_type_id pay_template_core_objects.core_object_id%TYPE;
45: l_source_template_id pay_element_templates.template_id%TYPE;
46: l_object_version_number NUMBER(9);
47: l_proc VARCHAR2(80) :=
48: 'pqp_gb_professional_body_temp.create_user_template';
49: l_override_amount VARCHAR2(1);

Line 155: FROM pay_element_templates

151: l_proc varchar2(60) := 'pqp_gb_professional_body_temp.get_template_id';
152: --
153: CURSOR csr_get_temp_id is
154: SELECT template_id
155: FROM pay_element_templates
156: WHERE template_name = l_template_name
157: AND legislation_code = p_legislation_code
158: AND template_type = 'T'
159: AND business_group_id is NULL;

Line 648: FROM pay_element_templates

644:
645:
646: CURSOR csr_get_template_id is
647: SELECT template_id
648: FROM pay_element_templates
649: WHERE base_name = p_ele_name
650: AND business_group_id = p_business_group_id
651: AND template_type = 'U';
652:

Line 655: FROM pay_element_templates usr_this

651: AND template_type = 'U';
652:
653: CURSOR csr_get_other_tempid (c_te_usrstr_id NUMBER) IS
654: SELECT usr_others.template_id
655: FROM pay_element_templates usr_this
656: ,pay_element_templates usr_others
657: WHERE usr_this.template_id = c_te_usrstr_id
658: AND usr_others.template_name = usr_this.template_name
659: AND usr_others.template_type = 'U'

Line 656: ,pay_element_templates usr_others

652:
653: CURSOR csr_get_other_tempid (c_te_usrstr_id NUMBER) IS
654: SELECT usr_others.template_id
655: FROM pay_element_templates usr_this
656: ,pay_element_templates usr_others
657: WHERE usr_this.template_id = c_te_usrstr_id
658: AND usr_others.template_name = usr_this.template_name
659: AND usr_others.template_type = 'U'
660: AND usr_others.template_id <> usr_this.template_id;

Line 666: FROM pay_element_templates pets

662: csr_get_other_tempid_rec csr_get_other_tempid%ROWTYPE;
663:
664: CURSOR csr_get_orginfo (c_te_usrstr_id NUMBER) IS
665: SELECT TO_NUMBER(peei.eei_information1) pbd_org_id
666: FROM pay_element_templates pets
667: ,pay_shadow_element_types pset
668: ,pay_template_core_objects ptco
669: ,pay_element_type_extra_info peei
670: WHERE pets.template_id = c_te_usrstr_id -- For the given user structure