DBA Data[Home] [Help]

APPS.PAY_KR_YEA_MAGTAPE_PKG dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 186: from per_assignment_extra_info aei

182: 'PREV_TAXABLE_MTH=P', nvl(aei.aei_information4, 0),
183: 'PREV_TAXABLE_BON=P', nvl(aei.aei_information5, 0),
184: 'PREV_SP_IRREG_BONUS=P', nvl(aei.aei_information6, 0),
185: 'PREV_STCK_PUR_OPT_EXEC_EARN=P', nvl(aei.aei_information17, 0) -- Bug 6622876
186: from per_assignment_extra_info aei
187: where aei.assignment_id = p_assignment_id
188: and aei.information_type = 'KR_YEA_PREV_ER_INFO'
189: and to_number(to_char(fnd_date.canonical_to_date(aei.aei_information1), 'YYYY')) = g_target_year
190: order by aei_information1, 2;