DBA Data[Home] [Help]

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