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.HRASSACT dependencies on PAY_RUN_RESULT_VALUES

Line 1319: delete from pay_run_result_values RRV

1315: -- delete any unprocessed run result attached to the entry.
1316: if g_debug then
1317: hr_utility.set_location('hrassact.trash_quickpay',30);
1318: end if;
1319: delete from pay_run_result_values RRV
1320: where RRV.run_result_id in
1321: (select RR.run_result_id
1322: from pay_run_results RR
1323: where RR.source_type = 'E'

Line 1587: delete from pay_run_result_values RRV

1583: -- trigger on Run Results so we need to trash the values as well.
1584: if g_debug then
1585: hr_utility.set_location('hrassact.do_assact_rollback',10);
1586: end if;
1587: delete from pay_run_result_values RRV
1588: where RRV.run_result_id in
1589: (select RR.run_result_id
1590: from pay_run_results RR
1591: where RR.assignment_action_id = p_assact_rec.assact_id);

Line 2357: pay_run_result_values rrv

2353: and plb.defined_balance_id = pdb.defined_balance_id
2354: and exists (
2355: select null
2356: from pay_run_results prr,
2357: pay_run_result_values rrv
2358: where rrv.input_value_id = l_input_value_id
2359: and prr.run_result_id = rrv.run_result_id
2360: and prr.status in ('P', 'PA')
2361: and nvl(rrv.result_value, '0') <> '0');

Line 2373: pay_run_result_values rrv

2369: and lb.defined_balance_id = pdb.defined_balance_id
2370: and exists (
2371: select null
2372: from pay_run_results prr,
2373: pay_run_result_values rrv
2374: where rrv.input_value_id = l_input_value_id
2375: and prr.run_result_id = rrv.run_result_id
2376: and prr.status in ('P', 'PA')
2377: and nvl(rrv.result_value, '0') <> '0');

Line 2391: pay_run_result_values rrv

2387: and plb.defined_balance_id = pdb.defined_balance_id
2388: and exists (
2389: select null
2390: from pay_run_results prr,
2391: pay_run_result_values rrv
2392: where rrv.input_value_id = l_input_value_id
2393: and prr.run_result_id = rrv.run_result_id
2394: and prr.status in ('P', 'PA')
2395: and nvl(rrv.result_value, '0') <> '0');

Line 2431: pay_run_result_values rrv

2427: cursor ivchk is
2428: select '1' from dual
2429: where exists (select 1
2430: from pay_run_results prr,
2431: pay_run_result_values rrv
2432: where rrv.input_value_id = l_input_value_id
2433: and prr.run_result_id = rrv.run_result_id
2434: and prr.status in ('P', 'PA')
2435: and nvl(rrv.result_value, '0') <> '0');

Line 5493: insert into pay_run_result_values (

5489: --
5490: if g_debug then
5491: hr_utility.set_location('hrassact.reversal',35);
5492: end if;
5493: insert into pay_run_result_values (
5494: input_value_id,
5495: run_result_id,
5496: result_value)
5497: select piv.input_value_id,

Line 5525: pay_run_result_values rrv,

5521: , mask_38_dec_places), '.'),
5522: 'ND' , rtrim(to_char((-1) * to_number(rrv.result_value, mask_38_dec_places), mask_38_dec_places), '.'),
5523: rrv.result_value)
5524: from pay_payroll_actions pac,
5525: pay_run_result_values rrv,
5526: pay_input_values_f piv
5527: where pac.payroll_action_id = pactid
5528: and rrv.run_result_id = oldrrid
5529: and piv.input_value_id = rrv.input_value_id

Line 5730: insert into pay_run_result_values (

5726: --
5727: -- Now, insert the appropriate run result values.
5728: -- All the values should be null, the Payroll Run
5729: -- will fill these in later.
5730: insert into pay_run_result_values (
5731: input_value_id,
5732: run_result_id,
5733: result_value)
5734: select pev.input_value_id,

Line 5943: pay_run_result_values prrv,

5939: prrv.result_value,
5940: prrv.input_value_id,
5941: prrv.run_result_id
5942: from pay_run_results prr,
5943: pay_run_result_values prrv,
5944: pay_input_values_f piv
5945: where prr.run_result_id = p_run_result_id
5946: and prrv.run_result_id = prr.run_result_id
5947: and piv.input_value_id = prrv.input_value_id

Line 6090: l_ctx_value pay_run_result_values.result_value%type;

6086: if (rrvrec.name = g_dynamic_contexts(l_cnt).input_value_name) then
6087: --
6088: hr_utility.set_location(c_indent,95);
6089: declare
6090: l_ctx_value pay_run_result_values.result_value%type;
6091: begin
6092: l_ctx_value := null;
6093: --
6094: if (rrvrec.result_value is not null) then

Line 6129: update pay_run_result_values

6125: l_ctx_value);
6126: dbms_sql.close_cursor(sql_cursor);
6127: --
6128: -- OK we got the default, we need to set it
6129: update pay_run_result_values
6130: set result_value = l_ctx_value
6131: where run_result_id = rrvrec.run_result_id
6132: and input_value_id = rrvrec.input_value_id;
6133: --

Line 6775: from pay_run_result_values rrv

6771: cursor run_result_values is
6772: select rrv.input_value_id,
6773: rrv.result_value,
6774: rrv.run_result_id
6775: from pay_run_result_values rrv
6776: where rrv.run_result_id = rrid
6777: and rrv.result_value is not null;
6778:
6779: cursor fed_latest_balances(p_inp_val_id number,

Line 7051: l_jurisdiction_code pay_run_result_values.result_value%type;

7047: c_indent constant varchar2(35) := 'hrassact.lb_context_match_check';
7048: l_jurisdiction_level pay_balance_types.jurisdiction_level%TYPE;
7049: cnt number;
7050: l_tax_unit_id number;
7051: l_jurisdiction_code pay_run_result_values.result_value%type;
7052: l_original_entry_id number;
7053: l_source_id number;
7054: l_source_text pay_run_result_values.result_value%type;
7055: l_source_text2 pay_run_result_values.result_value%type;

Line 7054: l_source_text pay_run_result_values.result_value%type;

7050: l_tax_unit_id number;
7051: l_jurisdiction_code pay_run_result_values.result_value%type;
7052: l_original_entry_id number;
7053: l_source_id number;
7054: l_source_text pay_run_result_values.result_value%type;
7055: l_source_text2 pay_run_result_values.result_value%type;
7056: l_source_number number;
7057: l_source_number2 number;
7058: l_tax_group pay_run_result_values.result_value%type;

Line 7055: l_source_text2 pay_run_result_values.result_value%type;

7051: l_jurisdiction_code pay_run_result_values.result_value%type;
7052: l_original_entry_id number;
7053: l_source_id number;
7054: l_source_text pay_run_result_values.result_value%type;
7055: l_source_text2 pay_run_result_values.result_value%type;
7056: l_source_number number;
7057: l_source_number2 number;
7058: l_tax_group pay_run_result_values.result_value%type;
7059: l_local_unit_id number;

Line 7058: l_tax_group pay_run_result_values.result_value%type;

7054: l_source_text pay_run_result_values.result_value%type;
7055: l_source_text2 pay_run_result_values.result_value%type;
7056: l_source_number number;
7057: l_source_number2 number;
7058: l_tax_group pay_run_result_values.result_value%type;
7059: l_local_unit_id number;
7060: l_organization_id number;
7061: l_payroll_id number;
7062: --