eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQP_UK_UNION_TEMPLATE dependencies on PAY_ELEMENT_TYPE_EXTRA_INFO

Line 9: g_element_extra_info_type pay_element_type_extra_info.information_type%TYPE:=

5: * CREATE_USER_TEMPLATE
6: *=======================================================================*/
7:
8: g_proc VARCHAR2(31):= 'pqp_uk_union_template.';
9: g_element_extra_info_type pay_element_type_extra_info.information_type%TYPE:=
10: 'PQP_UK_UNION_INFO';
11:
12: FUNCTION create_user_template
13: (p_frm_union_name IN VARCHAR2

Line 87: l_ee_unnddn_id pay_element_type_extra_info.element_type_extra_info_id%TYPE;

83:
84: l_bl_unnbal_nm pay_shadow_balance_types.balance_name%TYPE;
85: l_bf_unnbal_id pay_shadow_balance_feeds.balance_feed_id%TYPE;
86:
87: l_ee_unnddn_id pay_element_type_extra_info.element_type_extra_info_id%TYPE;
88: l_ee_unnorg_id pay_element_type_extra_info.eei_information1%TYPE;
89: l_ee_unnddn_nm pay_element_type_extra_info.eei_information2%TYPE;
90: l_ee_rattyp_nm pay_element_type_extra_info.eei_information3%TYPE;
91:

Line 88: l_ee_unnorg_id pay_element_type_extra_info.eei_information1%TYPE;

84: l_bl_unnbal_nm pay_shadow_balance_types.balance_name%TYPE;
85: l_bf_unnbal_id pay_shadow_balance_feeds.balance_feed_id%TYPE;
86:
87: l_ee_unnddn_id pay_element_type_extra_info.element_type_extra_info_id%TYPE;
88: l_ee_unnorg_id pay_element_type_extra_info.eei_information1%TYPE;
89: l_ee_unnddn_nm pay_element_type_extra_info.eei_information2%TYPE;
90: l_ee_rattyp_nm pay_element_type_extra_info.eei_information3%TYPE;
91:
92: l_or_unnddn_id hr_organization_information.organization_id%TYPE;

Line 89: l_ee_unnddn_nm pay_element_type_extra_info.eei_information2%TYPE;

85: l_bf_unnbal_id pay_shadow_balance_feeds.balance_feed_id%TYPE;
86:
87: l_ee_unnddn_id pay_element_type_extra_info.element_type_extra_info_id%TYPE;
88: l_ee_unnorg_id pay_element_type_extra_info.eei_information1%TYPE;
89: l_ee_unnddn_nm pay_element_type_extra_info.eei_information2%TYPE;
90: l_ee_rattyp_nm pay_element_type_extra_info.eei_information3%TYPE;
91:
92: l_or_unnddn_id hr_organization_information.organization_id%TYPE;
93: l_oi_unndat_dt hr_organization_information.org_information2%TYPE;

Line 90: l_ee_rattyp_nm pay_element_type_extra_info.eei_information3%TYPE;

86:
87: l_ee_unnddn_id pay_element_type_extra_info.element_type_extra_info_id%TYPE;
88: l_ee_unnorg_id pay_element_type_extra_info.eei_information1%TYPE;
89: l_ee_unnddn_nm pay_element_type_extra_info.eei_information2%TYPE;
90: l_ee_rattyp_nm pay_element_type_extra_info.eei_information3%TYPE;
91:
92: l_or_unnddn_id hr_organization_information.organization_id%TYPE;
93: l_oi_unndat_dt hr_organization_information.org_information2%TYPE;
94:

Line 812: l_ee_unnddn_id pay_element_type_extra_info.element_type_extra_info_id%TYPE;

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:
815:
816: l_del_union_level_balance_yn VARCHAR2(1):= 'Y'; --Default delete the balance

Line 813: l_ee_unnddn_ovn pay_element_type_extra_info.object_version_number%TYPE;

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:
815:
816: l_del_union_level_balance_yn VARCHAR2(1):= 'Y'; --Default delete the balance
817: --

Line 820: FROM pay_element_type_extra_info petei

816: l_del_union_level_balance_yn VARCHAR2(1):= 'Y'; --Default delete the balance
817: --
818: CURSOR csr_ee_unnddn IS
819: SELECT element_type_extra_info_id
820: FROM pay_element_type_extra_info petei
821: WHERE element_type_id = p_frm_element_type_id;
822:
823:
824: CURSOR csr_te_unnddn IS

Line 848: ,pay_element_type_extra_info peei

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
852: AND pset.element_name = pets.base_name