[Home] [Help]
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
47: *** 8-Jan-06 ksingla 115.35 Bug#5743196 Added nvl to cursor c_allowance_balance
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
2491: ,pay_element_classifications pec
2492: ,pay_assignment_actions paa
2493: ,pay_payroll_actions ppa
2494: ,per_assignments_f paaf
2578: )
2579: group by element_name,label,rate;
2580:
2581: /* bug 7571001 - Added the new cursor for Allowance classification */
2582: /* Bug 8760756 - Added join between pay_run_result_values and pay_input_values_f tables and
2583: a condition to fetch amount value only if the element input value is of 'Pay Value'.
2584: Removed references to hours and rate columns from the cursor ,as they are not displayed anywhere in EOY reports. */
2585: /* bug 12615137 - Added ORDERED hint and re-arranged FROM clause */
2586: cursor c_ps_alw_details
2602: ,pay_assignment_actions pac
2603: ,pay_payroll_actions ppa
2604: ,pay_run_results prr
2605: ,pay_element_types_f pet
2606: ,pay_input_values_f piv
2607: ,pay_run_result_values prrv
2608: ,pay_balance_feeds_f pbf
2609: ,pay_defined_balances pdb
2610: ,pay_balance_dimensions pbd