[Home] [Help]
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:
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;
74: l_iv_core_id pay_template_core_objects.core_object_id%TYPE;
75: l_dm_baldmn_id pay_balance_dimensions.balance_dimension_id%TYPE;
76:
77:
78:
341: --
342: CURSOR csr_bl_coreobj(p_xx_object_nm VARCHAR2) IS
343: SELECT ptco.core_object_id
344: FROM pay_shadow_balance_types psbt,
345: pay_template_core_objects ptco
346: WHERE psbt.template_id = l_te_usrstr_id
347: AND psbt.balance_name = p_xx_object_nm
348: AND ptco.template_id = psbt.template_id
349: AND ptco.shadow_object_id = psbt.balance_type_id;
349: AND ptco.shadow_object_id = psbt.balance_type_id;
350: --
351: CURSOR csr_id_coreobj IS
352: SELECT ptco.core_object_id
353: FROM pay_template_core_objects ptco
354: WHERE ptco.template_id = NVL(p_template_id,l_te_usrstr_id)
355: AND ptco.shadow_object_id = p_shadow_id
356: AND ptco.core_object_type = p_object_type;
357: --
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
850: WHERE pets.template_id = p_te_usrstr_id -- For the given user structure
851: AND pset.template_id = pets.template_id -- find the base element