[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
2492: ,pay_assignment_actions paa
2493: ,pay_payroll_actions ppa
2494: ,per_assignments_f paaf
2495: ,pay_run_results prr
2496: ,pay_run_result_values prrv1
2497: ,pay_element_classifications pec2
2498: ,pay_sub_classification_rules_f pscr
2499: where paaf.assignment_id = c_assignment_id
2500: and paaf.business_group_id = c_business_group_id
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
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
2611: , pay_balance_attributes pba