[Home] [Help]
215:
216: cursor c_ele_id
217: is
218: select pee.element_entry_id,pee.effective_end_date
219: from pay_element_types_f pet
220: ,pay_input_values_f piv
221: ,pay_element_entries_f pee
222: ,pay_element_entry_values_f pev
223: ,pay_assignment_actions pac
235:
236: cursor c_ele_id_latest
237: is
238: select pee.element_entry_id,pee.effective_end_date
239: from pay_element_types_f pet
240: ,pay_input_values_f piv
241: ,pay_element_entries_f pee
242: ,pay_element_entry_values_f pev
243: ,pay_assignment_actions pac
1405: Select element_information1,
1406: element_information2,
1407: element_information3,
1408: element_information4
1409: From pay_element_types_f
1410: Where element_type_id = p_element_type_id
1411: and p_date_earned between effective_start_date and effective_end_date;
1412:
1413: l_procedure VARCHAR2(250);
1695: l_payroll_id IN NUMBER)
1696: IS
1697: SELECT pel.element_link_id
1698: FROM pay_element_links_f pel,
1699: pay_element_types_f pet
1700: WHERE pet.element_name = p_element_name
1701: AND pet.element_type_id = pel.element_type_id
1702: AND (pel.payroll_id = l_payroll_id
1703: OR (pel.payroll_id IS NULL
1919: RETURN NUMBER IS
1920: CURSOR c_get_perk_details IS
1921: SELECT element_information1
1922: ,NVL(element_information6,'Y')
1923: FROM pay_element_types_f
1924: WHERE element_type_id = p_element_type_id
1925: AND p_date_earned BETWEEN effective_start_date AND effective_end_date;
1926:
1927: CURSOR c_exemption (p_perk_name IN VARCHAR2) IS
1928: SELECT fnd_number.canonical_to_number(exemption_amount)
1929: FROM pay_in_other_perquisites_v
1930: WHERE perquisite_name = p_perk_name;
1931:
1932: l_perk_name pay_element_types_f.element_information1%TYPE;
1933: l_procedure VARCHAR2(100);
1934: l_message VARCHAR2(255);
1935:
1936: BEGIN
2007: l_eff_date_tbl t_eff_date;
2008: l_hra number;
2009: l_curr_period_num number;
2010: l_80gg_flag VARCHAR2(3);
2011: l_element_name pay_element_types_f.element_name %TYPE;
2012: l_input_name pay_input_values_f.name%TYPE;
2013:
2014: CURSOR c_claim_80gg_flag(c_assignment_action_id NUMBER
2015: ,c_element_name IN VARCHAR2
2017: SELECT prv.result_value
2018: FROM pay_run_result_values prv,
2019: pay_run_results prr,
2020: pay_input_values_f piv,
2021: pay_element_types_f pet
2022: WHERE prv.run_result_id = prr.run_result_id
2023: AND prr.assignment_action_id = c_assignment_action_id
2024: AND prr.element_type_id = pet.element_type_id
2025: AND pet.element_name = c_element_name
2205: FROM pay_assignment_actions aa,
2206: pay_payroll_actions pa,
2207: pay_element_entries_f ee,
2208: pay_element_links_f el,
2209: pay_element_types_f et,
2210: pay_element_entry_values_f peev
2211: WHERE aa.payroll_action_id = pa.payroll_action_id
2212: AND aa.assignment_id = ee.assignment_id
2213: and ee.element_entry_id = peev.element_entry_id
3570: AND cur_pay.effective_date between ptp.start_date and ptp.end_date
3571: AND ptp.payroll_id = cur_pay.payroll_id
3572: AND EXISTS (SELECT ''
3573: FROM pay_run_results prr,
3574: pay_element_types_f pet
3575: WHERE prr.assignment_action_id = prev_asg.assignment_action_id
3576: AND prr.element_type_id = pet.element_type_id
3577: AND pet.legislation_code ='IN'
3578: AND pet.element_name ='Form16 Income Tax Information')
3673: AND prt.run_type_id = ASSACT.run_type_id
3674: AND prt.run_type_name ='Regular Run'
3675: AND EXISTS ( SELECT '1' FROM
3676: pay_run_results prr,
3677: pay_element_types_f pet
3678: WHERE prr.assignment_action_id = ASSACT.assignment_action_id
3679: AND prr.element_type_id = pet.element_type_id
3680: AND pet.legislation_code ='IN'
3681: AND pet.element_name ='Form16 Income Information');