[Home] [Help]
27: ** Tax Code along with Tax Code. Also the function
28: ** changed to check for date conditions
29: ** 10 JAN 2002 SRRAJAGO 2177800 Included Action_type 'C' for Costing process
30: ** 10 OCT 2002 PUCHIL 2595888 Changed the type of variable l_action_type
31: ** from varchar2(1) to pay_payroll_actions.action_type%type
32: ** 19 NOV 2002 SRRAJAGO 2636739 Removed the action_type 'C' only from cursor asg_latest_pay of the procedure get_asg_latest_pay
33: ** 03 DEC 2002 SRRAJAGO 2689221 Included 'nocopy' option for the 'out' and 'in out' parameters of all the procedures.
34: ** 17 NOV 2003 PUCHIL 3257888 Added language check to cursors c_get_work_address and c_get_home_address.
35: ** 08 APR 2004 PUCHIL 3453503 Added logic to support Advanced Retropay.
55: , pay_run_result_values rrv
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
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
520: where paa.payroll_action_id = ppa.payroll_action_id
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 =
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
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: ;
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
599: and pact.payroll_action_id = assact.payroll_action_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
618: and pact.time_period_id = ptp.time_period_id ;
616: where assact.assignment_action_id = p_run_assignment_action_id
617: and pact.payroll_action_id = assact.payroll_action_id
618: and pact.time_period_id = ptp.time_period_id ;
619: --
620: -- Bug 2595888: changed the datatype from varchar2(1) to pay_payroll_actions.action_type%type
621: l_action_type pay_payroll_actions.action_type%type;
622: --
623: begin
624: --
617: and pact.payroll_action_id = assact.payroll_action_id
618: and pact.time_period_id = ptp.time_period_id ;
619: --
620: -- Bug 2595888: changed the datatype from varchar2(1) to pay_payroll_actions.action_type%type
621: l_action_type pay_payroll_actions.action_type%type;
622: --
623: begin
624: --
625: open get_action_type;