APPS.PAY_NZ_EMS dependencies on PAY_NZ_EMS_TAX_RATE

Line 47: ** from a function in package pay_nz_ems_tax_rate

43: ** Removed usages of tables 'pay_input_values_f iv2' , 'pay_run_results prr2',
44: ** 'pay_run_result_values prrv2' from the query
45: ** 07-Nov-2007 dduvvuri 7480679 Backed out the above change and implemented it in a different way.
46: ** Modified the c_detail cursor to get the value of 'Tax Rate' input field
47: ** from a function in package pay_nz_ems_tax_rate
48: ** 10-NOv-2007 dduvvuri 7480679 Removed usages of tables 'pay_input_values_f iv2' , 'pay_run_results prr2',
49: ** 'pay_run_result_values prrv2' from the query.Also removed the usage of
50: ** "distinct" keyword in c_detail query. The parameters to the function call
51: ** in package pay_nz_ems_tax_rate are also changed.

Line 51: ** in package pay_nz_ems_tax_rate are also changed.

47: ** from a function in package pay_nz_ems_tax_rate
48: ** 10-NOv-2007 dduvvuri 7480679 Removed usages of tables 'pay_input_values_f iv2' , 'pay_run_results prr2',
49: ** 'pay_run_result_values prrv2' from the query.Also removed the usage of
50: ** "distinct" keyword in c_detail query. The parameters to the function call
51: ** in package pay_nz_ems_tax_rate are also changed.
52: ** 07-JAN-2010 dduvvuri 9237657 Made Changes in ems header and detail cursors due to
53: ** introduction of statutory changes effective 01-Apr-2010
54: ** 03-Feb-2010 dduvvuri 9237657 Multiply the values of payroll tax credits by -1 in header , detail cursors
55: ** because balance value of tax credits is negative and EMS must report positive value

Line 158: -- 7480679 - made use of package pay_nz_ems_tax_rate to get the tax rate input value.

154: -- The NULL value was not recognised by the fast formula using the
155: -- default for ...
156: -- if ... was defaulted ...
157: -- therefore the string NULL VALUE is passed
158: -- 7480679 - made use of package pay_nz_ems_tax_rate to get the tax rate input value.
159: , nvl(decode(prrv1.result_value,'N',prrv.result_value,'Y', (decode(pay_nz_ems_tax_rate.get_tax_rate(s.effective_date,prr.run_result_id),'N',
160: prrv.result_value,'STC'))),'NULL VALUE') -- employee_tax_code
161: , 'START_DATE=P'
162: , decode(to_char(ptp.END_DATE ,'YYYYMM')

Line 159: , nvl(decode(prrv1.result_value,'N',prrv.result_value,'Y', (decode(pay_nz_ems_tax_rate.get_tax_rate(s.effective_date,prr.run_result_id),'N',

155: -- default for ...
156: -- if ... was defaulted ...
157: -- therefore the string NULL VALUE is passed
158: -- 7480679 - made use of package pay_nz_ems_tax_rate to get the tax rate input value.
159: , nvl(decode(prrv1.result_value,'N',prrv.result_value,'Y', (decode(pay_nz_ems_tax_rate.get_tax_rate(s.effective_date,prr.run_result_id),'N',
160: prrv.result_value,'STC'))),'NULL VALUE') -- employee_tax_code
161: , 'START_DATE=P'
162: , decode(to_char(ptp.END_DATE ,'YYYYMM')
163: ,to_char(s.effective_date,'YYYYMM')