APPS.PAY_KR_YEA_MAGTAPE_FUN_PKG dependencies on FND_DATE

Line 121: and to_number(to_char(fnd_date.canonical_to_date(aei.aei_information1), 'YYYY')) = pay_kr_yea_magtape_pkg.g_target_year;

117: and paa.tax_unit_id = bp.organization_id
118: and paa.action_status = 'C'
119: and aei.assignment_id = paa.assignment_id
120: and aei.information_type = 'KR_YEA_PREV_ER_INFO'
121: and to_number(to_char(fnd_date.canonical_to_date(aei.aei_information1), 'YYYY')) = pay_kr_yea_magtape_pkg.g_target_year;
122: begin
123: -- if g_b_record.tax_unit_id is null or g_b_record.tax_unit_id <> p_tax_unit_id then
124: -- g_b_record.tax_unit_id := p_tax_unit_id;
125: --

Line 191: and to_number(to_char(fnd_date.canonical_to_date(aei.aei_information1), 'YYYY')) = pay_kr_yea_magtape_pkg.g_target_year;

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
193: if g_c_record.assignment_id is null or g_c_record.assignment_id <> p_assignment_id then
194: g_c_record.assignment_id := p_assignment_id;
195: --