[Home] [Help]
173: 13-NOV-2003 nbristow 115.85 Reversal was not correctly
174: setting the jurisdiction code
175: in sparse mode.
176: 04-NOV-2003 alogue 115.84 3176709 Use of per_business_groups_perf,
177: per_all_people_f and
178: pay_all_payrolls_f. Performance
179: fix to seqper cursors.
180: 03-NOV-2003 tbattoo 115.83 support for sparse matrix and
181: pay_latest_balances table
617: --
618: type assact_details is record
619: (assact_id pay_assignment_actions.assignment_action_id%type,
620: assignment_id pay_assignment_actions.assignment_id%type,
621: full_name per_all_people_f.full_name%type,
622: assignment_number per_all_assignments_f.assignment_number%type,
623: payroll_id per_all_assignments_f.payroll_id%type);
624: --
625: type pact_details is record
862: return boolean is
863: --
864: l_action_sequence pay_assignment_actions.action_sequence%type;
865: l_action_status pay_assignment_actions.action_status%type;
866: l_person_id per_all_people_f.person_id%type;
867: begin
868: --
869: g_debug := hr_utility.debug_enabled;
870: -- Obtain information about this assignment action which we will
888: p_assact_rec.full_name,
889: p_assact_rec.assignment_number
890: from per_periods_of_service POS,
891: per_all_assignments_f ASS,
892: per_all_people_f PEO,
893: pay_assignment_actions ACT
894: where ACT.assignment_action_id = p_assact_rec.assact_id
895: and ASS.assignment_id = ACT.assignment_id
896: and p_pact_rec.action_date between