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.14.12010000.3 2008/08/14 11:14:12 pannapur 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 833: pay_input_values_f piv

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
837: AND pev.input_value_id = piv.input_value_id

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

1106: --
1107: --
1108: --
1109: --Bug 2996546 PROCEDURE load_input_values loads input_value_id
1110: --from pay_input_values_f into a pl/sql table input_val_cur
1111: -- for both seeded and non-seeded in US and Canada Legislations
1112: --
1113: --
1114: --

Line 1120: from pay_input_values_f piv

1116: Begin
1117:
1118: for piv_rec in (
1119: select piv.input_value_id
1120: from pay_input_values_f piv
1121: where piv.name in ('Jurisdiction', 'jd_rs', 'jd_wk')
1122: and ( (piv.legislation_code in( 'US', 'CA')
1123: )
1124: OR (piv.legislation_code is null

Line 1499: FROM pay_input_values_f piv

1495: FROM pay_run_result_values prv
1496: WHERE prv.result_value = p_new_juri_code
1497: AND prv.run_result_id = p_run_result_id
1498: AND EXISTS (SELECT 0
1499: FROM pay_input_values_f piv
1500: WHERE piv.input_value_id = prv.input_value_id
1501: AND (piv.name = 'Jurisdiction' OR
1502: piv.name = 'jd_rs' OR
1503: piv.name = 'jd_wk')

Line 1559: FROM pay_input_values_f piv

1555: SET prv.result_value = p_new_juri_code
1556: WHERE prv.run_result_id = p_run_result_id
1557: AND prv.result_value = p_old_juri_code
1558: AND EXISTS (SELECT 0
1559: FROM pay_input_values_f piv
1560: WHERE piv.input_value_id = prv.input_value_id
1561: AND (piv.name = 'Jurisdiction' OR
1562: piv.name = 'jd_rs' OR
1563: piv.name = 'jd_wk')

Line 1988: pay_input_values_f piv,

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
1992: where pee.assignment_id = p_assignment

Line 2009: pay_input_values_f piv,

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
2013: where pef.element_entry_id = p_element_entry_id

Line 2076: from pay_input_values_f piv,

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
2076: from pay_input_values_f piv,
2077: pay_element_types_f pet,
2078: pay_element_links_f pel,
2079: pay_element_entries_f pef
2080: where pef.element_entry_id =

Line 2410: FROM pay_input_values_f piv2,

2406: --jurisdiction for the effective dates of the assignment.
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,

Line 2412: pay_input_values_f piv1,

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,
2416: pay_element_entries_f pef

Line 3678: --to return pay_input_values_f.input_value_id

3674: END upgrade_geo_api;
3675:
3676: --
3677: --Per bug 2996546 created a public function
3678: --to return pay_input_values_f.input_value_id
3679: --after comparing values stored in a pl/sql table
3680: --
3681:
3682: Function IS_US_OR_CA_LEGISLATION

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

3679: --after comparing values stored in a pl/sql table
3680: --
3681:
3682: Function IS_US_OR_CA_LEGISLATION
3683: (p_input_value_id in pay_input_values_f.input_value_id%TYPE)
3684: Return pay_input_values_f.input_value_id%TYPE Is
3685:
3686: Begin
3687: for l_number in 1..l_total

Line 3684: Return pay_input_values_f.input_value_id%TYPE Is

3680: --
3681:
3682: Function IS_US_OR_CA_LEGISLATION
3683: (p_input_value_id in pay_input_values_f.input_value_id%TYPE)
3684: Return pay_input_values_f.input_value_id%TYPE Is
3685:
3686: Begin
3687: for l_number in 1..l_total
3688: loop