eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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: --

Line 331: AND TRUNC(fnd_date.canonical_to_date(aei_information1), 'YYYY') = TRUNC(p_effective_date, 'YYYY');

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'
331: AND TRUNC(fnd_date.canonical_to_date(aei_information1), 'YYYY') = TRUNC(p_effective_date, 'YYYY');
332: --
333: begin
334: --
335: open csr_aei;

Line 361: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY')

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')
362: and pay_kr_yea_magtape_fun_pkg.get_sep_pen_eligible(p_assignment_id,p_assignment_action_id,
363: p_effective_date, information_type,aei_information6) > 0;
364:
365:

Line 410: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY')

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);
412:
413: --------------------------------------------------------
414: function archive_item_value(p_user_entity_name in varchar2) return varchar2