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 1351: delete from pay_run_result_values RRV

1347: -- delete any unprocessed run result attached to the entry.
1348: if g_debug then
1349: hr_utility.set_location('hrassact.trash_quickpay',30);
1350: end if;
1351: delete from pay_run_result_values RRV
1352: where RRV.run_result_id in
1353: (select RR.run_result_id
1354: from pay_run_results RR
1355: where RR.source_type = 'E'

Line 1619: delete from pay_run_result_values RRV

1615: -- trigger on Run Results so we need to trash the values as well.
1616: if g_debug then
1617: hr_utility.set_location('hrassact.do_assact_rollback',10);
1618: end if;
1619: delete from pay_run_result_values RRV
1620: where RRV.run_result_id in
1621: (select RR.run_result_id
1622: from pay_run_results RR
1623: where RR.assignment_action_id = p_assact_rec.assact_id);

Line 2389: pay_run_result_values rrv

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

Line 2405: pay_run_result_values rrv

2401: and lb.defined_balance_id = pdb.defined_balance_id
2402: and exists (
2403: select null
2404: from pay_run_results prr,
2405: pay_run_result_values rrv
2406: where rrv.input_value_id = l_input_value_id
2407: and prr.run_result_id = rrv.run_result_id
2408: and prr.status in ('P', 'PA')
2409: and nvl(rrv.result_value, '0') <> '0');

Line 2423: pay_run_result_values rrv

2419: and plb.defined_balance_id = pdb.defined_balance_id
2420: and exists (
2421: select null
2422: from pay_run_results prr,
2423: pay_run_result_values rrv
2424: where rrv.input_value_id = l_input_value_id
2425: and prr.run_result_id = rrv.run_result_id
2426: and prr.status in ('P', 'PA')
2427: and nvl(rrv.result_value, '0') <> '0');

Line 2463: pay_run_result_values rrv

2459: cursor ivchk is
2460: select '1' from dual
2461: where exists (select 1
2462: from pay_run_results prr,
2463: pay_run_result_values rrv
2464: where rrv.input_value_id = l_input_value_id
2465: and prr.run_result_id = rrv.run_result_id
2466: and prr.status in ('P', 'PA')
2467: and nvl(rrv.result_value, '0') <> '0');

Line 5729: insert into pay_run_result_values (

5725: --
5726: if g_debug then
5727: hr_utility.set_location('hrassact.reversal',35);
5728: end if;
5729: insert into pay_run_result_values (
5730: input_value_id,
5731: run_result_id,
5732: result_value)
5733: select piv.input_value_id,

Line 5761: pay_run_result_values rrv,

5757: , mask_36_dec_places), '.'),
5758: 'ND' , rtrim(to_char((-1) * to_number(rrv.result_value, mask_36_dec_places), mask_36_dec_places), '.'),
5759: rrv.result_value)
5760: from pay_payroll_actions pac,
5761: pay_run_result_values rrv,
5762: pay_input_values_f piv
5763: where pac.payroll_action_id = pactid
5764: and rrv.run_result_id = oldrrid
5765: and piv.input_value_id = rrv.input_value_id

Line 5994: insert into pay_run_result_values (

5990: --
5991: -- Now, insert the appropriate run result values.
5992: -- All the values should be null, the Payroll Run
5993: -- will fill these in later.
5994: insert into pay_run_result_values (
5995: input_value_id,
5996: run_result_id,
5997: result_value)
5998: select pev.input_value_id,

Line 6207: pay_run_result_values prrv,

6203: prrv.result_value,
6204: prrv.input_value_id,
6205: prrv.run_result_id
6206: from pay_run_results prr,
6207: pay_run_result_values prrv,
6208: pay_input_values_f piv
6209: where prr.run_result_id = p_run_result_id
6210: and prrv.run_result_id = prr.run_result_id
6211: and piv.input_value_id = prrv.input_value_id

Line 6354: l_ctx_value pay_run_result_values.result_value%type;

6350: if (rrvrec.name = g_dynamic_contexts(l_cnt).input_value_name) then
6351: --
6352: hr_utility.set_location(c_indent,95);
6353: declare
6354: l_ctx_value pay_run_result_values.result_value%type;
6355: begin
6356: l_ctx_value := null;
6357: --
6358: if (rrvrec.result_value is not null) then

Line 6393: update pay_run_result_values

6389: l_ctx_value);
6390: dbms_sql.close_cursor(sql_cursor);
6391: --
6392: -- OK we got the default, we need to set it
6393: update pay_run_result_values
6394: set result_value = l_ctx_value
6395: where run_result_id = rrvrec.run_result_id
6396: and input_value_id = rrvrec.input_value_id;
6397: --

Line 7039: from pay_run_result_values rrv

7035: cursor run_result_values is
7036: select rrv.input_value_id,
7037: rrv.result_value,
7038: rrv.run_result_id
7039: from pay_run_result_values rrv
7040: where rrv.run_result_id = rrid
7041: and rrv.result_value is not null;
7042:
7043: cursor fed_latest_balances(p_inp_val_id number,

Line 7316: l_jurisdiction_code pay_run_result_values.result_value%type;

7312: c_indent constant varchar2(35) := 'hrassact.lb_context_match_check';
7313: l_jurisdiction_level pay_balance_types.jurisdiction_level%TYPE;
7314: cnt number;
7315: l_tax_unit_id number;
7316: l_jurisdiction_code pay_run_result_values.result_value%type;
7317: l_original_entry_id number;
7318: l_source_id number;
7319: l_source_text pay_run_result_values.result_value%type;
7320: l_source_text2 pay_run_result_values.result_value%type;

Line 7319: l_source_text pay_run_result_values.result_value%type;

7315: l_tax_unit_id number;
7316: l_jurisdiction_code pay_run_result_values.result_value%type;
7317: l_original_entry_id number;
7318: l_source_id number;
7319: l_source_text pay_run_result_values.result_value%type;
7320: l_source_text2 pay_run_result_values.result_value%type;
7321: l_source_number number;
7322: l_source_number2 number;
7323: l_tax_group pay_run_result_values.result_value%type;

Line 7320: l_source_text2 pay_run_result_values.result_value%type;

7316: l_jurisdiction_code pay_run_result_values.result_value%type;
7317: l_original_entry_id number;
7318: l_source_id number;
7319: l_source_text pay_run_result_values.result_value%type;
7320: l_source_text2 pay_run_result_values.result_value%type;
7321: l_source_number number;
7322: l_source_number2 number;
7323: l_tax_group pay_run_result_values.result_value%type;
7324: l_local_unit_id number;

Line 7323: l_tax_group pay_run_result_values.result_value%type;

7319: l_source_text pay_run_result_values.result_value%type;
7320: l_source_text2 pay_run_result_values.result_value%type;
7321: l_source_number number;
7322: l_source_number2 number;
7323: l_tax_group pay_run_result_values.result_value%type;
7324: l_local_unit_id number;
7325: l_organization_id number;
7326: l_payroll_id number;
7327: --