56:
57: --
58: l_procedure VARCHAR2(100);
59: l_message VARCHAR2(255);
60: l_assignment_id per_assignments_f.assignment_id%TYPE;
61: l_pension_fund_80ccc NUMBER;
62: l_med_ins_prem_80d NUMBER;
63: l_80ddb_sr VARCHAR2(5);
64: l_disease_trt NUMBER;
69: l_inv_80l NUMBER;
70: l_sec_80l NUMBER;
71: l_date DATE;
72: l_warning BOOLEAN;
73: l_payroll_id per_assignments_f.payroll_id%TYPE;
74: l_element_entry_id NUMBER;
75:
76:
77: CURSOR c_asg_details IS
75:
76:
77: CURSOR c_asg_details IS
78: SELECT assignment_id
79: FROM per_assignments_f
80: WHERE person_id = p_person_id
81: AND primary_flag = 'Y'
82: AND p_effective_date BETWEEN effective_start_date
83: AND effective_end_date;