[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
506: p_value_name CHAR) IS
507: SELECT pet.element_type_id,
508: piv.input_value_id
509: FROM pay_input_values_f piv,
510: pay_element_types_f pet
511: WHERE piv.element_type_id = pet.element_type_id
512: AND pet.legislation_code = 'IE'
513: AND pet.element_name = p_element_name
514: AND piv.name = p_value_name;
2221: /* cursor cur_cal_option is
2222: select calculation_option
2223: from pay_ie_social_benefits_f psb
2224: where psb.assignment_id = p_assignment_id; */
2225: -- Bug 4315023 Removed Pay_element_types_f join for performance
2226: cursor cur_non_cum_tax is
2227: select result_value
2228: from pay_run_result_values prr,
2229: pay_run_results pr,
2517: p_value_name CHAR) IS
2518: SELECT pet.element_type_id,
2519: piv.input_value_id
2520: FROM pay_input_values_f piv,
2521: pay_element_types_f pet
2522: WHERE piv.element_type_id = pet.element_type_id
2523: AND pet.legislation_code = 'IE'
2524: AND pet.element_name = p_element_name
2525: AND piv.name = p_value_name;