[Home] [Help]
1776: END IF;
1777:
1778: select people.per_information7
1779: into l_res_status
1780: from per_all_people_f people,
1781: per_all_assignments_f paa
1782: where people.person_id = paa.person_id
1783: and paa.assignment_id= p_assignment_id
1784: and p_effective_date between paa.effective_start_date and paa.effective_end_date
1941: Return number is
1942:
1943: Cursor c_dob is
1944: select pap.date_of_birth
1945: from per_all_people_f pap,
1946: per_all_assignments_f paa
1947: where paa.assignment_id = p_assignment_id
1948: and pap.person_id = paa.person_id
1949: and p_date_earned between paa.effective_start_date and paa.effective_end_date
3526: l_sec_and_he_cess_percent NUMBER;
3527:
3528: l_table_name VARCHAR2(100);
3529: p_tax_on_income NUMBER;
3530: l_pan per_all_people_f.per_information4%TYPE;
3531:
3532: l_rebate_amount NUMBER;
3533: l_minimum_limit NUMBER;
3534: l_maximum_limit NUMBER; /*budget 2013 changes */
3565: l_income_tax:=0;
3566:
3567: -- Start of Bug 11821281
3568: SELECT pep.per_information4 INTO l_pan
3569: FROM per_all_people_f pep,
3570: per_all_assignments_f asg,
3571: per_periods_of_service pos
3572: WHERE asg.assignment_id = p_assignment_id
3573: AND asg.person_id = pep.person_id
3928: l_sec_and_he_cess_percent NUMBER;
3929:
3930: l_table_name VARCHAR2(100);
3931: p_tax_on_income NUMBER;
3932: l_pan per_all_people_f.per_information4%TYPE;
3933:
3934: l_rebate_amount NUMBER;
3935: l_minimum_limit NUMBER;
3936: l_maximum_limit NUMBER; /*budget 2013 changes */
3967: l_income_tax:=0;
3968:
3969: -- Start of Bug 11821281
3970: SELECT pep.per_information4 INTO l_pan
3971: FROM per_all_people_f pep,
3972: per_all_assignments_f asg,
3973: per_periods_of_service pos
3974: WHERE asg.assignment_id = p_assignment_id
3975: AND asg.person_id = pep.person_id