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 721: from pay_run_results

717: cursor c1 is
718: select null from dual
719: where exists
720: (select null -- check for any RRs
721: from pay_run_results
722: where assignment_action_id = p_assact_id)
723: or exists
724: (select null -- check for any MESSAGEs
725: from pay_message_lines

Line 749: from pay_run_results

745: cursor c2 is
746: select null from dual
747: where exists
748: (select null -- check for any RRs
749: from pay_run_results
750: where assignment_action_id = p_assact_id
751: and status <> 'B')
752: or exists
753: (select null -- check for any MESSAGEs

Line 1322: from pay_run_results RR

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'
1324: and RR.source_id = c1rec.element_entry_id);
1325: --
1326: if g_debug then

Line 1329: delete from pay_run_results RR

1325: --
1326: if g_debug then
1327: hr_utility.set_location('hrassact.trash_quickpay',40);
1328: end if;
1329: delete from pay_run_results RR
1330: where RR.source_type = 'E'
1331: and RR.source_id = c1rec.element_entry_id;
1332: --
1333: -- delete any element entry values

Line 1590: from pay_run_results RR

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);
1592: --
1593: if g_debug then
1594: hr_utility.set_location('hrassact.do_assact_rollback',20);

Line 1596: delete from pay_run_results RR

1592: --
1593: if g_debug then
1594: hr_utility.set_location('hrassact.do_assact_rollback',20);
1595: end if;
1596: delete from pay_run_results RR
1597: where RR.assignment_action_id = p_assact_rec.assact_id;
1598: --
1599: -- Delete latest balances. Not deleted via constraint due to
1600: -- performance requirements on Insert and Update, and also because

Line 2356: from pay_run_results prr,

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

Line 2372: from pay_run_results prr,

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

Line 2390: from pay_run_results prr,

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

Line 2430: from pay_run_results prr,

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

Line 5130: pay_run_results prr,

5126: 'Y', pay_balance_pkg.find_context('ORGANIZATION_ID', prr.run_result_id),
5127: null) organization_id,
5128: ppa.effective_date
5129: from pay_assignment_actions paa,
5130: pay_run_results prr,
5131: pay_payroll_actions ppa
5132: where paa.assignment_action_id = revassactid
5133: and ppa.payroll_action_id = paa.payroll_action_id
5134: and paa.assignment_action_id = prr.assignment_action_id;

Line 5333: from pay_run_results prr

5329: prr.start_date,
5330: prr.end_date,
5331: prr.time_definition_id,
5332: prr.entry_process_path
5333: from pay_run_results prr
5334: where prr.assignment_action_id = assactid
5335: order by prr.run_result_id;
5336: --
5337: -- hold a run result record row.

Line 5338: oldrrid pay_run_results.run_result_id%type;

5334: where prr.assignment_action_id = assactid
5335: order by prr.run_result_id;
5336: --
5337: -- hold a run result record row.
5338: oldrrid pay_run_results.run_result_id%type;
5339: etypid pay_run_results.element_type_id%type;
5340: enttype pay_run_results.entry_type%type;
5341: srcid pay_run_results.source_id%type;
5342: stype pay_run_results.source_type%type;

Line 5339: etypid pay_run_results.element_type_id%type;

5335: order by prr.run_result_id;
5336: --
5337: -- hold a run result record row.
5338: oldrrid pay_run_results.run_result_id%type;
5339: etypid pay_run_results.element_type_id%type;
5340: enttype pay_run_results.entry_type%type;
5341: srcid pay_run_results.source_id%type;
5342: stype pay_run_results.source_type%type;
5343: stat pay_run_results.status%type;

Line 5340: enttype pay_run_results.entry_type%type;

5336: --
5337: -- hold a run result record row.
5338: oldrrid pay_run_results.run_result_id%type;
5339: etypid pay_run_results.element_type_id%type;
5340: enttype pay_run_results.entry_type%type;
5341: srcid pay_run_results.source_id%type;
5342: stype pay_run_results.source_type%type;
5343: stat pay_run_results.status%type;
5344: v_jcode pay_run_results.jurisdiction_code%type;

Line 5341: srcid pay_run_results.source_id%type;

5337: -- hold a run result record row.
5338: oldrrid pay_run_results.run_result_id%type;
5339: etypid pay_run_results.element_type_id%type;
5340: enttype pay_run_results.entry_type%type;
5341: srcid pay_run_results.source_id%type;
5342: stype pay_run_results.source_type%type;
5343: stat pay_run_results.status%type;
5344: v_jcode pay_run_results.jurisdiction_code%type;
5345: start_date pay_run_results.start_date%type;

Line 5342: stype pay_run_results.source_type%type;

5338: oldrrid pay_run_results.run_result_id%type;
5339: etypid pay_run_results.element_type_id%type;
5340: enttype pay_run_results.entry_type%type;
5341: srcid pay_run_results.source_id%type;
5342: stype pay_run_results.source_type%type;
5343: stat pay_run_results.status%type;
5344: v_jcode pay_run_results.jurisdiction_code%type;
5345: start_date pay_run_results.start_date%type;
5346: end_date pay_run_results.end_date%type;

Line 5343: stat pay_run_results.status%type;

5339: etypid pay_run_results.element_type_id%type;
5340: enttype pay_run_results.entry_type%type;
5341: srcid pay_run_results.source_id%type;
5342: stype pay_run_results.source_type%type;
5343: stat pay_run_results.status%type;
5344: v_jcode pay_run_results.jurisdiction_code%type;
5345: start_date pay_run_results.start_date%type;
5346: end_date pay_run_results.end_date%type;
5347: time_def_id pay_run_results.time_definition_id%type;

Line 5344: v_jcode pay_run_results.jurisdiction_code%type;

5340: enttype pay_run_results.entry_type%type;
5341: srcid pay_run_results.source_id%type;
5342: stype pay_run_results.source_type%type;
5343: stat pay_run_results.status%type;
5344: v_jcode pay_run_results.jurisdiction_code%type;
5345: start_date pay_run_results.start_date%type;
5346: end_date pay_run_results.end_date%type;
5347: time_def_id pay_run_results.time_definition_id%type;
5348: entrypath pay_run_results.entry_process_path%type;

Line 5345: start_date pay_run_results.start_date%type;

5341: srcid pay_run_results.source_id%type;
5342: stype pay_run_results.source_type%type;
5343: stat pay_run_results.status%type;
5344: v_jcode pay_run_results.jurisdiction_code%type;
5345: start_date pay_run_results.start_date%type;
5346: end_date pay_run_results.end_date%type;
5347: time_def_id pay_run_results.time_definition_id%type;
5348: entrypath pay_run_results.entry_process_path%type;
5349: --

Line 5346: end_date pay_run_results.end_date%type;

5342: stype pay_run_results.source_type%type;
5343: stat pay_run_results.status%type;
5344: v_jcode pay_run_results.jurisdiction_code%type;
5345: start_date pay_run_results.start_date%type;
5346: end_date pay_run_results.end_date%type;
5347: time_def_id pay_run_results.time_definition_id%type;
5348: entrypath pay_run_results.entry_process_path%type;
5349: --
5350: -- format mask for result value

Line 5347: time_def_id pay_run_results.time_definition_id%type;

5343: stat pay_run_results.status%type;
5344: v_jcode pay_run_results.jurisdiction_code%type;
5345: start_date pay_run_results.start_date%type;
5346: end_date pay_run_results.end_date%type;
5347: time_def_id pay_run_results.time_definition_id%type;
5348: entrypath pay_run_results.entry_process_path%type;
5349: --
5350: -- format mask for result value
5351: mask_38_dec_places varchar2(100);

Line 5348: entrypath pay_run_results.entry_process_path%type;

5344: v_jcode pay_run_results.jurisdiction_code%type;
5345: start_date pay_run_results.start_date%type;
5346: end_date pay_run_results.end_date%type;
5347: time_def_id pay_run_results.time_definition_id%type;
5348: entrypath pay_run_results.entry_process_path%type;
5349: --
5350: -- format mask for result value
5351: mask_38_dec_places varchar2(100);
5352: l_src_iv varchar2(30);

Line 5403: insert into pay_run_results (

5399: if g_debug then
5400: hr_utility.set_location('hrassact.reversal',30);
5401: end if;
5402:
5403: insert into pay_run_results (
5404: run_result_id,
5405: element_type_id,
5406: assignment_action_id,
5407: entry_type,

Line 5416: values (pay_run_results_s.nextval,

5412: start_date,
5413: end_date,
5414: time_definition_id,
5415: entry_process_path)
5416: values (pay_run_results_s.nextval,
5417: etypid,
5418: rev_assact, -- the reversal assignment action.
5419: enttype,
5420: oldrrid,

Line 5498: pay_run_results_s.currval,

5494: input_value_id,
5495: run_result_id,
5496: result_value)
5497: select piv.input_value_id,
5498: pay_run_results_s.currval,
5499: decode(piv.uom,
5500: 'XXXXXXXXXX', '***********************',
5501: 'H_DECIMAL1', rtrim(to_char((-1) * to_number(rrv.result_value, mask_38_dec_places), mask_38_dec_places), '.'),
5502: 'H_DECIMAL2', rtrim(to_char((-1) * to_number(rrv.result_value, mask_38_dec_places), mask_38_dec_places), '.'),

Line 5670: pay_run_results rr2,

5666: from pay_payroll_actions pac,
5667: pay_assignment_actions act,
5668: pay_action_interlocks pai,
5669: pay_assignment_actions act2,
5670: pay_run_results rr2,
5671: pay_element_entries_f pee,
5672: pay_element_links_f pel,
5673: pay_element_types_f pet
5674: where pac.payroll_action_id = p_payroll_action_id

Line 5695: from pay_run_results rr3

5691: and rr2.assignment_action_id = act2.assignment_action_id
5692: and rr2.status <> 'U'
5693: and not exists (
5694: select null
5695: from pay_run_results rr3
5696: where rr3.source_id = pee.element_entry_id
5697: and rr3.status = 'U')
5698: order by pee.element_entry_id;
5699: --

Line 5709: insert into pay_run_results (

5705: hr_utility.set_location(c_indent, 10);
5706: end if;
5707: for c1rec in c1 loop
5708: -- Start with insertion of run result.
5709: insert into pay_run_results (
5710: run_result_id,
5711: element_type_id,
5712: assignment_action_id,
5713: entry_type,

Line 5718: values (pay_run_results_s.nextval,

5714: source_id,
5715: source_type,
5716: status,
5717: jurisdiction_code)
5718: values (pay_run_results_s.nextval,
5719: c1rec.element_type_id,
5720: c1rec.assignment_action_id,
5721: c1rec.entry_type,
5722: c1rec.element_entry_id,

Line 5735: pay_run_results_s.currval,

5731: input_value_id,
5732: run_result_id,
5733: result_value)
5734: select pev.input_value_id,
5735: pay_run_results_s.currval,
5736: null
5737: from pay_payroll_actions pac,
5738: pay_assignment_actions act, -- reversal
5739: pay_element_entry_values_f pev

Line 5942: from pay_run_results prr,

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

Line 6053: from pay_run_results

6049: select end_date,
6050: time_definition_id
6051: into l_ctx_balance_date,
6052: l_ctx_time_def_id
6053: from pay_run_results
6054: where run_result_id = p_rrid;
6055: --
6056: if l_ctx_balance_date is not null then
6057: get_cache_context('BALANCE_DATE', cxt_id);

Line 6148: update pay_run_results

6144: if l_ctx_value is not null then
6145: --
6146: -- Set the jurisdiction on the run_result.
6147: if (g_dynamic_contexts(l_cnt).context_name = 'JURISDICTION_CODE') then
6148: update pay_run_results
6149: set jurisdiction_code = l_ctx_value
6150: where run_result_id = p_rrid;
6151: --
6152: elsif (g_dynamic_contexts(l_cnt).context_name = 'ORGANIZATION_ID') then

Line 6238: from pay_run_results

6234: l_local_unit_id number;
6235: begin
6236: select local_unit_id
6237: into l_local_unit_id
6238: from pay_run_results
6239: where run_result_id = p_rrid;
6240: --
6241: if l_local_unit_id is not null then
6242: if g_debug then

Line 6436: -- pay_run_results.

6432: -- and element type is date effective. In the case of
6433: -- the assignment, this should be confirming what has
6434: -- already been checked by the form.
6435: -- In addition, select a sequence value for
6436: -- pay_run_results.
6437: --
6438: -- Bug #3482270 - original entry id support.
6439: -- Original_entry_id will be also derived from the entry
6440: -- record here, which must have already been validated and

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

6626:
6627: --
6628: if(sql%notfound) then
6629: if g_debug then
6630: hr_utility.trace('Update of pay_run_results has failed');
6631: end if;
6632: raise no_data_found;
6633: end if;
6634: --

Line 8208: from pay_run_results rr

8204: --
8205: -- Derive element type id from the run result.
8206: --
8207: select rr.element_type_id into l_element_type_id
8208: from pay_run_results rr
8209: where rr.run_result_id = rrid;
8210:
8211: del_latest_balances(asgid, effdate, eentryid, l_element_type_id);
8212: return;