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_TYPES_F

Line 89: l_object_version_number pay_element_types_f.object_version_number%TYPE;

85: --
86: l_template_id pay_shadow_element_types.template_id%TYPE;
87: l_base_element_type_id pay_template_core_objects.core_object_id%TYPE;
88: l_source_template_id pay_element_templates.template_id%TYPE;
89: l_object_version_number pay_element_types_f.object_version_number%TYPE;
90: l_proc_name VARCHAR2(80) :=
91: g_proc_name || 'create_user_template';
92:
93: l_template_name pay_element_templates.template_name%TYPE ;

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

114: l_exc_sec_days_bf VARCHAR2(1);
115: l_base_name pay_element_templates.base_name%TYPE
116: := UPPER(TRANSLATE(TRIM(p_pri_ele_name),' ','_'));
117:
118: TYPE t_ele_name IS TABLE OF pay_element_types_f.element_name%TYPE
119: INDEX BY BINARY_INTEGER;
120:
121: l_ele_name t_ele_name;
122: l_ele_new_name t_ele_name;

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

129: l_bal_name t_bal_name;
130: l_bal_new_name t_bal_name;
131:
132:
133: TYPE t_ele_reporting_name IS TABLE OF pay_element_types_f.reporting_name%TYPE
134: INDEX BY BINARY_INTEGER;
135:
136: l_ele_reporting_name t_ele_reporting_name;
137:

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

134: INDEX BY BINARY_INTEGER;
135:
136: l_ele_reporting_name t_ele_reporting_name;
137:
138: TYPE t_ele_description IS TABLE OF pay_element_types_f.description%TYPE
139: INDEX BY BINARY_INTEGER;
140:
141: l_ele_description t_ele_description;
142:

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

139: INDEX BY BINARY_INTEGER;
140:
141: l_ele_description t_ele_description;
142:
143: TYPE t_ele_pp IS TABLE OF pay_element_types_f.processing_priority%TYPE
144: INDEX BY BINARY_INTEGER;
145:
146: l_ele_pp t_ele_pp;
147:

Line 285: FROM pay_element_types_f

281: l_proc_name varchar2(72) := g_proc_name || 'get_object_id';
282: --
283: CURSOR c2 (c_object_name varchar2) is
284: SELECT element_type_id
285: FROM pay_element_types_f
286: WHERE element_name = c_object_name
287: AND business_group_id = p_bg_id;
288: --
289: CURSOR c3 (c_object_name in varchar2) is

Line 327: l_main_ele_type_id pay_element_types_f.element_type_id%TYPE;

323: ,p_retro_ele_name IN VARCHAR2
324: ) IS
325: --
326:
327: l_main_ele_type_id pay_element_types_f.element_type_id%TYPE;
328: l_retro_ele_type_id pay_element_types_f.element_type_id%TYPE;
329: l_proc_name VARCHAR2(72) := g_proc_name ||
330: 'update_ele_retro_info';
331:

Line 328: l_retro_ele_type_id pay_element_types_f.element_type_id%TYPE;

324: ) IS
325: --
326:
327: l_main_ele_type_id pay_element_types_f.element_type_id%TYPE;
328: l_retro_ele_type_id pay_element_types_f.element_type_id%TYPE;
329: l_proc_name VARCHAR2(72) := g_proc_name ||
330: 'update_ele_retro_info';
331:
332: --

Line 355: UPDATE pay_element_types_f

351: -- Update main element with retro element info
352:
353: hr_utility.set_location(l_proc_name, 30);
354:
355: UPDATE pay_element_types_f
356: SET retro_summ_ele_id = l_retro_ele_type_id
357: WHERE element_type_id = l_main_ele_type_id;
358:
359: --

Line 415: ,pay_element_types_f pet

411: SELECT input_value_id
412: ,piv.name
413: ,piv.element_type_id
414: FROM pay_input_values_f piv
415: ,pay_element_types_f pet
416: WHERE element_name = c_ele_name
417: AND piv.element_type_id = pet.element_type_id
418: AND (piv.business_group_id = p_bg_id OR piv.business_group_id IS NULL)
419: AND piv.name = c_iv_name

Line 1648: l_element_type_id pay_element_types_f.element_type_id%TYPE;

1644: l_caludt_id pay_user_tables.user_table_id%TYPE;
1645: l_lookup_type fnd_lookup_types_vl.lookup_type%TYPE;
1646: l_lookup_code fnd_lookup_values_vl.lookup_code%TYPE;
1647: l_exists VARCHAR2(1);
1648: l_element_type_id pay_element_types_f.element_type_id%TYPE;
1649:
1650: TYPE t_number IS TABLE OF NUMBER
1651: INDEX BY BINARY_INTEGER;
1652:

Line 1670: ,pay_element_types_f petf

1666:
1667: CURSOR csr_get_ele_type_id (c_template_id number) IS
1668: SELECT element_type_id
1669: FROM pay_template_core_objects pet
1670: ,pay_element_types_f petf
1671: WHERE pet.template_id = c_template_id
1672: AND petf.element_type_id = pet.core_object_id
1673: AND pet.core_object_type = 'ET';
1674:

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

1762: IS
1763:
1764: -- The original query is split into 2 queries
1765: -- to avoid Merge joins and make use of Indexes.
1766: -- There is no effective date check on table pay_element_types_f
1767: -- as we are interested in data irrespective of date.
1768: -- Cursor to retrieve lookup type information
1769:
1770: CURSOR csr_get_lookup_type(c_base_name varchar2)

Line 1774: ,pay_element_types_f petf

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'
1778: AND pete.eei_information17 = 'Y'

Line 2346: l_element_type_id pay_element_types_f.element_type_id%TYPE ;

2342: --, p_abs_type IN VARCHAR2
2343: ,p_template_id IN NUMBER
2344: ) IS
2345: -- l_link_ele_name t_ele_name ;
2346: l_element_type_id pay_element_types_f.element_type_id%TYPE ;
2347: l_rowid VARCHAR2(100) ;
2348: l_element_link_id pay_element_links_f.element_link_id%TYPE ;
2349: l_effective_end_date DATE := p_effective_end_date ;
2350:

Line 2353: --FROM PAY_ELEMENT_TYPES_F

2349: l_effective_end_date DATE := p_effective_end_date ;
2350:
2351: --CURSOR csr_get_element_type_id (p_element_name IN VARCHAR2 ) IS
2352: --SELECT element_type_id
2353: --FROM PAY_ELEMENT_TYPES_F
2354: --WHERE element_name = p_element_name ;
2355: l_element_name pay_element_types_f.element_name%TYPE ;
2356:
2357: begin

Line 2355: l_element_name pay_element_types_f.element_name%TYPE ;

2351: --CURSOR csr_get_element_type_id (p_element_name IN VARCHAR2 ) IS
2352: --SELECT element_type_id
2353: --FROM PAY_ELEMENT_TYPES_F
2354: --WHERE element_name = p_element_name ;
2355: l_element_name pay_element_types_f.element_name%TYPE ;
2356:
2357: begin
2358:
2359: -- l_link_ele_name(1) := p_base_name||p_abs_type||'Absence' ; -- Absence

Line 2474: --l_element_type_id pay_element_types_f.element_type_id%TYPE ;

2470: ) IS
2471:
2472:
2473: --l_link_ele_name t_ele_name ;
2474: --l_element_type_id pay_element_types_f.element_type_id%TYPE ;
2475: l_rowid VARCHAR2(100) ;
2476: l_element_link_id pay_element_links_f.element_link_id%TYPE ;
2477: l_people_group_id pay_element_links_f.people_group_id%TYPE ;
2478: l_effective_end_date DATE := p_effective_end_date ;

Line 2482: --FROM PAY_ELEMENT_TYPES_F

2478: l_effective_end_date DATE := p_effective_end_date ;
2479:
2480: -- CURSOR csr_get_element_type_id (p_element_name IN VARCHAR2 ) IS
2481: --SELECT element_type_id
2482: --FROM PAY_ELEMENT_TYPES_F
2483: --WHERE element_name = p_element_name ;
2484:
2485: CURSOR csr_link_details ( p_element_type_id IN NUMBER ) IS
2486: SELECT rowid, element_link_id, people_group_id

Line 2493: -- FROM PAY_ELEMENT_TYPES_F

2489:
2490: -- CURSOR csr_get_element_name(p_element_type_id NUMBER)
2491: -- IS
2492: -- SELECT element_name
2493: -- FROM PAY_ELEMENT_TYPES_F
2494: -- WHERE element_type_id = p_element_type_id ;
2495:
2496: l_link_details csr_link_Details%ROWTYPE ;
2497: l_element_name pay_element_types_f.element_name%TYPE ;

Line 2497: l_element_name pay_element_types_f.element_name%TYPE ;

2493: -- FROM PAY_ELEMENT_TYPES_F
2494: -- WHERE element_type_id = p_element_type_id ;
2495:
2496: l_link_details csr_link_Details%ROWTYPE ;
2497: l_element_name pay_element_types_f.element_name%TYPE ;
2498:
2499: BEGIN
2500:
2501: -- All Element Names are First Stored in a Record