[Home] [Help]
623: payroll_id per_all_assignments_f.payroll_id%type);
624: --
625: type pact_details is record
626: (pact_id pay_payroll_actions.payroll_action_id%type,
627: action_name hr_lookups.meaning%type,
628: action_type pay_payroll_actions.action_type%type,
629: sequenced_flag boolean,
630: action_date date,
631: current_date date, -- this is sysdate.
1126: p_pact_rec.bg_name
1127: from pay_payroll_actions pac,
1128: pay_all_payrolls_f pay,
1129: per_business_groups_perf grp,
1130: hr_lookups hrl
1131: where pac.payroll_action_id = p_pact_rec.pact_id
1132: and hrl.lookup_code = pac.action_type
1133: and hrl.lookup_type = 'ACTION_TYPE'
1134: and grp.business_group_id = pac.business_group_id