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

Line 79: , pay_element_types_f et

75: ,p.effective_end_date
76: ,ee.effective_end_date) end_date
77: from pay_element_entries_f ee
78: , pay_element_links_f el
79: , pay_element_types_f et
80: , pay_payrolls_f p
81: where et.element_name = 'FR_OVERTIME'
82: and p_effective_date
83: between et.effective_start_date and et.effective_end_date

Line 184: , pay_element_types_f ELEMENT

180: ,nvl(PRL_INFORMATION18,'-1') -- Overtime Formula ID
181: ,nvl(PRL_INFORMATION19,'-1') -- Regularisation Formula ID
182: from pay_element_entries_f TARGET
183: , pay_element_links_f LINK
184: , pay_element_types_f ELEMENT
185: , pay_payrolls_f SCHEME
186: where TARGET.assignment_id = p_assignment_id
187: and p_date BETWEEN TARGET.effective_start_date
188: AND TARGET.effective_end_date

Line 563: select /+ORDERED index(pet PAY_ELEMENT_TYPES_F_UK2) /

559: ,P_RANGE_START_DATE date) return date is
560: --
561: cursor get_elements(p_orig_ele varchar2,
562: p_retr_ele varchar2) is
563: select /*+ORDERED index(pet PAY_ELEMENT_TYPES_F_UK2) */
564: max(decode(pet.element_name,p_orig_ele,pet.element_type_id)) orig_ele_id,
565: max(decode(pet.element_name,p_retr_ele,pet.element_type_id)) retr_ele_id
566: from pay_element_types_f pet
567: where pet.element_name in (p_orig_ele,p_retr_ele)

Line 566: from pay_element_types_f pet

562: p_retr_ele varchar2) is
563: select /*+ORDERED index(pet PAY_ELEMENT_TYPES_F_UK2) */
564: max(decode(pet.element_name,p_orig_ele,pet.element_type_id)) orig_ele_id,
565: max(decode(pet.element_name,p_retr_ele,pet.element_type_id)) retr_ele_id
566: from pay_element_types_f pet
567: where pet.element_name in (p_orig_ele,p_retr_ele)
568: and pet.legislation_code = 'FR'
569: and pet.business_group_id is null
570: and p_date_earned between pet.effective_start_date

Line 763: , pay_element_types_f et

759: cursor c_overtime_entry is
760: select 'Y'
761: from pay_element_entries_f ee
762: , pay_element_links_f el
763: , pay_element_types_f et
764: where ee.assignment_id = p_assignment_id
765: and ee.element_link_id = el.element_link_id
766: and el.element_type_id = et.element_type_id
767: and et.element_name in ('FR_OVERTIME_WEEK','FR_OVERTIME_EXCEPTION_WEEK')

Line 1346: select /+ORDERED index(pet PAY_ELEMENT_TYPES_F_UK2) /

1342: ,p_week_end_date date) return varchar2 is
1343: --
1344: cursor get_elements(p_orig_ele varchar2,
1345: p_retr_ele varchar2) is
1346: select /*+ORDERED index(pet PAY_ELEMENT_TYPES_F_UK2) */
1347: max(decode(pet.element_name,p_orig_ele,pet.element_type_id)) orig_ele_id,
1348: max(decode(pet.element_name,p_retr_ele,pet.element_type_id)) retr_ele_id
1349: from pay_element_types_f pet
1350: where pet.element_name in (p_orig_ele,p_retr_ele)

Line 1349: from pay_element_types_f pet

1345: p_retr_ele varchar2) is
1346: select /*+ORDERED index(pet PAY_ELEMENT_TYPES_F_UK2) */
1347: max(decode(pet.element_name,p_orig_ele,pet.element_type_id)) orig_ele_id,
1348: max(decode(pet.element_name,p_retr_ele,pet.element_type_id)) retr_ele_id
1349: from pay_element_types_f pet
1350: where pet.element_name in (p_orig_ele,p_retr_ele)
1351: and pet.legislation_code = 'FR'
1352: and pet.business_group_id is null
1353: and p_date_earned between pet.effective_start_date

Line 1428: select /+ORDERED index(pet PAY_ELEMENT_TYPES_F_UK2) / pet.element_type_id,

1424: ,p_end_date date
1425: ,p_value_input varchar2) return number is
1426: --
1427: cursor get_element is
1428: select /*+ORDERED index(pet PAY_ELEMENT_TYPES_F_UK2) */ pet.element_type_id,
1429: max(decode(piv.name,p_value_input,piv.input_value_id)) value_iv,
1430: max(decode(piv.name,p_start_input,piv.input_value_id)) start_iv,
1431: max(decode(piv.name,p_end_input, piv.input_value_id)) end_iv
1432: from pay_element_types_f pet,

Line 1432: from pay_element_types_f pet,

1428: select /*+ORDERED index(pet PAY_ELEMENT_TYPES_F_UK2) */ pet.element_type_id,
1429: max(decode(piv.name,p_value_input,piv.input_value_id)) value_iv,
1430: max(decode(piv.name,p_start_input,piv.input_value_id)) start_iv,
1431: max(decode(piv.name,p_end_input, piv.input_value_id)) end_iv
1432: from pay_element_types_f pet,
1433: pay_input_values_f piv
1434: where pet.element_name = p_element
1435: and (pet.legislation_code = 'FR' or
1436: pet.business_group_id = p_business_group_id)