APPS.PQP_UK_UNION_TEMPLATE dependencies on PAY_ELEMENT_TEMPLATES

Line 61: l_te_usrstr_id pay_element_templates.template_id%TYPE;

57: c_iv_payvlu_nm CONSTANT pay_shadow_input_values.name%TYPE:=
58: 'Pay Value';
59: c_iv_fdsltd_nm CONSTANT pay_shadow_input_values.name%TYPE:=
60: 'Fund Selected';
61: l_te_usrstr_id pay_element_templates.template_id%TYPE;
62: l_te_source_id pay_element_templates.template_id%TYPE;
63:
64: -- Return Value
65: l_el_core_id pay_template_core_objects.core_object_id%TYPE:= -1;

Line 62: l_te_source_id pay_element_templates.template_id%TYPE;

58: 'Pay Value';
59: c_iv_fdsltd_nm CONSTANT pay_shadow_input_values.name%TYPE:=
60: 'Fund Selected';
61: l_te_usrstr_id pay_element_templates.template_id%TYPE;
62: l_te_source_id pay_element_templates.template_id%TYPE;
63:
64: -- Return Value
65: l_el_core_id pay_template_core_objects.core_object_id%TYPE:= -1;
66:

Line 69: l_xx_unnddn_ovn pay_element_templates.object_version_number%TYPE;

65: l_el_core_id pay_template_core_objects.core_object_id%TYPE:= -1;
66:
67: -- Generic Never to be passed IN
68: l_xx_rowid_id ROWID;
69: l_xx_unnddn_ovn pay_element_templates.object_version_number%TYPE;
70:
71:
72: l_bl_core_id pay_balance_types.balance_type_id%TYPE;
73: l_db_core_id pay_defined_balances.defined_balance_id%TYPE;

Line 168: l_te_unnddn_id pay_element_templates.template_id%TYPE;

164: --======================================================================
165: FUNCTION get_template_id (p_legislation_code IN VARCHAR2)
166: RETURN NUMBER IS
167: --
168: l_te_unnddn_id pay_element_templates.template_id%TYPE;
169: l_te_unnddn_nm pay_element_templates.template_name%TYPE;
170: l_proc_nm VARCHAR2(61):= g_proc||'get_template_id';
171: --
172: CURSOR csr_te_unnddn IS

Line 169: l_te_unnddn_nm pay_element_templates.template_name%TYPE;

165: FUNCTION get_template_id (p_legislation_code IN VARCHAR2)
166: RETURN NUMBER IS
167: --
168: l_te_unnddn_id pay_element_templates.template_id%TYPE;
169: l_te_unnddn_nm pay_element_templates.template_name%TYPE;
170: l_proc_nm VARCHAR2(61):= g_proc||'get_template_id';
171: --
172: CURSOR csr_te_unnddn IS
173: SELECT template_id

Line 174: FROM pay_element_templates

170: l_proc_nm VARCHAR2(61):= g_proc||'get_template_id';
171: --
172: CURSOR csr_te_unnddn IS
173: SELECT template_id
174: FROM pay_element_templates
175: WHERE template_name = l_te_unnddn_nm
176: AND legislation_code = p_legislation_code
177: AND template_type = 'T'
178: AND business_group_id is NULL;

Line 810: l_te_unnddn_id pay_element_templates.template_id%TYPE;

806: ,p_frm_effective_date IN DATE
807: ) IS
808: --
809: l_proc VARCHAR2(61):= g_proc||'delete_user_template';
810: l_te_unnddn_id pay_element_templates.template_id%TYPE;
811:
812: l_ee_unnddn_id pay_element_type_extra_info.element_type_extra_info_id%TYPE;
813: l_ee_unnddn_ovn pay_element_type_extra_info.object_version_number%TYPE;
814:

Line 826: FROM pay_element_templates

822:
823:
824: CURSOR csr_te_unnddn IS
825: SELECT template_id
826: FROM pay_element_templates
827: WHERE base_name = p_frm_element_name
828: AND business_group_id = p_frm_business_group_id
829: AND template_type = 'U';
830:

Line 834: FROM pay_element_templates usr_this

830:
831:
832: CURSOR csr_te_others (p_te_usrstr_id NUMBER) IS
833: SELECT usr_others.template_id
834: FROM pay_element_templates usr_this
835: ,pay_element_templates usr_others
836: WHERE usr_this.template_id = p_te_usrstr_id
837: AND usr_others.template_name = usr_this.template_name
838: AND usr_others.template_type = 'U'

Line 835: ,pay_element_templates usr_others

831:
832: CURSOR csr_te_others (p_te_usrstr_id NUMBER) IS
833: SELECT usr_others.template_id
834: FROM pay_element_templates usr_this
835: ,pay_element_templates usr_others
836: WHERE usr_this.template_id = p_te_usrstr_id
837: AND usr_others.template_name = usr_this.template_name
838: AND usr_others.template_type = 'U'
839: AND usr_others.template_id <> usr_this.template_id;

Line 845: FROM pay_element_templates pets

841: row_te_others csr_te_others%ROWTYPE;
842:
843: CURSOR csr_ee_unionm (p_te_usrstr_id NUMBER) IS
844: SELECT TO_NUMBER(peei.eei_information1) union_org_id
845: FROM pay_element_templates pets
846: ,pay_shadow_element_types pset
847: ,pay_template_core_objects ptco
848: ,pay_element_type_extra_info peei
849: -- ,hr_all_organization_units horg