[Home] [Help]
205: 13-NOV-2003 nbristow 115.85 Reversal was not correctly
206: setting the jurisdiction code
207: in sparse mode.
208: 04-NOV-2003 alogue 115.84 3176709 Use of per_business_groups_perf,
209: per_all_people_f and
210: pay_all_payrolls_f. Performance
211: fix to seqper cursors.
212: 03-NOV-2003 tbattoo 115.83 support for sparse matrix and
213: pay_latest_balances table
649: --
650: type assact_details is record
651: (assact_id pay_assignment_actions.assignment_action_id%type,
652: assignment_id pay_assignment_actions.assignment_id%type,
653: full_name per_all_people_f.full_name%type,
654: assignment_number per_all_assignments_f.assignment_number%type,
655: payroll_id per_all_assignments_f.payroll_id%type);
656: --
657: type pact_details is record
894: return boolean is
895: --
896: l_action_sequence pay_assignment_actions.action_sequence%type;
897: l_action_status pay_assignment_actions.action_status%type;
898: l_person_id per_all_people_f.person_id%type;
899: begin
900: --
901: g_debug := hr_utility.debug_enabled;
902: -- Obtain information about this assignment action which we will
920: p_assact_rec.full_name,
921: p_assact_rec.assignment_number
922: from per_periods_of_service POS,
923: per_all_assignments_f ASS,
924: per_all_people_f PEO,
925: pay_assignment_actions ACT
926: where ACT.assignment_action_id = p_assact_rec.assact_id
927: and ASS.assignment_id = ACT.assignment_id
928: and p_pact_rec.action_date between