DBA Data[Home] [Help]

APPS.PAY_KR_YEA_SSHR_UTILS_PKG dependencies on PER_KR_ASSIGNMENT_YEA_INFO

Line 39: from per_kr_assignment_yea_info

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

Line 287: from per_kr_assignment_yea_info info

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'

Line 334: from per_kr_assignment_yea_info info

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