APPS.PAY_KR_YEA_MAGTAPE_FUN_PKG dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 92: from per_assignment_extra_info aei,

88:
89: cursor csr_b2 is
90: select
91: count(*)
92: from per_assignment_extra_info aei,
93: pay_assignment_actions paa,
94: pay_payroll_actions ppa,
95: hr_organization_units bp,
96: hr_organization_information hoi1,

Line 188: from per_assignment_extra_info aei

184: --
185: cursor csr_c is
186: select
187: count(*)
188: from per_assignment_extra_info aei
189: where aei.assignment_id = p_assignment_id
190: and aei.information_type = 'KR_YEA_PREV_ER_INFO'
191: and to_number(to_char(fnd_date.canonical_to_date(aei.aei_information1), 'YYYY')) = pay_kr_yea_magtape_pkg.g_target_year;
192: begin

Line 326: FROM per_assignment_extra_info

322: l_dummy number := 0;
323:
324: cursor csr_aei is
325: SELECT nvl(aei_information5, 0) VALUE
326: FROM per_assignment_extra_info
327: WHERE assignment_id = p_assignment_id
328: AND aei_information4 = p_bp_number
329: AND aei_information2 = p_code
330: AND information_type = 'KR_YEA_NON_TAXABLE_EARN_DETAIL'

Line 357: from per_assignment_extra_info

353: l_count number := 0;
354:
355: cursor csr_f_count (p_assignment_id varchar2, p_effective_date date, p_assignment_action_id in varchar2 ) is
356: select count(*)
357: from per_assignment_extra_info
358: where
359: information_type in ('KR_YEA_SEP_PEN_DETAILS','KR_YEA_PEN_SAVING_DETAILS','KR_YEA_HOU_SAVING_DETAILS','KR_YEA_LT_STOCK_SAVING_DETAILS')
360: and assignment_id = p_ass_id
361: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY')

Line 407: from per_assignment_extra_info

403: p_row_count number;
404:
405: cursor csr(p_information_type in varchar2, p_assignment_id in varchar2, p_effective_date in date) is
406: select aei_information6
407: from per_assignment_extra_info
408: where information_type = p_information_type
409: and assignment_id = p_assignment_id
410: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY')
411: order by to_number(aei_information6);