[Home] [Help]
38: *** 27-FEB-06 ksingla 1.26 5063359 Modified cursor c_ps_element_details for Employer Charges.
39: *** 27-MAR-06 avenkatk 1.27 5119734 Modified cursor c_ps_element_details for reporting Allowances.
40: *** 20-Jun-06 ksingla 1.28 5333143 Add_months included to fetch FBT_RATE and MEDICARE_LEVY
41: *** 29-Oct-06 hnainani 1.29 5603254 Added Function get_element_payment_hours to fetch hours in c_element_details.
42: ***29 OCT 06 hnainani 1.30 5603524 Removed function get_element_payment_hours - used function defined in pay_au_Rec_det_archive instead
43: *** 16-Nov-06 abhargav 115.31 5603254 Modified cursor c_ps_element_details to remove join for table pay_input_values_f piv2 and pay_run_result_values prrv2.
44: *** 19-Dec-06 ksingla 115.32 5708255 Added code to get value of global FBT_THRESHOLD
45: *** 22-Dec-06 ksingla 115.33 5708255 Changed 1000 to g_fbt_threshold in cursor csr_assignment_only_paysum
46: *** 27-Dec-06 ksingla 115.34 5708255 Added to_number to all occurrences of g_fbt_threshold
2447: --------------------------------------------------------------------+
2448: /* Bug 4179109 - Check for Non Taxable Allowances included */
2449: /* Bug 5063359 - Modified decode for Employer Charges to return classification as Employer Charges rather than Employer Superannuation Contribution */
2450: /* Bug 5119734 - Modified decode to check for Allowances if classifcation is Earnings */
2451: /*Bug 5603254 - Removed tables piv2 and prrv2 and their joins from cursor , added a call to function pay_au_rec_det_archive.get_element_payment_hours to get the value for hours and rate */
2452: /*Bug 5846278 - Added Lump Sum E Payments in Not exists Clause */
2453: /* bug 7571001 - Removed Allowance classification from the existing cursor */
2454: /*bug 9190980 - Added Retro Earnings Leave Loading GT 12 Mths Amount, Retro Earnings Spread GT 12 Mths Amount for Lump Sum E in Not Exist clause
2455: Retro Pre Tax GT 12 Mths Amount is commented out because it is to be reported in Pre Tax Deductions section*/
2479: , 'Foreign Tax Deductions' , 'Tax Deductions'
2480: , pec.classification_name )) ||
2481: decode(instr(pec.classification_name, 'Employer Charges'), 0,null,'Employer Charges') label,
2482: decode(pec.classification_name,'Foreign Tax Deductions',(-1 * NVL(prrv1.result_value,0)), prrv1.result_value) amount,
2483: pay_au_rec_det_archive.get_element_payment_hours(prr.assignment_action_id,pet.element_type_id,prr.run_result_id,ppa.effective_date) hours, /*Bug 5603254 */
2484: decode(pay_au_rec_det_archive.get_element_payment_rate(prr.assignment_action_id,pet.element_type_id,prr.run_result_id,ppa.effective_date), null,
2485: (prrv1.result_value/pay_au_rec_det_archive.get_element_payment_hours(prr.assignment_action_id,pet.element_type_id,prr.run_result_id, ppa.effective_date)),
2486: pay_au_rec_det_archive.get_element_payment_rate(prr.assignment_action_id,pet.element_type_id,prr.run_result_id,ppa.effective_date)) rate, /* 5599310 */
2487: prr.run_result_id,
2480: , pec.classification_name )) ||
2481: decode(instr(pec.classification_name, 'Employer Charges'), 0,null,'Employer Charges') label,
2482: decode(pec.classification_name,'Foreign Tax Deductions',(-1 * NVL(prrv1.result_value,0)), prrv1.result_value) amount,
2483: pay_au_rec_det_archive.get_element_payment_hours(prr.assignment_action_id,pet.element_type_id,prr.run_result_id,ppa.effective_date) hours, /*Bug 5603254 */
2484: decode(pay_au_rec_det_archive.get_element_payment_rate(prr.assignment_action_id,pet.element_type_id,prr.run_result_id,ppa.effective_date), null,
2485: (prrv1.result_value/pay_au_rec_det_archive.get_element_payment_hours(prr.assignment_action_id,pet.element_type_id,prr.run_result_id, ppa.effective_date)),
2486: pay_au_rec_det_archive.get_element_payment_rate(prr.assignment_action_id,pet.element_type_id,prr.run_result_id,ppa.effective_date)) rate, /* 5599310 */
2487: prr.run_result_id,
2488: paa.source_action_id
2481: decode(instr(pec.classification_name, 'Employer Charges'), 0,null,'Employer Charges') label,
2482: decode(pec.classification_name,'Foreign Tax Deductions',(-1 * NVL(prrv1.result_value,0)), prrv1.result_value) amount,
2483: pay_au_rec_det_archive.get_element_payment_hours(prr.assignment_action_id,pet.element_type_id,prr.run_result_id,ppa.effective_date) hours, /*Bug 5603254 */
2484: decode(pay_au_rec_det_archive.get_element_payment_rate(prr.assignment_action_id,pet.element_type_id,prr.run_result_id,ppa.effective_date), null,
2485: (prrv1.result_value/pay_au_rec_det_archive.get_element_payment_hours(prr.assignment_action_id,pet.element_type_id,prr.run_result_id, ppa.effective_date)),
2486: pay_au_rec_det_archive.get_element_payment_rate(prr.assignment_action_id,pet.element_type_id,prr.run_result_id,ppa.effective_date)) rate, /* 5599310 */
2487: prr.run_result_id,
2488: paa.source_action_id
2489: from pay_element_types_f pet
2482: decode(pec.classification_name,'Foreign Tax Deductions',(-1 * NVL(prrv1.result_value,0)), prrv1.result_value) amount,
2483: pay_au_rec_det_archive.get_element_payment_hours(prr.assignment_action_id,pet.element_type_id,prr.run_result_id,ppa.effective_date) hours, /*Bug 5603254 */
2484: decode(pay_au_rec_det_archive.get_element_payment_rate(prr.assignment_action_id,pet.element_type_id,prr.run_result_id,ppa.effective_date), null,
2485: (prrv1.result_value/pay_au_rec_det_archive.get_element_payment_hours(prr.assignment_action_id,pet.element_type_id,prr.run_result_id, ppa.effective_date)),
2486: pay_au_rec_det_archive.get_element_payment_rate(prr.assignment_action_id,pet.element_type_id,prr.run_result_id,ppa.effective_date)) rate, /* 5599310 */
2487: prr.run_result_id,
2488: paa.source_action_id
2489: from pay_element_types_f pet
2490: ,pay_input_values_f piv1