DBA Data[Home] [Help]

APPS.PAY_NZ_EMS dependencies on PAY_RUN_RESULT_VALUES

Line 44: ** 'pay_run_result_values prrv2' from the query

40: ** 24-Apr-2007 dduvvuri 5846247 Modified spellings for certain Formula parameters req by KiwiSaver
41: ** 06-Nov-2008 dduvvuri 7480679 Modified c_detail cursor
42: ** 07-Nov-2008 dduvvuri 7480679 Modified c_detail cursor after review comments.
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',

Line 49: ** 'pay_run_result_values prrv2' from the query.Also removed the usage of

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.
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

Line 225: , pay_run_result_values prrv

221: -- , pay_input_values_f iv2 /* 7480679 */
222: , pay_run_results prr
223: , pay_run_results prr1
224: -- , pay_run_results prr2 /* 7480679 */
225: , pay_run_result_values prrv
226: , pay_run_result_values prrv1
227: -- , pay_run_result_values prrv2 /* 7480679 */
228: , pay_assignment_actions assact
229: , pay_payroll_actions pact

Line 226: , pay_run_result_values prrv1

222: , pay_run_results prr
223: , pay_run_results prr1
224: -- , pay_run_results prr2 /* 7480679 */
225: , pay_run_result_values prrv
226: , pay_run_result_values prrv1
227: -- , pay_run_result_values prrv2 /* 7480679 */
228: , pay_assignment_actions assact
229: , pay_payroll_actions pact
230: , fnd_sessions s

Line 227: -- , pay_run_result_values prrv2 /* 7480679 */

223: , pay_run_results prr1
224: -- , pay_run_results prr2 /* 7480679 */
225: , pay_run_result_values prrv
226: , pay_run_result_values prrv1
227: -- , pay_run_result_values prrv2 /* 7480679 */
228: , pay_assignment_actions assact
229: , pay_payroll_actions pact
230: , fnd_sessions s
231: , per_periods_of_service pos