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

Line 6: element_new_name pay_element_types_f.element_name%TYPE ,

2: /* $Header: pqpfhexr.pkb 120.1 2006/01/16 03:36:26 asubrahm noship $ */
3:
4: TYPE element_cross_rec IS RECORD
5: (
6: element_new_name pay_element_types_f.element_name%TYPE ,
7: element_type_id pay_element_types_f.element_type_id%TYPE ,
8: element_old_name pay_element_types_f.element_name%TYPE ,
9: pay_basis VARCHAR2(50)
10: );

Line 7: element_type_id pay_element_types_f.element_type_id%TYPE ,

3:
4: TYPE element_cross_rec IS RECORD
5: (
6: element_new_name pay_element_types_f.element_name%TYPE ,
7: element_type_id pay_element_types_f.element_type_id%TYPE ,
8: element_old_name pay_element_types_f.element_name%TYPE ,
9: pay_basis VARCHAR2(50)
10: );
11:

Line 8: element_old_name pay_element_types_f.element_name%TYPE ,

4: TYPE element_cross_rec IS RECORD
5: (
6: element_new_name pay_element_types_f.element_name%TYPE ,
7: element_type_id pay_element_types_f.element_type_id%TYPE ,
8: element_old_name pay_element_types_f.element_name%TYPE ,
9: pay_basis VARCHAR2(50)
10: );
11:
12: TYPE element_cross_tab IS TABLE OF element_cross_rec

Line 79: pay_element_types_f.element_type_id%TYPE,

75: -- picking Ele name based on Sal Basis esp BSR
76: ORDER BY pcv.pcv_information1;
77:
78: CURSOR element_type_cursor(p_element_type_id
79: pay_element_types_f.element_type_id%TYPE,
80: p_business_group_id
81: per_business_groups.business_group_id%TYPE,
82: p_effective_date DATE) IS
83: SELECT pet.element_name element_new_name

Line 84: FROM pay_element_types_f pet

80: p_business_group_id
81: per_business_groups.business_group_id%TYPE,
82: p_effective_date DATE) IS
83: SELECT pet.element_name element_new_name
84: FROM pay_element_types_f pet
85: WHERE pet.business_group_id = p_business_group_id
86: AND pet.element_type_id = p_element_type_id
87: AND pet.business_group_id = p_business_group_id
88: AND p_effective_date BETWEEN pet.effective_start_date AND

Line 93: l_element_name pay_element_types_f.element_name%TYPE;

89: pet.effective_end_date;
90:
91: l_element_id NUMBER;
92:
93: l_element_name pay_element_types_f.element_name%TYPE;
94:
95: l_counter NUMBER;
96: l_tab_count NUMBER;
97: l_proc_name VARCHAR2(50) := 'return_new_element_name';

Line 269: pay_element_types_f pet,

265: p_salary_basis VARCHAR2,
266: p_effective_date DATE) IS
267: SELECT element_name
268: FROM per_pay_bases ppb,
269: pay_element_types_f pet,
270: pay_input_values_f piv
271: WHERE ppb.business_group_id = p_business_group_id
272: AND ppb.business_group_id = pet.business_group_id
273: AND ppb.business_group_id = piv.business_group_id

Line 282: l_element_name pay_element_types_f.element_name%TYPE;

278: piv.effective_end_date
279: AND p_effective_date BETWEEN pet.effective_start_date AND
280: pet.effective_end_date;
281:
282: l_element_name pay_element_types_f.element_name%TYPE;
283: l_proc_name VARCHAR2(50) := 'return_new_element_name';
284: BEGIN
285: hr_utility.set_location('Entering ' || g_package_name || l_proc_name, 10);
286:

Line 349: pay_element_types_f pet,

345: p_salary_basis_id NUMBER,
346: p_effective_date DATE) IS
347: SELECT element_name
348: FROM per_pay_bases ppb,
349: pay_element_types_f pet,
350: pay_input_values_f piv
351: WHERE ppb.business_group_id = p_business_group_id
352: AND ppb.business_group_id = pet.business_group_id
353: AND ppb.business_group_id = piv.business_group_id

Line 373: l_element_name pay_element_types_f.element_name%TYPE;

369: AND business_group_id = p_business_group_id
370: AND p_effective_date BETWEEN effective_start_date
371: AND effective_end_date;
372:
373: l_element_name pay_element_types_f.element_name%TYPE;
374: l_proc_name VARCHAR2(50) := 'return_new_element_name';
375: l_sal_basis_id NUMBER;
376: BEGIN
377: hr_utility.set_location('Entering ' || g_package_name || l_proc_name, 10);

Line 522: FROM pay_element_types_f elt,

518:
519: CURSOR cur_ele_link_in_biz(p_ele_name VARCHAR2, p_business_group_id IN NUMBER)
520: IS
521: SELECT DISTINCT eli.element_link_id link_id
522: FROM pay_element_types_f elt,
523: pay_element_links_f eli
524: WHERE elt.element_type_id = eli.element_type_id
525: AND UPPER(elt.element_name) = UPPER(p_ele_name)
526: AND eli.business_group_id = p_business_group_id

Line 534: FROM pay_element_types_f elt,

530: p_legislation_code IN VARCHAR2,
531: p_business_group_id IN NUMBER)
532: IS
533: SELECT DISTINCT eli.element_link_id link_id
534: FROM pay_element_types_f elt,
535: pay_element_links_f eli
536: WHERE elt.element_type_id = eli.element_type_id
537: AND UPPER(elt.element_name) = UPPER(p_ele_name)
538: AND elt.business_group_id IS NULL

Line 679: l_element_type_id pay_element_types_f.element_type_id%type;

675: p_business_group_id IN NUMBER,
676: p_effective_date IN DATE
677: ) RETURN VARCHAR2 IS
678:
679: l_element_type_id pay_element_types_f.element_type_id%type;
680:
681: CURSOR chk_element_type_id IS
682: SELECT ele.element_type_id element_type_id
683: FROM pay_element_types_f ele

Line 683: FROM pay_element_types_f ele

679: l_element_type_id pay_element_types_f.element_type_id%type;
680:
681: CURSOR chk_element_type_id IS
682: SELECT ele.element_type_id element_type_id
683: FROM pay_element_types_f ele
684: WHERE ele.element_name = p_agency_element_name
685: AND business_group_id = p_business_group_id
686: AND p_effective_date BETWEEN ele.effective_start_date
687: AND ele.effective_end_date;

Line 701: pay_element_types_f.element_type_id%TYPE,

697: ORDER BY pcv.pcv_information1;
698:
699: /****
700: CURSOR element_type_cursor(p_element_type_id
701: pay_element_types_f.element_type_id%TYPE,
702: p_business_group_id
703: per_business_groups.business_group_id%TYPE,
704: p_effective_date DATE) IS
705: SELECT pet.element_name element_new_name

Line 706: FROM pay_element_types_f pet

702: p_business_group_id
703: per_business_groups.business_group_id%TYPE,
704: p_effective_date DATE) IS
705: SELECT pet.element_name element_new_name
706: FROM pay_element_types_f pet
707: WHERE pet.business_group_id = p_business_group_id
708: AND pet.element_type_id = p_element_type_id
709: AND pet.business_group_id = p_business_group_id
710: AND p_effective_date BETWEEN pet.effective_start_date AND

Line 715: l_element_name pay_element_types_f.element_name%TYPE;

711: pet.effective_end_date;
712: ****/
713: l_element_id NUMBER;
714:
715: l_element_name pay_element_types_f.element_name%TYPE;
716:
717: l_counter NUMBER;
718: l_tab_count NUMBER;
719: l_proc_name VARCHAR2(50) := 'return_old_element_name';