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 470: pay_element_links_f pelf, pay_element_types_f petf

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

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

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

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

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

Line 2058: from PAY_ELEMENT_TYPES_F pet,

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

Line 2103: ,pay_element_types_f petf

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

Line 3377: pay_element_types_f pet

3373: cursor csr_defaultpayrollremoved(p_assignment_id number,p_effective_date date) is
3374: select null
3375: from per_all_assignments_f paa,
3376: pay_element_links_f pel,
3377: pay_element_types_f pet
3378: where paa.assignment_id=p_assignment_id
3379: and paa.payroll_id is null
3380: and p_effective_date between paa.effective_start_date
3381: and paa.effective_end_date