[Home] [Help]
100: ** 21-feb-2005 aashokan 115.36 Bug 4193738 - Modified cursor csr_prepaid_assignments to fetch only those
101: ** records for which pre payment is run between a given period.
102: ** 28-feb-2005 aashokan 115.37 Bug 4208273 - Modified subquery of cursor csr_prepaid_assignments
103: ** 28-feb-2005 aashokan 115.38 Added act2.action_status='C' in subquery of cursor csr_prepaid_assignments
104: ** 28-APR-2005 rrajaman 115.39 Removed pay_element_types_f join from cursor cur_non_cum_tax
105: ** for performance bug 4315023
106: ** 24-MAY-2005 sgajula 115.40 Changed to refer new Information type IE_EMPLOYER_INFO to accomodate changes
107: ** for Employer Migration
108: ** 16-JUN-2005 alikhar 115.41 Bug 4437249: Changed the cursor csr_get_arc_bal_value to get the balance
695: p_value_name CHAR) IS
696: SELECT pet.element_type_id,
697: piv.input_value_id
698: FROM pay_input_values_f piv,
699: pay_element_types_f pet
700: WHERE piv.element_type_id = pet.element_type_id
701: AND pet.legislation_code = 'IE'
702: AND pet.element_name = p_element_name
703: AND piv.name = p_value_name;
2888: /* cursor cur_cal_option is
2889: select calculation_option
2890: from pay_ie_social_benefits_f psb
2891: where psb.assignment_id = p_assignment_id; */
2892: -- Bug 4315023 Removed Pay_element_types_f join for performance
2893: cursor cur_non_cum_tax is
2894: select result_value
2895: from pay_run_result_values prr,
2896: pay_run_results pr,
3223: p_value_name CHAR) IS
3224: SELECT pet.element_type_id,
3225: piv.input_value_id
3226: FROM pay_input_values_f piv,
3227: pay_element_types_f pet
3228: WHERE piv.element_type_id = pet.element_type_id
3229: AND pet.legislation_code = 'IE'
3230: AND pet.element_name = p_element_name
3231: AND piv.name = p_value_name;