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

Line 330: pay_element_types_f petf,

326: peevf.screen_entry_value
327: from pay_element_entries_f peef,
328: pay_element_entry_values_f peevf,
329: pay_input_values_f pivf,
330: pay_element_types_f petf,
331: pay_element_links_f pelf
332: where peef.assignment_id = p_assignment_id
333: and peef.creator_type = 'UT'
334: and petf.element_name = 'VERTEX'

Line 358: from PAY_ELEMENT_TYPES_F petf,

354: Cursor csr_vertex_element is
355: select petf.element_type_id,
356: pivf.input_value_id,
357: pivf.name
358: from PAY_ELEMENT_TYPES_F petf,
359: PAY_INPUT_VALUES_F pivf
360: where petf.element_name = 'VERTEX'
361: and p_effective_date between petf.effective_start_date
362: and petf.effective_end_date

Line 468: pay_element_links_f pelf, pay_element_types_f petf

464: p_effective_date date
465: ) is
466: select peef.element_entry_id
467: from pay_element_entries_f peef, pay_element_entry_values_f peevf,
468: pay_element_links_f pelf, pay_element_types_f petf
469: where peef.assignment_id= p_assignment_id
470: and petf.element_name='VERTEX'
471: and peevf.screen_entry_value = p_jurisdiction
472: and p_effective_date between peef.effective_start_date

Line 495: l_element_type_id pay_element_types_f.element_type_id%TYPE := null;

491: TYPE location_tbl is table of location_rec index by
492: binary_integer;
493: --
494: l_proc varchar2(72) := g_package||'maintain_tax_percentage';
495: l_element_type_id pay_element_types_f.element_type_id%TYPE := null;
496: t_element_entry_id pay_element_types_f.element_type_id%TYPE := null;
497: l_input_value_id_tbl hr_entry.number_table;
498: l_new_vertex_value_tbl hr_entry.varchar2_table;
499: l_element_rec_tbl l_element_rec;

Line 496: t_element_entry_id pay_element_types_f.element_type_id%TYPE := null;

492: binary_integer;
493: --
494: l_proc varchar2(72) := g_package||'maintain_tax_percentage';
495: l_element_type_id pay_element_types_f.element_type_id%TYPE := null;
496: t_element_entry_id pay_element_types_f.element_type_id%TYPE := null;
497: l_input_value_id_tbl hr_entry.number_table;
498: l_new_vertex_value_tbl hr_entry.varchar2_table;
499: l_element_rec_tbl l_element_rec;
500: l_asg_tbl location_tbl;

Line 2056: from PAY_ELEMENT_TYPES_F pet,

2052: cursor csr_wc_tax_element is
2053: select pet.element_type_id,
2054: piv.input_value_id,
2055: piv.name
2056: from PAY_ELEMENT_TYPES_F pet,
2057: PAY_INPUT_VALUES_F piv
2058: where pet.element_name = lc_workers_comp
2059: and l_get_old_value_date between pet.effective_start_date
2060: and pet.effective_end_date

Line 2101: ,pay_element_types_f petf

2097: select peef.element_entry_id
2098: from pay_element_entries_f peef
2099: ,pay_element_entry_values_f peevf
2100: ,pay_element_links_f pelf
2101: ,pay_element_types_f petf
2102: where peef.assignment_id= l_csr_assignment_id
2103: and petf.element_name = lc_workers_comp
2104: and l_csr_effective_date < peef.effective_end_date
2105: and peef.element_link_id = pelf.element_link_id