[Home] [Help]
11: sequenced_flag boolean,
12: action_date date,
13: action_start_date date,
14: current_date date, -- holds sysdate.
15: payroll_name pay_all_payrolls_f.payroll_name%type,
16: bg_name hr_organization_units.name%type,
17: bg_id hr_organization_units.business_group_id%type,
18: independent_periods_flag pay_legislation_rules.rule_mode%type,
19: date_earned date,
26: assact_id pay_assignment_actions.assignment_action_id%type,
27: assignment_id per_all_assignments_f.assignment_id%type,
28: full_name per_all_people_f.full_name%type,
29: assignment_number per_all_assignments_f.assignment_number%type,
30: payroll_id pay_all_payrolls_f.payroll_id%type,
31: --
32: -- Other information.
33: legislation_code varchar2(2),
34: rollback_mode varchar2(20), -- 'ROLLBACK', 'RETRY', 'BACKPAY'.
1100: p_info.retro_definition_id,
1101: p_info.batch_id,
1102: p_info.sub_ledger_acc
1103: from pay_payroll_actions pac,
1104: pay_all_payrolls_f pay,
1105: per_business_groups_perf grp,
1106: hr_lookups hrl
1107: where pac.payroll_action_id = p_info.pact_id
1108: and hrl.lookup_code = pac.action_type