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.HR_LOC_ABSENCE dependencies on PAY_ELEMENT_TYPES_F

Line 54: ,pay_element_types_f pet

50: ,pee.effective_start_date effective_start_date
51: ,pee.effective_end_date effective_end_date
52: from per_absence_attendances abs
53: ,per_all_assignments_f asg
54: ,pay_element_types_f pet
55: ,pay_element_links_f pel
56: ,pay_element_entries_f pee
57: ,pay_element_entry_values_f peev
58: ,pay_input_values_f piv

Line 86: ,pay_element_types_f pet

82: ,pee.effective_start_date effective_start_date
83: ,pee.effective_end_date effective_end_date
84: from per_absence_attendances abs
85: ,per_all_assignments_f asg
86: ,pay_element_types_f pet
87: ,pay_element_links_f pel
88: ,pay_element_entries_f pee
89: where abs.absence_attendance_id = p_absence_attendance_id
90: and abs.person_id = asg.person_id

Line 527: FROM pay_element_types_f

523: --
524: --
525: CURSOR csr_processing_type (p_element_type_id NUMBER) IS
526: SELECT processing_type
527: FROM pay_element_types_f
528: where element_type_id= p_element_type_id
529: AND p_effective_date between effective_start_date and effective_end_date;
530:
531: -- Local Variables.

Line 753: FROM pay_element_types_f pet

749: CURSOR csr_element_details (p_element_name VARCHAR2,
750: p_business_group_id NUMBER,
751: p_legislation_code VARCHAR2) IS
752: SELECT element_type_id
753: FROM pay_element_types_f pet
754: WHERE pet.element_name = p_element_name
755: AND nvl( pet.business_group_id, p_business_group_id) = p_business_group_id
756: AND nvl( pet.legislation_code, p_legislation_code) = p_legislation_code;
757:

Line 763: l_element_type_id pay_element_types_f.element_type_id%TYPE;

759: SELECT effective_date
760: FROM fnd_sessions
761: WHERE session_id = userenv('sessionid');
762:
763: l_element_type_id pay_element_types_f.element_type_id%TYPE;
764: l_element_name pay_element_types_f.element_name%TYPE;
765: l_proc varchar2(72) := g_package||'get_element_for_category';
766: l_legislation_code VARCHAR2(2);
767: l_dummy_effective_date DATE;

Line 764: l_element_name pay_element_types_f.element_name%TYPE;

760: FROM fnd_sessions
761: WHERE session_id = userenv('sessionid');
762:
763: l_element_type_id pay_element_types_f.element_type_id%TYPE;
764: l_element_name pay_element_types_f.element_name%TYPE;
765: l_proc varchar2(72) := g_package||'get_element_for_category';
766: l_legislation_code VARCHAR2(2);
767: l_dummy_effective_date DATE;
768:

Line 909: ,pay_element_types_f pet

905: ,pee.effective_start_date effective_start_date
906: ,pee.effective_end_date effective_end_date
907: from per_absence_attendances abs
908: ,per_all_assignments_f asg
909: ,pay_element_types_f pet
910: ,pay_element_links_f pel
911: ,pay_element_entries_f pee
912: ,pay_element_entry_values_f peev
913: ,pay_input_values_f piv

Line 939: ,pay_element_types_f pet

935: ,pee.effective_start_date
936: ,pee.effective_end_date
937: from per_absence_attendances abs
938: ,per_all_assignments_f asg
939: ,pay_element_types_f pet
940: ,pay_element_links_f pel
941: ,pay_element_entries_f pee
942: where abs.absence_attendance_id = p_absence_attendance_id
943: and abs.person_id = asg.person_id

Line 1336: FROM pay_element_types_f

1332: AND p_effective_date BETWEEN iv.effective_start_date AND iv.effective_end_date;
1333:
1334: CURSOR csr_processing_type (p_element_type_id NUMBER) IS
1335: SELECT processing_type
1336: FROM pay_element_types_f
1337: where element_type_id= p_element_type_id
1338: AND p_effective_date between effective_start_date and effective_end_date;
1339:
1340:

Line 1370: l_element_type_id pay_element_types_f.element_type_id%TYPE;

1366: abs.absence_attendance_type_id
1367: from per_absence_attendances abs
1368: where abs.absence_attendance_id = p_absence_attendance_id;
1369:
1370: l_element_type_id pay_element_types_f.element_type_id%TYPE;
1371: l_processing_type VARCHAR2(30);
1372: l_person_id NUMBER(15);
1373: l_assignment_id csr_assignments%rowtype;
1374: l_effective_start_date DATE;

Line 1729: ,pay_element_types_f pet

1725: ,pee.effective_start_date effective_start_date
1726: ,pee.effective_end_date effective_end_date
1727: from per_absence_attendances abs
1728: ,per_all_assignments_f asg
1729: ,pay_element_types_f pet
1730: ,pay_element_links_f pel
1731: ,pay_element_entries_f pee
1732: ,pay_element_entry_values_f peev
1733: ,pay_input_values_f piv

Line 1763: ,pay_element_types_f pet

1759: ,pee.effective_start_date effective_start_date
1760: ,pee.effective_end_date effective_end_date
1761: from per_absence_attendances abs
1762: ,per_all_assignments_f asg
1763: ,pay_element_types_f pet
1764: ,pay_element_links_f pel
1765: ,pay_element_entries_f pee
1766: where abs.absence_attendance_id = p_absence_attendance_id
1767: and abs.person_id = asg.person_id