120: l_message VARCHAR2(250);
121:
122: CURSOR c_pt_ceil IS
123: SELECT global_value
124: FROM ff_globals_f
125: WHERE global_name = 'IN_PTAX_CEILING'
126: AND p_effective_date between effective_start_date and effective_end_date;
127:
128: /*Cursor to get the person type of the given person id*/
135: AND pptu.person_id = p_person_id
136: AND p_effective_date BETWEEN pptu.effective_start_date
137: AND pptu.effective_end_date AND ppt.system_person_type = 'EMP';
138:
139: l_pt_ceil ff_globals_f.global_value%TYPE;
140: l_person_type VARCHAR2(1);
141:
142: BEGIN
143: