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_GEO_UPD_PKG dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 815: --Retrieve all affected rows in the pay_element_entry_values_f table.

811: and pugu.id = g_geo_phase_id);
812:
813: l_city_tax_exists varchar2(2);
814:
815: --Retrieve all affected rows in the pay_element_entry_values_f table.
816: --Since we can join on the main part of the pk of the table we do not
817: --need the logic in the element_entries procedure.
818:
819: --

Line 832: pay_element_entry_values_f pev,

828: CURSOR pev_cur(geocode VARCHAR2, assign_id NUMBER) IS
829: SELECT /*+ ORDERED */ distinct pev.screen_entry_value, pev.element_entry_id,
830: pev.input_value_id
831: FROM pay_element_entries_f pee,
832: pay_element_entry_values_f pev,
833: pay_input_values_f piv
834: WHERE pee.assignment_id = assign_id
835: AND pee.element_entry_id = pev.element_entry_id
836: AND pev.screen_entry_value = geocode

Line 845: and pugu.table_name = 'PAY_ELEMENT_ENTRY_VALUES_F'

841: AND NOT EXISTS (select 'Y' from PAY_US_GEO_UPDATE pugu
842: where pugu.assignment_id = assign_id
843: and pugu.table_value_id = pev.element_entry_id
844: and pugu.old_juri_code = geocode
845: and pugu.table_name = 'PAY_ELEMENT_ENTRY_VALUES_F'
846: and pugu.process_mode = g_mode
847: and pugu.process_type = g_process_type
848: and pugu.id = g_geo_phase_id);
849:

Line 1869: UPDATE pay_element_entry_values_f

1865: hr_utility.trace('Before update of element entry values for assignment_id: '||to_char(p_assign_id));
1866:
1867: IF G_MODE = 'UPGRADE' THEN
1868:
1869: UPDATE pay_element_entry_values_f
1870: SET screen_entry_value = p_new_juri_code
1871: WHERE screen_entry_value = p_old_juri_code
1872: AND input_value_id+0 = p_input_value_id
1873: AND element_entry_id = p_ele_ent_id;

Line 1886: p_location => 'PAY_ELEMENT_ENTRY_VALUES_F',

1882: p_person_id => p_person_id,
1883: p_assign_id => p_assign_id,
1884: p_old_juri_code => p_old_juri_code,
1885: p_new_juri_code => p_new_juri_code,
1886: p_location => 'PAY_ELEMENT_ENTRY_VALUES_F',
1887: p_id => p_ele_ent_id);
1888:
1889: ELSE
1890:

Line 1899: p_location => 'PAY_ELEMENT_ENTRY_VALUES_F',

1895: p_person_id => p_person_id,
1896: p_assign_id => p_assign_id,
1897: p_old_juri_code => p_old_juri_code,
1898: p_new_juri_code => p_new_juri_code,
1899: p_location => 'PAY_ELEMENT_ENTRY_VALUES_F',
1900: p_id => p_ele_ent_id);
1901:
1902: END IF;
1903:

Line 1987: from pay_element_entry_values_f pev,

1983:
1984: -- This cursor will get us the element entries of the assignments processed
1985: cursor csr_get_dup (p_assignment number) is
1986: select pev.screen_entry_value sev, pev.element_entry_id eei
1987: from pay_element_entry_values_f pev,
1988: pay_input_values_f piv,
1989: pay_element_types_f pet,
1990: pay_element_links_f pel,
1991: pay_element_entries_f pee

Line 2008: from pay_element_entry_values_f pev,

2004:
2005: cursor csr_get_percentage (p_element_entry_id NUMBER) is
2006: select pev.screen_entry_value , pev.effective_start_date,
2007: pev.effective_end_date
2008: from pay_element_entry_values_f pev,
2009: pay_input_values_f piv,
2010: pay_element_types_f pet,
2011: pay_element_links_f pel,
2012: pay_element_entries_f pef

Line 2025: l_prev_screen pay_element_entry_values_f.screen_entry_value%TYPE;

2021: and piv.name = 'Percentage'
2022: and piv.legislation_code = 'US'
2023: and pet.legislation_code = 'US';
2024:
2025: l_prev_screen pay_element_entry_values_f.screen_entry_value%TYPE;
2026: l_prev_eleid pay_element_entry_values_f.element_entry_id%TYPE;
2027: l_percent pay_element_entry_values_f.screen_entry_value%TYPE;
2028: l_effective_start_date pay_element_entry_values_f.effective_start_date%TYPE;
2029: l_effective_end_date pay_element_entry_values_f.effective_end_date%TYPE;

Line 2026: l_prev_eleid pay_element_entry_values_f.element_entry_id%TYPE;

2022: and piv.legislation_code = 'US'
2023: and pet.legislation_code = 'US';
2024:
2025: l_prev_screen pay_element_entry_values_f.screen_entry_value%TYPE;
2026: l_prev_eleid pay_element_entry_values_f.element_entry_id%TYPE;
2027: l_percent pay_element_entry_values_f.screen_entry_value%TYPE;
2028: l_effective_start_date pay_element_entry_values_f.effective_start_date%TYPE;
2029: l_effective_end_date pay_element_entry_values_f.effective_end_date%TYPE;
2030:

Line 2027: l_percent pay_element_entry_values_f.screen_entry_value%TYPE;

2023: and pet.legislation_code = 'US';
2024:
2025: l_prev_screen pay_element_entry_values_f.screen_entry_value%TYPE;
2026: l_prev_eleid pay_element_entry_values_f.element_entry_id%TYPE;
2027: l_percent pay_element_entry_values_f.screen_entry_value%TYPE;
2028: l_effective_start_date pay_element_entry_values_f.effective_start_date%TYPE;
2029: l_effective_end_date pay_element_entry_values_f.effective_end_date%TYPE;
2030:
2031: BEGIN

Line 2028: l_effective_start_date pay_element_entry_values_f.effective_start_date%TYPE;

2024:
2025: l_prev_screen pay_element_entry_values_f.screen_entry_value%TYPE;
2026: l_prev_eleid pay_element_entry_values_f.element_entry_id%TYPE;
2027: l_percent pay_element_entry_values_f.screen_entry_value%TYPE;
2028: l_effective_start_date pay_element_entry_values_f.effective_start_date%TYPE;
2029: l_effective_end_date pay_element_entry_values_f.effective_end_date%TYPE;
2030:
2031: BEGIN
2032:

Line 2029: l_effective_end_date pay_element_entry_values_f.effective_end_date%TYPE;

2025: l_prev_screen pay_element_entry_values_f.screen_entry_value%TYPE;
2026: l_prev_eleid pay_element_entry_values_f.element_entry_id%TYPE;
2027: l_percent pay_element_entry_values_f.screen_entry_value%TYPE;
2028: l_effective_start_date pay_element_entry_values_f.effective_start_date%TYPE;
2029: l_effective_end_date pay_element_entry_values_f.effective_end_date%TYPE;
2030:
2031: BEGIN
2032:
2033: hr_utility.trace('Entering pay_us_geo_upd_pkg.duplicate_vertex_ee');

Line 2071: update pay_element_entry_values_f pev

2067: IF G_MODE = 'UPGRADE' THEN
2068:
2069: hr_utility.trace('The previous element entry id is: '||to_char(l_prev_eleid));
2070:
2071: update pay_element_entry_values_f pev
2072: set pev.screen_entry_value = pev.screen_entry_value + l_percent
2073: where pev.element_entry_id = l_prev_eleid
2074: and pev.screen_entry_value is not null
2075: and pev.input_value_id = (select distinct piv.input_value_id

Line 2394: where pugu.table_name = 'PAY_ELEMENT_ENTRY_VALUES_F'

2390: pay_us_emp_state_tax_rules_f pusf
2391: WHERE pusf.assignment_id = p_assign_id
2392: AND pusf.state_code = pus.state_abbrev
2393: AND NOT EXISTS (select 'Y' from PAY_US_GEO_UPDATE pugu
2394: where pugu.table_name = 'PAY_ELEMENT_ENTRY_VALUES_F'
2395: and pugu.process_type = 'PERCENTAGE_OVER_100'
2396: and pugu.assignment_id = p_assign_id
2397: and pugu.process_mode = g_mode
2398: and pugu.process_type = g_process_type

Line 2411: pay_element_entry_values_f pev2,

2407: CURSOR sum_cur(p_assign_id NUMBER, start_date DATE,
2408: end_date DATE, state_code CHAR) IS
2409: SELECT sum(nvl(to_number(pev2.screen_entry_value),0))
2410: FROM pay_input_values_f piv2,
2411: pay_element_entry_values_f pev2,
2412: pay_input_values_f piv1,
2413: pay_element_entry_values_f pev1,
2414: pay_element_types_f pet,
2415: pay_element_links_f pel,

Line 2413: pay_element_entry_values_f pev1,

2409: SELECT sum(nvl(to_number(pev2.screen_entry_value),0))
2410: FROM pay_input_values_f piv2,
2411: pay_element_entry_values_f pev2,
2412: pay_input_values_f piv1,
2413: pay_element_entry_values_f pev1,
2414: pay_element_types_f pet,
2415: pay_element_links_f pel,
2416: pay_element_entries_f pef
2417: WHERE pef.assignment_id = p_assign_id

Line 2505: p_location => 'PAY_ELEMENT_ENTRY_VALUES_F',

2501: p_person_id => l_person_id,
2502: p_assign_id => p_assign_id,
2503: p_old_juri_code => null,
2504: p_new_juri_code => null,
2505: p_location => 'PAY_ELEMENT_ENTRY_VALUES_F',
2506: p_id => null);
2507:
2508:
2509: hr_utility.set_location('pay_us_geo_upd_pkg.check_time',10);