APPS.HRASSACT dependencies on PAY_RUN_RESULTS_S

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 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 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 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