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_RESULTS

Line 753: from pay_run_results

749: cursor c1 is
750: select null from dual
751: where exists
752: (select null -- check for any RRs
753: from pay_run_results
754: where assignment_action_id = p_assact_id)
755: or exists
756: (select null -- check for any MESSAGEs
757: from pay_message_lines

Line 781: from pay_run_results

777: cursor c2 is
778: select null from dual
779: where exists
780: (select null -- check for any RRs
781: from pay_run_results
782: where assignment_action_id = p_assact_id
783: and status <> 'B')
784: or exists
785: (select null -- check for any MESSAGEs

Line 1354: from pay_run_results RR

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'
1356: and RR.source_id = c1rec.element_entry_id);
1357: --
1358: if g_debug then

Line 1361: delete from pay_run_results RR

1357: --
1358: if g_debug then
1359: hr_utility.set_location('hrassact.trash_quickpay',40);
1360: end if;
1361: delete from pay_run_results RR
1362: where RR.source_type = 'E'
1363: and RR.source_id = c1rec.element_entry_id;
1364: --
1365: -- delete any element entry values

Line 1622: from pay_run_results RR

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);
1624: --
1625: if g_debug then
1626: hr_utility.set_location('hrassact.do_assact_rollback',20);

Line 1628: delete from pay_run_results RR

1624: --
1625: if g_debug then
1626: hr_utility.set_location('hrassact.do_assact_rollback',20);
1627: end if;
1628: delete from pay_run_results RR
1629: where RR.assignment_action_id = p_assact_rec.assact_id;
1630: --
1631: -- Delete latest balances. Not deleted via constraint due to
1632: -- performance requirements on Insert and Update, and also because

Line 2388: from pay_run_results prr,

2384: where pdb.balance_type_id = l_balance_type_id
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')

Line 2404: from pay_run_results prr,

2400: where pdb.balance_type_id = l_balance_type_id
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')

Line 2422: from pay_run_results prr,

2418: where pdb.balance_type_id = l_balance_type_id
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')

Line 2462: from pay_run_results prr,

2458: -- Select if run result value exists for input value
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')

Line 5362: pay_run_results prr,

5358: 'Y', pay_balance_pkg.find_context('ORGANIZATION_ID', prr.run_result_id),
5359: null) organization_id,
5360: ppa.effective_date
5361: from pay_assignment_actions paa,
5362: pay_run_results prr,
5363: pay_payroll_actions ppa
5364: where paa.assignment_action_id = revassactid
5365: and ppa.payroll_action_id = paa.payroll_action_id
5366: and paa.assignment_action_id = prr.assignment_action_id;

Line 5565: from pay_run_results prr

5561: prr.start_date,
5562: prr.end_date,
5563: prr.time_definition_id,
5564: prr.entry_process_path
5565: from pay_run_results prr
5566: where prr.assignment_action_id = assactid
5567: order by prr.run_result_id;
5568: --
5569: -- hold a run result record row.

Line 5570: oldrrid pay_run_results.run_result_id%type;

5566: where prr.assignment_action_id = assactid
5567: order by prr.run_result_id;
5568: --
5569: -- hold a run result record row.
5570: oldrrid pay_run_results.run_result_id%type;
5571: etypid pay_run_results.element_type_id%type;
5572: enttype pay_run_results.entry_type%type;
5573: srcid pay_run_results.source_id%type;
5574: stype pay_run_results.source_type%type;

Line 5571: etypid pay_run_results.element_type_id%type;

5567: order by prr.run_result_id;
5568: --
5569: -- hold a run result record row.
5570: oldrrid pay_run_results.run_result_id%type;
5571: etypid pay_run_results.element_type_id%type;
5572: enttype pay_run_results.entry_type%type;
5573: srcid pay_run_results.source_id%type;
5574: stype pay_run_results.source_type%type;
5575: stat pay_run_results.status%type;

Line 5572: enttype pay_run_results.entry_type%type;

5568: --
5569: -- hold a run result record row.
5570: oldrrid pay_run_results.run_result_id%type;
5571: etypid pay_run_results.element_type_id%type;
5572: enttype pay_run_results.entry_type%type;
5573: srcid pay_run_results.source_id%type;
5574: stype pay_run_results.source_type%type;
5575: stat pay_run_results.status%type;
5576: v_jcode pay_run_results.jurisdiction_code%type;

Line 5573: srcid pay_run_results.source_id%type;

5569: -- hold a run result record row.
5570: oldrrid pay_run_results.run_result_id%type;
5571: etypid pay_run_results.element_type_id%type;
5572: enttype pay_run_results.entry_type%type;
5573: srcid pay_run_results.source_id%type;
5574: stype pay_run_results.source_type%type;
5575: stat pay_run_results.status%type;
5576: v_jcode pay_run_results.jurisdiction_code%type;
5577: start_date pay_run_results.start_date%type;

Line 5574: stype pay_run_results.source_type%type;

5570: oldrrid pay_run_results.run_result_id%type;
5571: etypid pay_run_results.element_type_id%type;
5572: enttype pay_run_results.entry_type%type;
5573: srcid pay_run_results.source_id%type;
5574: stype pay_run_results.source_type%type;
5575: stat pay_run_results.status%type;
5576: v_jcode pay_run_results.jurisdiction_code%type;
5577: start_date pay_run_results.start_date%type;
5578: end_date pay_run_results.end_date%type;

Line 5575: stat pay_run_results.status%type;

5571: etypid pay_run_results.element_type_id%type;
5572: enttype pay_run_results.entry_type%type;
5573: srcid pay_run_results.source_id%type;
5574: stype pay_run_results.source_type%type;
5575: stat pay_run_results.status%type;
5576: v_jcode pay_run_results.jurisdiction_code%type;
5577: start_date pay_run_results.start_date%type;
5578: end_date pay_run_results.end_date%type;
5579: time_def_id pay_run_results.time_definition_id%type;

Line 5576: v_jcode pay_run_results.jurisdiction_code%type;

5572: enttype pay_run_results.entry_type%type;
5573: srcid pay_run_results.source_id%type;
5574: stype pay_run_results.source_type%type;
5575: stat pay_run_results.status%type;
5576: v_jcode pay_run_results.jurisdiction_code%type;
5577: start_date pay_run_results.start_date%type;
5578: end_date pay_run_results.end_date%type;
5579: time_def_id pay_run_results.time_definition_id%type;
5580: entrypath pay_run_results.entry_process_path%type;

Line 5577: start_date pay_run_results.start_date%type;

5573: srcid pay_run_results.source_id%type;
5574: stype pay_run_results.source_type%type;
5575: stat pay_run_results.status%type;
5576: v_jcode pay_run_results.jurisdiction_code%type;
5577: start_date pay_run_results.start_date%type;
5578: end_date pay_run_results.end_date%type;
5579: time_def_id pay_run_results.time_definition_id%type;
5580: entrypath pay_run_results.entry_process_path%type;
5581: --

Line 5578: end_date pay_run_results.end_date%type;

5574: stype pay_run_results.source_type%type;
5575: stat pay_run_results.status%type;
5576: v_jcode pay_run_results.jurisdiction_code%type;
5577: start_date pay_run_results.start_date%type;
5578: end_date pay_run_results.end_date%type;
5579: time_def_id pay_run_results.time_definition_id%type;
5580: entrypath pay_run_results.entry_process_path%type;
5581: --
5582: -- format mask for result value

Line 5579: time_def_id pay_run_results.time_definition_id%type;

5575: stat pay_run_results.status%type;
5576: v_jcode pay_run_results.jurisdiction_code%type;
5577: start_date pay_run_results.start_date%type;
5578: end_date pay_run_results.end_date%type;
5579: time_def_id pay_run_results.time_definition_id%type;
5580: entrypath pay_run_results.entry_process_path%type;
5581: --
5582: -- format mask for result value
5583: mask_36_dec_places varchar2(100);

Line 5580: entrypath pay_run_results.entry_process_path%type;

5576: v_jcode pay_run_results.jurisdiction_code%type;
5577: start_date pay_run_results.start_date%type;
5578: end_date pay_run_results.end_date%type;
5579: time_def_id pay_run_results.time_definition_id%type;
5580: entrypath pay_run_results.entry_process_path%type;
5581: --
5582: -- format mask for result value
5583: mask_36_dec_places varchar2(100);
5584: l_src_iv varchar2(30);

Line 5639: insert into pay_run_results (

5635: if g_debug then
5636: hr_utility.set_location('hrassact.reversal',30);
5637: end if;
5638:
5639: insert into pay_run_results (
5640: run_result_id,
5641: element_type_id,
5642: assignment_action_id,
5643: entry_type,

Line 5652: values (pay_run_results_s.nextval,

5648: start_date,
5649: end_date,
5650: time_definition_id,
5651: entry_process_path)
5652: values (pay_run_results_s.nextval,
5653: etypid,
5654: rev_assact, -- the reversal assignment action.
5655: enttype,
5656: oldrrid,

Line 5734: pay_run_results_s.currval,

5730: input_value_id,
5731: run_result_id,
5732: result_value)
5733: select piv.input_value_id,
5734: pay_run_results_s.currval,
5735: decode(piv.uom,
5736: 'XXXXXXXXXX', '***********************',
5737: 'H_DECIMAL1', rtrim(to_char((-1) * to_number(rrv.result_value, mask_36_dec_places), mask_36_dec_places), '.'),
5738: 'H_DECIMAL2', rtrim(to_char((-1) * to_number(rrv.result_value, mask_36_dec_places), mask_36_dec_places), '.'),

Line 5934: pay_run_results rr2,

5930: from pay_payroll_actions pac,
5931: pay_assignment_actions act,
5932: pay_action_interlocks pai,
5933: pay_assignment_actions act2,
5934: pay_run_results rr2,
5935: pay_element_entries_f pee,
5936: pay_element_links_f pel,
5937: pay_element_types_f pet
5938: where pac.payroll_action_id = p_payroll_action_id

Line 5959: from pay_run_results rr3

5955: and rr2.assignment_action_id = act2.assignment_action_id
5956: and rr2.status <> 'U'
5957: and not exists (
5958: select null
5959: from pay_run_results rr3
5960: where rr3.source_id = pee.element_entry_id
5961: and rr3.status = 'U')
5962: order by pee.element_entry_id;
5963: --

Line 5973: insert into pay_run_results (

5969: hr_utility.set_location(c_indent, 10);
5970: end if;
5971: for c1rec in c1 loop
5972: -- Start with insertion of run result.
5973: insert into pay_run_results (
5974: run_result_id,
5975: element_type_id,
5976: assignment_action_id,
5977: entry_type,

Line 5982: values (pay_run_results_s.nextval,

5978: source_id,
5979: source_type,
5980: status,
5981: jurisdiction_code)
5982: values (pay_run_results_s.nextval,
5983: c1rec.element_type_id,
5984: c1rec.assignment_action_id,
5985: c1rec.entry_type,
5986: c1rec.element_entry_id,

Line 5999: pay_run_results_s.currval,

5995: input_value_id,
5996: run_result_id,
5997: result_value)
5998: select pev.input_value_id,
5999: pay_run_results_s.currval,
6000: null
6001: from pay_payroll_actions pac,
6002: pay_assignment_actions act, -- reversal
6003: pay_element_entry_values_f pev

Line 6206: from pay_run_results prr,

6202: select piv.name,
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

Line 6317: from pay_run_results

6313: select end_date,
6314: time_definition_id
6315: into l_ctx_balance_date,
6316: l_ctx_time_def_id
6317: from pay_run_results
6318: where run_result_id = p_rrid;
6319: --
6320: if l_ctx_balance_date is not null then
6321: get_cache_context('BALANCE_DATE', cxt_id);

Line 6412: update pay_run_results

6408: if l_ctx_value is not null then
6409: --
6410: -- Set the jurisdiction on the run_result.
6411: if (g_dynamic_contexts(l_cnt).context_name = 'JURISDICTION_CODE') then
6412: update pay_run_results
6413: set jurisdiction_code = l_ctx_value
6414: where run_result_id = p_rrid;
6415: --
6416: elsif (g_dynamic_contexts(l_cnt).context_name = 'ORGANIZATION_ID') then

Line 6502: from pay_run_results

6498: l_local_unit_id number;
6499: begin
6500: select local_unit_id
6501: into l_local_unit_id
6502: from pay_run_results
6503: where run_result_id = p_rrid;
6504: --
6505: if l_local_unit_id is not null then
6506: if g_debug then

Line 6700: -- pay_run_results.

6696: -- and element type is date effective. In the case of
6697: -- the assignment, this should be confirming what has
6698: -- already been checked by the form.
6699: -- In addition, select a sequence value for
6700: -- pay_run_results.
6701: --
6702: -- Bug #3482270 - original entry id support.
6703: -- Original_entry_id will be also derived from the entry
6704: -- record here, which must have already been validated and

Line 6894: hr_utility.trace('Update of pay_run_results has failed');

6890:
6891: --
6892: if(sql%notfound) then
6893: if g_debug then
6894: hr_utility.trace('Update of pay_run_results has failed');
6895: end if;
6896: raise no_data_found;
6897: end if;
6898: --

Line 8470: from pay_run_results rr

8466: --
8467: -- Derive element type id from the run result.
8468: --
8469: select rr.element_type_id into l_element_type_id
8470: from pay_run_results rr
8471: where rr.run_result_id = rrid;
8472:
8473: del_latest_balances(asgid, effdate, eentryid, l_element_type_id);
8474: return;