35: l_entry_status VARCHAR2(2);
36:
37: cursor csr_get_entry_status is
38: select ayi_information3
39: from per_kr_assignment_yea_info
40: where information_type = 'KR_YEA_ENTRY_STATUS'
41: and assignment_id = p_assignment_id
42: and target_year = p_target_year;
43: begin
283: info.ayi_information27,
284: info.ayi_information28,
285: info.ayi_information29,
286: info.ayi_information30
287: from per_kr_assignment_yea_info info
288: where assignment_id = p_assignment_id
289: and target_year = p_target_year
290: and information_type in ('KR_YEA_SP_TAX_EXEM_INFO'
291: ,'KR_YEA_SP_TAX_EXEM_INFO2'
330: info.ayi_information27,
331: info.ayi_information28,
332: info.ayi_information29,
333: info.ayi_information30
334: from per_kr_assignment_yea_info info
335: where assignment_id = p_assignment_id
336: and information_type = 'KR_YEA_FW_TAX_BREAK_INFO';
337: --
338: -- Bug 4915940