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_UNPAID_TEMPLATE dependencies on PAY_ELEMENT_TYPES_F

Line 9: TYPE t_ele_name IS TABLE OF pay_element_types_f.element_name%TYPE

5: g_debug BOOLEAN;
6:
7:
8:
9: TYPE t_ele_name IS TABLE OF pay_element_types_f.element_name%TYPE
10: INDEX BY BINARY_INTEGER;
11:
12: TYPE t_bal_name IS TABLE OF pay_balance_types.balance_name%TYPE
13: INDEX BY BINARY_INTEGER;

Line 16: TYPE t_ele_reporting_name IS TABLE OF pay_element_types_f.reporting_name%TYPE

12: TYPE t_bal_name IS TABLE OF pay_balance_types.balance_name%TYPE
13: INDEX BY BINARY_INTEGER;
14:
15:
16: TYPE t_ele_reporting_name IS TABLE OF pay_element_types_f.reporting_name%TYPE
17: INDEX BY BINARY_INTEGER;
18:
19: TYPE t_ele_description IS TABLE OF pay_element_types_f.description%TYPE
20: INDEX BY BINARY_INTEGER;

Line 19: TYPE t_ele_description IS TABLE OF pay_element_types_f.description%TYPE

15:
16: TYPE t_ele_reporting_name IS TABLE OF pay_element_types_f.reporting_name%TYPE
17: INDEX BY BINARY_INTEGER;
18:
19: TYPE t_ele_description IS TABLE OF pay_element_types_f.description%TYPE
20: INDEX BY BINARY_INTEGER;
21:
22: TYPE t_ele_pp IS TABLE OF pay_element_types_f.processing_priority%TYPE
23: INDEX BY BINARY_INTEGER;

Line 22: TYPE t_ele_pp IS TABLE OF pay_element_types_f.processing_priority%TYPE

18:
19: TYPE t_ele_description IS TABLE OF pay_element_types_f.description%TYPE
20: INDEX BY BINARY_INTEGER;
21:
22: TYPE t_ele_pp IS TABLE OF pay_element_types_f.processing_priority%TYPE
23: INDEX BY BINARY_INTEGER;
24:
25:
26: TYPE t_eei_info IS TABLE OF pay_element_type_extra_info.eei_information19%

Line 209: FROM pay_element_types_f

205: l_proc_name varchar2(72) := g_package_name || 'get_object_id';
206: --
207: CURSOR c2 (c_object_name varchar2) is
208: SELECT element_type_id
209: FROM pay_element_types_f
210: WHERE element_name = c_object_name
211: AND business_group_id = p_business_group_id;
212: --
213: CURSOR c3 (c_object_name in varchar2) is

Line 253: l_main_ele_type_id pay_element_types_f.element_type_id%TYPE;

249: ,p_template_id in number
250: ) IS
251: --
252:
253: l_main_ele_type_id pay_element_types_f.element_type_id%TYPE;
254: l_retro_ele_type_id pay_element_types_f.element_type_id%TYPE;
255: l_proc_step NUMBER(20,10);
256: l_proc_name VARCHAR2(72) := g_package_name ||
257: 'update_ele_retro_info';

Line 254: l_retro_ele_type_id pay_element_types_f.element_type_id%TYPE;

250: ) IS
251: --
252:
253: l_main_ele_type_id pay_element_types_f.element_type_id%TYPE;
254: l_retro_ele_type_id pay_element_types_f.element_type_id%TYPE;
255: l_proc_step NUMBER(20,10);
256: l_proc_name VARCHAR2(72) := g_package_name ||
257: 'update_ele_retro_info';
258:

Line 293: UPDATE pay_element_types_f

289: debug(l_proc_name, l_proc_step);
290: END IF;
291:
292:
293: UPDATE pay_element_types_f
294: SET retro_summ_ele_id = l_retro_ele_type_id
295: WHERE element_type_id = l_main_ele_type_id;
296:
297: --

Line 321: ,pay_element_types_f pet

317: SELECT input_value_id
318: ,piv.name
319: ,piv.element_type_id
320: FROM pay_input_values_f piv
321: ,pay_element_types_f pet
322: WHERE element_name = c_ele_name
323: AND piv.element_type_id = pet.element_type_id
324: AND (piv.business_group_id = p_bg_id OR piv.business_group_id IS NULL)
325: AND piv.name = c_iv_name

Line 865: l_object_version_number pay_element_types_f.object_version_number%TYPE;

861:
862: l_template_id pay_shadow_element_types.template_id%TYPE;
863: l_base_element_type_id pay_template_core_objects.core_object_id%TYPE;
864: l_source_template_id pay_element_templates.template_id%TYPE;
865: l_object_version_number pay_element_types_f.object_version_number%TYPE;
866:
867: l_proc_step NUMBER(20,10);
868: l_proc_name VARCHAR2(80) :=
869: g_package_name || 'create_user_template';

Line 870: l_element_type_id pay_element_types_f.element_type_id%TYPE;

866:
867: l_proc_step NUMBER(20,10);
868: l_proc_name VARCHAR2(80) :=
869: g_package_name || 'create_user_template';
870: l_element_type_id pay_element_types_f.element_type_id%TYPE;
871: l_balance_type_id pay_balance_types.balance_type_id%TYPE ;
872: l_eei_element_type_id pay_element_types_f.element_type_id%TYPE;
873: l_ele_obj_ver_number pay_element_types_f.object_version_number%TYPE;
874: l_bal_obj_ver_number pay_element_types_f.object_version_number%TYPE;

Line 872: l_eei_element_type_id pay_element_types_f.element_type_id%TYPE;

868: l_proc_name VARCHAR2(80) :=
869: g_package_name || 'create_user_template';
870: l_element_type_id pay_element_types_f.element_type_id%TYPE;
871: l_balance_type_id pay_balance_types.balance_type_id%TYPE ;
872: l_eei_element_type_id pay_element_types_f.element_type_id%TYPE;
873: l_ele_obj_ver_number pay_element_types_f.object_version_number%TYPE;
874: l_bal_obj_ver_number pay_element_types_f.object_version_number%TYPE;
875: i NUMBER;
876: l_eei_info_id pay_element_type_extra_info.

Line 873: l_ele_obj_ver_number pay_element_types_f.object_version_number%TYPE;

869: g_package_name || 'create_user_template';
870: l_element_type_id pay_element_types_f.element_type_id%TYPE;
871: l_balance_type_id pay_balance_types.balance_type_id%TYPE ;
872: l_eei_element_type_id pay_element_types_f.element_type_id%TYPE;
873: l_ele_obj_ver_number pay_element_types_f.object_version_number%TYPE;
874: l_bal_obj_ver_number pay_element_types_f.object_version_number%TYPE;
875: i NUMBER;
876: l_eei_info_id pay_element_type_extra_info.
877: element_type_extra_info_id%TYPE ;

Line 874: l_bal_obj_ver_number pay_element_types_f.object_version_number%TYPE;

870: l_element_type_id pay_element_types_f.element_type_id%TYPE;
871: l_balance_type_id pay_balance_types.balance_type_id%TYPE ;
872: l_eei_element_type_id pay_element_types_f.element_type_id%TYPE;
873: l_ele_obj_ver_number pay_element_types_f.object_version_number%TYPE;
874: l_bal_obj_ver_number pay_element_types_f.object_version_number%TYPE;
875: i NUMBER;
876: l_eei_info_id pay_element_type_extra_info.
877: element_type_extra_info_id%TYPE ;
878: l_ovn_eei pay_element_types_f.object_version_number%TYPE;

Line 878: l_ovn_eei pay_element_types_f.object_version_number%TYPE;

874: l_bal_obj_ver_number pay_element_types_f.object_version_number%TYPE;
875: i NUMBER;
876: l_eei_info_id pay_element_type_extra_info.
877: element_type_extra_info_id%TYPE ;
878: l_ovn_eei pay_element_types_f.object_version_number%TYPE;
879: l_abs_ele_correction_pp NUMBER := p_abs_ele_processing_priority - 50;
880: l_pay_ele_correction_pp NUMBER := p_pay_ele_processing_priority - 50;
881: l_formula_name pay_shadow_formulas.formula_name%TYPE;
882: l_formula_id ff_formulas_f.formula_id%TYPE ;

Line 1576: -- There is no effective date check on table pay_element_types_f

1572: IS
1573:
1574: -- The original query is split into 2 queries
1575: -- to avoid Merge joins and make use of Indexes.
1576: -- There is no effective date check on table pay_element_types_f
1577: -- as we are interested in data irrespective of date.
1578: -- Cursor to retrieve lookup type information
1579:
1580: CURSOR csr_get_lookup_type(c_base_name in varchar2)

Line 1584: ,pay_element_types_f petf

1580: CURSOR csr_get_lookup_type(c_base_name in varchar2)
1581: IS
1582: SELECT DISTINCT(pete.eei_information18) lookup_type
1583: FROM pay_element_type_extra_info pete
1584: ,pay_element_types_f petf
1585: -- ,pay_element_templates pet
1586: WHERE pete.element_type_id = petf.element_type_id
1587: AND pete.information_type = 'PQP_GB_OSP_ABSENCE_PLAN_INFO'
1588: AND pete.eei_information16 = 'Y'

Line 1960: l_element_type_id pay_element_types_f.element_type_id%TYPE;

1956: l_caludt_id pay_user_tables.user_table_id%TYPE;
1957: l_lookup_type fnd_lookup_types_vl.lookup_type%TYPE;
1958: l_lookup_code fnd_lookup_values_vl.lookup_code%TYPE;
1959: l_exists VARCHAR2(1);
1960: l_element_type_id pay_element_types_f.element_type_id%TYPE;
1961:
1962: l_lookup_collection t_number;
1963:
1964:

Line 1987: ,pay_element_types_f petf

1983: CURSOR csr_get_ele_type_id (c_template_id number)
1984: IS
1985: SELECT element_type_id
1986: FROM pay_template_core_objects pet
1987: ,pay_element_types_f petf
1988: WHERE pet.template_id = c_template_id
1989: AND petf.element_type_id = pet.core_object_id
1990: AND pet.core_object_type = 'ET';
1991: