[Home] [Help]
56: , pay_run_results rr
57: , pay_input_values_f iv1
58: , pay_run_result_values rrv1
59: , pay_payroll_actions ppa
60: , pay_assignment_actions paa
61: where et.element_name = 'PAYE Information'
62: and et.legislation_code = 'NZ'
63: and iv.element_type_id = et.element_type_id
64: and iv.name = 'Tax Code'
290: -- rather than 6 separate calls.
291: ------------------------------------------------------------------------
292: procedure balance_totals
293: (p_assignment_id in per_all_assignments_f.assignment_id%type,
294: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
295: p_effective_date in date,
296: p_gross_this_pay out nocopy number,
297: p_other_deductions_this_pay out nocopy number,
298: p_tax_deductions_this_pay out nocopy number,
449: -- Sums the Balances for This Pay and YTD, according to the parameters.
450: ------------------------------------------------------------------------
451: procedure run_and_ytd_balances
452: (p_assignment_id in per_all_assignments_f.assignment_id%type,
453: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
454: p_effective_date in date,
455: p_balance_name in pay_balance_types.balance_name%type,
456: p_run_balance out nocopy number,
457: p_ytd_balance out nocopy number)
457: p_ytd_balance out nocopy number)
458: is
459:
460: cursor run_and_ytd_value
461: (c_assignment_id pay_assignment_actions.assignment_id%type,
462: c_assignment_action_id pay_assignment_actions.assignment_action_id%type,
463: c_effective_date date,
464: c_balance_name pay_balance_types.balance_name%type) is
465: select nvl(hr_nzbal.calc_asg_run(c_assignment_action_id,
458: is
459:
460: cursor run_and_ytd_value
461: (c_assignment_id pay_assignment_actions.assignment_id%type,
462: c_assignment_action_id pay_assignment_actions.assignment_action_id%type,
463: c_effective_date date,
464: c_balance_name pay_balance_types.balance_name%type) is
465: select nvl(hr_nzbal.calc_asg_run(c_assignment_action_id,
466: balance_type_id,
511: ptp.period_name,
512: rppa.payroll_id,
513: nvl(rppa.pay_advice_date,ptp.pay_advice_date),
514: rppa.pay_advice_message
515: from pay_assignment_actions paa,
516: pay_payroll_actions ppa,
517: pay_assignment_actions rpaa,
518: per_time_periods ptp,
519: pay_payroll_actions rppa
513: nvl(rppa.pay_advice_date,ptp.pay_advice_date),
514: rppa.pay_advice_message
515: from pay_assignment_actions paa,
516: pay_payroll_actions ppa,
517: pay_assignment_actions rpaa,
518: per_time_periods ptp,
519: pay_payroll_actions rppa
520: where paa.payroll_action_id = ppa.payroll_action_id
521: and rppa.payroll_action_id = rpaa.payroll_action_id
522: and rppa.time_period_id = ptp.time_period_id
523: and paa.assignment_action_id =
524: (select to_number(substr(max(to_char(pa.effective_date,'J')||lpad(aa.assignment_action_id,15,'0')),8))
525: from pay_payroll_actions pa,
526: pay_assignment_actions aa
527: where pa.action_type in ('U','P')
528: and aa.action_status = 'C'
529: and pa.payroll_action_id = aa.payroll_action_id
530: and aa.assignment_id = p_assignment_id
532: and ppa.action_type in ('P', 'U')
533: and rpaa.assignment_id = p_assignment_id
534: and rpaa.action_sequence =
535: (select max(aa.action_sequence)
536: from pay_assignment_actions aa,
537: pay_action_interlocks loc
538: where loc.locked_action_id = aa.assignment_action_id
539: and loc.locking_action_id = paa.assignment_action_id);
540: begin
572:
573: cursor get_action_type is
574: -- find type of action this is
575: select pact.action_type , assact.assignment_id
576: from pay_assignment_actions assact,
577: pay_payroll_actions pact
578: where assact.assignment_action_id = p_assignment_action_id
579: and pact.payroll_action_id =
580: assact.payroll_action_id
581: ;
582: cursor get_run is
583: -- for prepayment action find the latest interlocked run
584: select assact.assignment_action_id
585: from pay_assignment_actions assact,
586: pay_action_interlocks loc
587: where loc.locking_action_id = p_assignment_action_id
588: and assact.assignment_action_id = loc.locked_action_id
589: order by assact.action_sequence desc ;
590:
591: cursor get_prepay is
592: -- for run action check if its been prepaid
593: select assact.assignment_action_id
594: from pay_assignment_actions assact,
595: pay_payroll_actions pact,
596: pay_action_interlocks loc
597: where loc.locked_action_id = p_assignment_action_id
598: and assact.assignment_action_id = loc.locking_action_id
609: pact.time_period_id,
610: ptp.period_name,
611: nvl(pact.pay_advice_date,ptp.pay_advice_date),
612: pay_advice_message
613: from pay_assignment_actions assact,
614: pay_payroll_actions pact,
615: per_time_periods ptp
616: where assact.assignment_action_id = p_run_assignment_action_id
617: and pact.payroll_action_id = assact.payroll_action_id
655: end get_details;
656:
657: procedure final_balance_totals
658: (p_assignment_id in per_all_assignments_f.assignment_id%type,
659: p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
660: p_effective_date in date,
661: p_gross_this_pay out nocopy number,
662: p_other_deductions_this_pay out nocopy number,
663: p_tax_deductions_this_pay out nocopy number,