[Home] [Help]
95: p_end_person_id in per_all_people_f.person_id%type,
96: p_chunk in number )
97: is
98: l_proc_name varchar2(100) ;
99: l_next_action_id pay_assignment_actions.assignment_action_id%type;
100: --
101: cursor c_assact
102: is
103: select max(paa.assignment_id) assignment_id
101: cursor c_assact
102: is
103: select max(paa.assignment_id) assignment_id
104: from pay_payroll_actions rppa,
105: pay_assignment_actions rpac,
106: per_assignments_f paa
107: where paa.person_id between p_start_person_id
108: and p_end_person_id
109: and rppa.business_group_id = g_pact.business_group_id
120: group by paa.person_id;
121: --
122: cursor next_action_id
123: is
124: select pay_assignment_actions_s.nextval
125: from dual;
126: --
127: begin
128: l_proc_name := l_package || 'assignment_action_code';
212: ------------------------------------------------------------
213: -- Archive Code
214: ------------------------------------------------------------
215: procedure archive_code
216: ( p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
217: p_effective_date in date)
218: is
219:
220: l_proc_name varchar2(100) ;
227: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;
228: g_context_tab pay_balance_pkg.t_context_tab;
229: g_detailed_bal_out_tab pay_balance_pkg.t_detailed_bal_out_tab;
230: --
231: l_asg_act_id pay_assignment_actions.assignment_action_id%type;
232: l_person_id per_all_people_f.person_id%type;
233: l_cpf_tot_earn_cap_amt ff_globals_f.global_value%type;
234: l_aw_toward_cap number;
235: l_aw_cap_recalculated number;
241: is
242: select pac.assignment_id,
243: pps.person_id,
244: pps.final_process_date
245: from pay_assignment_actions pac,
246: per_assignments_f paa,
247: per_periods_of_service pps
248: where pac.assignment_action_id = p_assignment_action_id
249: and paa.assignment_id = pac.assignment_id
269: where people1.person_id = pap.person_id);
270: --
271: cursor month_year_action_sequence ( c_person_id per_all_people_f.person_id%type,
272: c_business_group_id hr_organization_units.business_group_id%type,
273: c_legal_entity_id pay_assignment_actions.tax_unit_id%type,
274: c_basis_year varchar2 )
275: is
276: select /*+ ORDERED USE_NL(pacmax) */
277: max(pacmax.action_sequence) act_seq,
276: select /*+ ORDERED USE_NL(pacmax) */
277: max(pacmax.action_sequence) act_seq,
278: to_char(ppamax.effective_date,'MM')
279: from per_assignments_f paamax,
280: pay_assignment_actions pacmax,
281: pay_payroll_actions ppamax
282: where ppamax.business_group_id = c_business_group_id
283: and pacmax.tax_unit_id = c_legal_entity_id
284: and paamax.person_id = c_person_id
291: order by to_char(ppamax.effective_date,'MM') desc;
292: --
293: cursor month_year_action ( c_person_id per_all_people_f.person_id%type,
294: c_business_group_id hr_organization_units.business_group_id%type,
295: c_legal_entity_id pay_assignment_actions.tax_unit_id%type,
296: c_basis_year varchar2,
297: c_action_sequence pay_assignment_actions.action_sequence%type )
298: is
299: select /*+ ORDERED USE_NL(pac) */
293: cursor month_year_action ( c_person_id per_all_people_f.person_id%type,
294: c_business_group_id hr_organization_units.business_group_id%type,
295: c_legal_entity_id pay_assignment_actions.tax_unit_id%type,
296: c_basis_year varchar2,
297: c_action_sequence pay_assignment_actions.action_sequence%type )
298: is
299: select /*+ ORDERED USE_NL(pac) */
300: pac.assignment_action_id assact_id,
301: decode(ppa.action_type,'V',ppa.effective_date,ppa.date_earned) date_earned,
300: pac.assignment_action_id assact_id,
301: decode(ppa.action_type,'V',ppa.effective_date,ppa.date_earned) date_earned,
302: pac.tax_unit_id tax_uid
303: from per_assignments_f paa,
304: pay_assignment_actions pac,
305: pay_payroll_actions ppa
306: where ppa.business_group_id = c_business_group_id
307: and pac.tax_unit_id = c_legal_entity_id
308: and paa.person_id = c_person_id
573: select /*+ ORDERED USE_NL(paa) */
574: max(paa.action_sequence),
575: to_number(to_char(ppa.effective_date,'MM'))
576: from per_assignments_f paaf,
577: pay_assignment_actions paa,
578: pay_payroll_actions ppa
579: where paaf.person_id = p_person_id
580: and paa.assignment_id = paaf.assignment_id
581: and ppa.payroll_action_id = paa.payroll_action_id
591: select /*+ ORDERED USE_NL(paa) */
592: paa.assignment_action_id,
593: ppa.effective_date
594: from per_assignments_f paaf,
595: pay_assignment_actions paa,
596: pay_payroll_actions ppa
597: where paaf.person_id = p_person_id
598: and paa.assignment_id = paaf.assignment_id
599: and ppa.payroll_action_id = paa.payroll_action_id
625: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;
626: g_context_tab pay_balance_pkg.t_context_tab;
627: g_detailed_bal_out_tab pay_balance_pkg.t_detailed_bal_out_tab;
628: --
629: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
630: l_action_sequence pay_assignment_actions.action_sequence%TYPE;
631: l_month number;
632: l_effective_date date;
633: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;
626: g_context_tab pay_balance_pkg.t_context_tab;
627: g_detailed_bal_out_tab pay_balance_pkg.t_detailed_bal_out_tab;
628: --
629: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
630: l_action_sequence pay_assignment_actions.action_sequence%TYPE;
631: l_month number;
632: l_effective_date date;
633: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;
634: l_defined_bal_id number;
629: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
630: l_action_sequence pay_assignment_actions.action_sequence%TYPE;
631: l_month number;
632: l_effective_date date;
633: l_tax_unit_id pay_assignment_actions.tax_unit_id%TYPE;
634: l_defined_bal_id number;
635: l_cur_ord_ytd number;
636: l_ord_mon_cap_amt number;
637: l_ord_mon_cap_amt_date date;