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_GB_OMP_TEMPLATE dependencies on PAY_ELEMENT_TYPE_EXTRA_INFO

Line 148: TYPE t_eei_info IS TABLE OF pay_element_type_extra_info.eei_information19%

144: INDEX BY BINARY_INTEGER;
145:
146: l_ele_pp t_ele_pp;
147:
148: TYPE t_eei_info IS TABLE OF pay_element_type_extra_info.eei_information19%
149: TYPE
150: INDEX BY BINARY_INTEGER;
151:
152: l_main_eei_info19 t_eei_info;

Line 191: l_eei_information11 pay_element_type_extra_info.eei_information9%TYPE;

187: l_udt_rows t_udt_rows;
188: l_ele_core_id pay_template_core_objects.core_object_id%TYPE:= -1;
189:
190: -- Extra Information variables
191: l_eei_information11 pay_element_type_extra_info.eei_information9%TYPE;
192: l_eei_information12 pay_element_type_extra_info.eei_information10%TYPE;
193: l_eei_information20 pay_element_type_extra_info.eei_information18%TYPE;
194: l_eei_information27 pay_element_type_extra_info.eei_information27%TYPE
195: := 'PQP_GB_OMP_CALENDAR_RULES';

Line 192: l_eei_information12 pay_element_type_extra_info.eei_information10%TYPE;

188: l_ele_core_id pay_template_core_objects.core_object_id%TYPE:= -1;
189:
190: -- Extra Information variables
191: l_eei_information11 pay_element_type_extra_info.eei_information9%TYPE;
192: l_eei_information12 pay_element_type_extra_info.eei_information10%TYPE;
193: l_eei_information20 pay_element_type_extra_info.eei_information18%TYPE;
194: l_eei_information27 pay_element_type_extra_info.eei_information27%TYPE
195: := 'PQP_GB_OMP_CALENDAR_RULES';
196: l_eei_information30 pay_element_type_extra_info.eei_information30%TYPE

Line 193: l_eei_information20 pay_element_type_extra_info.eei_information18%TYPE;

189:
190: -- Extra Information variables
191: l_eei_information11 pay_element_type_extra_info.eei_information9%TYPE;
192: l_eei_information12 pay_element_type_extra_info.eei_information10%TYPE;
193: l_eei_information20 pay_element_type_extra_info.eei_information18%TYPE;
194: l_eei_information27 pay_element_type_extra_info.eei_information27%TYPE
195: := 'PQP_GB_OMP_CALENDAR_RULES';
196: l_eei_information30 pay_element_type_extra_info.eei_information30%TYPE
197: := 'Maternity' ;

Line 194: l_eei_information27 pay_element_type_extra_info.eei_information27%TYPE

190: -- Extra Information variables
191: l_eei_information11 pay_element_type_extra_info.eei_information9%TYPE;
192: l_eei_information12 pay_element_type_extra_info.eei_information10%TYPE;
193: l_eei_information20 pay_element_type_extra_info.eei_information18%TYPE;
194: l_eei_information27 pay_element_type_extra_info.eei_information27%TYPE
195: := 'PQP_GB_OMP_CALENDAR_RULES';
196: l_eei_information30 pay_element_type_extra_info.eei_information30%TYPE
197: := 'Maternity' ;
198:

Line 196: l_eei_information30 pay_element_type_extra_info.eei_information30%TYPE

192: l_eei_information12 pay_element_type_extra_info.eei_information10%TYPE;
193: l_eei_information20 pay_element_type_extra_info.eei_information18%TYPE;
194: l_eei_information27 pay_element_type_extra_info.eei_information27%TYPE
195: := 'PQP_GB_OMP_CALENDAR_RULES';
196: l_eei_information30 pay_element_type_extra_info.eei_information30%TYPE
197: := 'Maternity' ;
198:
199: CURSOR csr_get_ele_info (c_ele_name varchar2) is
200: SELECT element_type_id

Line 224: FROM pay_element_type_extra_info

220: AND nvl(hrl.end_date_active,hr_api.g_eot);
221:
222: CURSOR csr_chk_primary_exists is
223: SELECT 'X'
224: FROM pay_element_type_extra_info
225: WHERE eei_information1 = fnd_number.number_to_canonical(p_plan_id)
226: AND eei_information17 = 'Y'
227: AND information_type = 'PQP_GB_OMP_ABSENCE_PLAN_INFO'
228: AND rownum = 1;

Line 1656: l_daily_rate_uom pay_element_type_extra_info.eei_information13%TYPE ;

1652:
1653: l_lookup_collection t_number;
1654:
1655: l_entitlements_uom VARCHAR2(1) ;
1656: l_daily_rate_uom pay_element_type_extra_info.eei_information13%TYPE ;
1657: l_days_hours VARCHAR2(10) ;
1658:
1659: --
1660: CURSOR csr_get_scheme_type(p_ele_type_id IN NUMBER) IS

Line 1663: FROM pay_element_type_extra_info pee

1659: --
1660: CURSOR csr_get_scheme_type(p_ele_type_id IN NUMBER) IS
1661: SELECT substr(pee.eei_information9,2,1) entitlements_uom
1662: ,pee.eei_information13 daily_rate_uom
1663: FROM pay_element_type_extra_info pee
1664: WHERE element_type_id = p_ele_type_id
1665: AND information_type = 'PQP_GB_OMP_ABSENCE_PLAN_INFO' ;
1666:
1667: CURSOR csr_get_ele_type_id (c_template_id number) IS

Line 1680: FROM pay_element_type_extra_info petei

1676: SELECT element_type_extra_info_id
1677: ,fnd_number.canonical_to_number(eei_information11) entitlement_udt
1678: ,fnd_number.canonical_to_number(eei_information12) calendar_udt
1679: ,eei_information20 lookup_type
1680: FROM pay_element_type_extra_info petei
1681: WHERE element_type_id = c_element_type_id ;
1682:
1683: CURSOR csr_chk_eei_for_entudt (c_udt_id number) IS
1684: SELECT 'x'

Line 1685: FROM pay_element_type_extra_info

1681: WHERE element_type_id = c_element_type_id ;
1682:
1683: CURSOR csr_chk_eei_for_entudt (c_udt_id number) IS
1684: SELECT 'x'
1685: FROM pay_element_type_extra_info
1686: WHERE eei_information1 <> fnd_number.number_to_canonical(p_plan_id)
1687: AND eei_information11 = fnd_number.number_to_canonical(c_udt_id)
1688: AND information_type = 'PQP_GB_OMP_ABSENCE_PLAN_INFO'
1689: AND rownum = 1;

Line 1693: FROM pay_element_type_extra_info

1689: AND rownum = 1;
1690:
1691: CURSOR csr_chk_eei_for_caludt (c_udt_id number) IS
1692: SELECT 'x'
1693: FROM pay_element_type_extra_info
1694: WHERE eei_information1 <> fnd_number.number_to_canonical(p_plan_id)
1695: AND eei_information12 = fnd_number.number_to_canonical(c_udt_id)
1696: AND information_type = 'PQP_GB_OMP_ABSENCE_PLAN_INFO'
1697: AND rownum = 1;

Line 1702: FROM pay_element_type_extra_info

1698:
1699: CURSOR csr_chk_eei_for_lkt (c_lookup_type varchar2)
1700: IS
1701: SELECT 'x'
1702: FROM pay_element_type_extra_info
1703: WHERE eei_information1 <> fnd_number.number_to_canonical(p_plan_id)
1704: AND eei_information20 = c_lookup_type
1705: AND information_type = 'PQP_GB_OMP_ABSENCE_PLAN_INFO'
1706: AND rownum = 1;

Line 1716: ,pay_element_type_extra_info peei

1712: SELECT 'x'
1713: FROM pay_element_templates pets
1714: ,pay_shadow_element_types pset
1715: ,pay_template_core_objects ptco
1716: ,pay_element_type_extra_info peei
1717: WHERE pets.template_id <> c_te_usrstr_id
1718: -- For the given user structure
1719: AND pets.template_name = c_template_name --'PQP OMP Template'
1720: AND pets.template_type = 'U'

Line 1773: FROM pay_element_type_extra_info pete

1769:
1770: CURSOR csr_get_lookup_type(c_base_name varchar2)
1771: IS
1772: SELECT DISTINCT(pete.eei_information20) lookup_type
1773: FROM pay_element_type_extra_info pete
1774: ,pay_element_types_f petf
1775: -- ,pay_element_templates pet
1776: WHERE pete.element_type_id = petf.element_type_id
1777: AND pete.information_type = 'PQP_GB_OMP_ABSENCE_PLAN_INFO'