DBA Data[Home] [Help]

APPS.HRASSACT dependencies on PAY_RUN_RESULTS_S

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