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_INPUT_VALUES_F

Line 5: --input_value_id from pay_input_values_f

1: PACKAGE BODY pay_us_geo_upd_pkg as
2: /* $Header: pyusgeou.pkb 120.27.12020000.8 2012/10/25 04:28:37 emunisek ship $ */
3:
4: --Bug 2996546 declare pl/sql table variables in order to load
5: --input_value_id from pay_input_values_f
6:
7:
8: TYPE piv_type is table of pay_input_values_f.input_value_id%type
9: index by binary_integer ;

Line 8: TYPE piv_type is table of pay_input_values_f.input_value_id%type

4: --Bug 2996546 declare pl/sql table variables in order to load
5: --input_value_id from pay_input_values_f
6:
7:
8: TYPE piv_type is table of pay_input_values_f.input_value_id%type
9: index by binary_integer ;
10: l_counter number := 0 ;
11: l_total number := 0 ;
12: l_number number := 0 ;

Line 16: piv_rec pay_input_values_f%rowtype;

12: l_number number := 0 ;
13:
14:
15: input_val_cur piv_type ;
16: piv_rec pay_input_values_f%rowtype;
17:
18:
19: function get_parameter(name in varchar2,
20: parameter_list varchar2) return varchar2

Line 1042: pay_input_values_f piv

1038: SELECT /*+ ORDERED */ distinct pev.screen_entry_value, pev.element_entry_id,
1039: pev.input_value_id
1040: FROM pay_element_entries_f pee,
1041: pay_element_entry_values_f pev,
1042: pay_input_values_f piv
1043: WHERE pee.assignment_id = assign_id
1044: AND pee.element_entry_id = pev.element_entry_id
1045: AND pev.screen_entry_value = geocode
1046: AND pev.input_value_id = piv.input_value_id

Line 1319: --from pay_input_values_f into a pl/sql table input_val_cur

1315: --
1316: --
1317: --
1318: --Bug 2996546 PROCEDURE load_input_values loads input_value_id
1319: --from pay_input_values_f into a pl/sql table input_val_cur
1320: -- for both seeded and non-seeded in US and Canada Legislations
1321: --
1322: --
1323: --

Line 1329: from pay_input_values_f piv

1325: Begin
1326:
1327: for piv_rec in (
1328: select piv.input_value_id
1329: from pay_input_values_f piv
1330: where piv.name in ('Jurisdiction', 'jd_rs', 'jd_wk')
1331: and ( (piv.legislation_code in( 'US', 'CA')
1332: )
1333: OR (piv.legislation_code is null

Line 1737: FROM pay_input_values_f piv

1733: FROM pay_run_result_values prv
1734: WHERE prv.result_value = p_new_juri_code
1735: AND prv.run_result_id = p_run_result_id
1736: AND EXISTS (SELECT 0
1737: FROM pay_input_values_f piv
1738: WHERE piv.input_value_id = prv.input_value_id
1739: AND (piv.name = 'Jurisdiction' OR
1740: piv.name = 'jd_rs' OR
1741: piv.name = 'jd_wk')

Line 1797: FROM pay_input_values_f piv

1793: SET prv.result_value = p_new_juri_code
1794: WHERE prv.run_result_id = p_run_result_id
1795: AND prv.result_value = p_old_juri_code
1796: AND EXISTS (SELECT 0
1797: FROM pay_input_values_f piv
1798: WHERE piv.input_value_id = prv.input_value_id
1799: AND (piv.name = 'Jurisdiction' OR
1800: piv.name = 'jd_rs' OR
1801: piv.name = 'jd_wk')

Line 2278: pay_input_values_f piv,

2274: -- This cursor will get us the element entries of the assignments processed
2275: cursor csr_get_dup (p_assignment number) is
2276: select pev.screen_entry_value sev, pev.element_entry_id eei
2277: from pay_element_entry_values_f pev,
2278: pay_input_values_f piv,
2279: pay_element_types_f pet,
2280: pay_element_links_f pel,
2281: pay_element_entries_f pee
2282: where pee.assignment_id = p_assignment

Line 2299: pay_input_values_f piv,

2295: cursor csr_get_percentage (p_element_entry_id NUMBER) is
2296: select /*Bug 7592909*/distinct pev.screen_entry_value , pev.effective_start_date,
2297: pev.effective_end_date
2298: from pay_element_entry_values_f pev,
2299: pay_input_values_f piv,
2300: pay_element_types_f pet,
2301: pay_element_links_f pel,
2302: pay_element_entries_f pef
2303: where pef.element_entry_id = p_element_entry_id

Line 2366: from pay_input_values_f piv,

2362: set pev.screen_entry_value = pev.screen_entry_value + l_percent
2363: where pev.element_entry_id = l_prev_eleid
2364: and pev.screen_entry_value is not null
2365: and pev.input_value_id = (select distinct piv.input_value_id
2366: from pay_input_values_f piv,
2367: pay_element_types_f pet,
2368: pay_element_links_f pel,
2369: pay_element_entries_f pef
2370: where pef.element_entry_id =

Line 2703: FROM pay_input_values_f piv2,

2699: --jurisdiction for the effective dates of the assignment.
2700: CURSOR sum_cur(p_assign_id NUMBER, start_date DATE,
2701: end_date DATE, state_code CHAR) IS
2702: SELECT sum(nvl(to_number(pev2.screen_entry_value),0))
2703: FROM pay_input_values_f piv2,
2704: pay_element_entry_values_f pev2,
2705: pay_input_values_f piv1,
2706: pay_element_entry_values_f pev1,
2707: pay_element_types_f pet,

Line 2705: pay_input_values_f piv1,

2701: end_date DATE, state_code CHAR) IS
2702: SELECT sum(nvl(to_number(pev2.screen_entry_value),0))
2703: FROM pay_input_values_f piv2,
2704: pay_element_entry_values_f pev2,
2705: pay_input_values_f piv1,
2706: pay_element_entry_values_f pev1,
2707: pay_element_types_f pet,
2708: pay_element_links_f pel,
2709: pay_element_entries_f pef

Line 4950: --to return pay_input_values_f.input_value_id

4946: END upgrade_geo_api;
4947:
4948: --
4949: --Per bug 2996546 created a public function
4950: --to return pay_input_values_f.input_value_id
4951: --after comparing values stored in a pl/sql table
4952: --
4953:
4954: Function IS_US_OR_CA_LEGISLATION

Line 4955: (p_input_value_id in pay_input_values_f.input_value_id%TYPE)

4951: --after comparing values stored in a pl/sql table
4952: --
4953:
4954: Function IS_US_OR_CA_LEGISLATION
4955: (p_input_value_id in pay_input_values_f.input_value_id%TYPE)
4956: Return pay_input_values_f.input_value_id%TYPE Is
4957:
4958: Begin
4959: for l_number in 1..l_total

Line 4956: Return pay_input_values_f.input_value_id%TYPE Is

4952: --
4953:
4954: Function IS_US_OR_CA_LEGISLATION
4955: (p_input_value_id in pay_input_values_f.input_value_id%TYPE)
4956: Return pay_input_values_f.input_value_id%TYPE Is
4957:
4958: Begin
4959: for l_number in 1..l_total
4960: loop