DBA Data[Home] [Help]

APPS.PAY_NZ_EMS dependencies on PAY_INPUT_VALUES_F

Line 43: ** Removed usages of tables 'pay_input_values_f iv2' , 'pay_run_results prr2',

39: ** 12-Apr-2007 dduvvuri 5846247 Modified header and detail cursors for KiwiSaver Requirement
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

Line 48: ** 10-NOv-2007 dduvvuri 7480679 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.
52: ** 07-JAN-2010 dduvvuri 9237657 Made Changes in ems header and detail cursors due to

Line 219: , pay_input_values_f iv

215: , per_assignments_f a
216: , hr_soft_coding_keyflex scl
217: , pay_nz_asg_cal_mth_bal_v b
218: , pay_element_types_f et
219: , pay_input_values_f iv
220: , pay_input_values_f iv1
221: -- , pay_input_values_f iv2 /* 7480679 */
222: , pay_run_results prr
223: , pay_run_results prr1

Line 220: , pay_input_values_f iv1

216: , hr_soft_coding_keyflex scl
217: , pay_nz_asg_cal_mth_bal_v b
218: , pay_element_types_f et
219: , pay_input_values_f iv
220: , pay_input_values_f iv1
221: -- , pay_input_values_f iv2 /* 7480679 */
222: , pay_run_results prr
223: , pay_run_results prr1
224: -- , pay_run_results prr2 /* 7480679 */

Line 221: -- , pay_input_values_f iv2 /* 7480679 */

217: , pay_nz_asg_cal_mth_bal_v b
218: , pay_element_types_f et
219: , pay_input_values_f iv
220: , pay_input_values_f iv1
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