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_PKG dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 252: from per_assignment_extra_info aei

248: 'PREV_RTAX=P', nvl(aei.aei_information14, 0),
249: 'PREV_STAX=P', nvl(aei.aei_information15, 0),
250: 'PREV_EFF_DATE=P', pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE') -- Bug 9386289
251: -- End of Bug 9213683
252: from per_assignment_extra_info aei
253: where aei.assignment_id = p_assignment_id
254: and aei.information_type = 'KR_YEA_PREV_ER_INFO'
255: and to_number(to_char(fnd_date.canonical_to_date(aei.aei_information1), 'YYYY')) = g_target_year
256: order by aei_information1, 2;

Line 381: from per_assignment_extra_info

377: 'YEAR=P', '00' year,
378: 'CONT_AMOUNT=P', aei_information5,
379: 'F_RECORD_COUNT=P', pay_kr_yea_magtape_fun_pkg.f_record_count(p_assignment_id,p_effective_date,p_assignment_action_id),
380: 'EXEMPTION_AMOUNT=P', pay_kr_yea_magtape_fun_pkg.get_sep_pen_eligible(p_assignment_id,p_assignment_action_id,p_effective_date, information_type,aei_information6)
381: from per_assignment_extra_info
382: where
383: information_type = 'KR_YEA_SEP_PEN_DETAILS'
384: and assignment_id = p_assignment_id
385: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY')

Line 402: from per_assignment_extra_info

398: 'YEAR=P', '00' year,
399: 'CONT_AMOUNT=P', aei_information5,
400: 'F_RECORD_COUNT=P', pay_kr_yea_magtape_fun_pkg.f_record_count(p_assignment_id,p_effective_date,p_assignment_action_id),
401: 'EXEMPTION_AMOUNT=P', pay_kr_yea_magtape_fun_pkg.get_sep_pen_eligible(p_assignment_id,p_assignment_action_id,p_effective_date, information_type,aei_information6)
402: from per_assignment_extra_info
403: where
404: information_type = 'KR_YEA_PEN_SAVING_DETAILS'
405: and assignment_id = p_assignment_id
406: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY')

Line 424: from per_assignment_extra_info

420: 'YEAR=P', '00' year,
421: 'CONT_AMOUNT=P', aei_information5,
422: 'F_RECORD_COUNT=P', pay_kr_yea_magtape_fun_pkg.f_record_count(p_assignment_id,p_effective_date,p_assignment_action_id),
423: 'EXEMPTION_AMOUNT=P', pay_kr_yea_magtape_fun_pkg.get_sep_pen_eligible(p_assignment_id,p_assignment_action_id,p_effective_date, information_type,aei_information6)
424: from per_assignment_extra_info
425: where
426: information_type = 'KR_YEA_HOU_SAVING_DETAILS'
427: and assignment_id = p_assignment_id
428: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY')

Line 446: from per_assignment_extra_info

442: 'YEAR=P', decode(aei_information2,'1','01','2','02','3','03') year,
443: 'CONT_AMOUNT=P', aei_information5,
444: 'F_RECORD_COUNT=P', pay_kr_yea_magtape_fun_pkg.f_record_count(p_assignment_id,p_effective_date,p_assignment_action_id),
445: 'EXEMPTION_AMOUNT=P', pay_kr_yea_magtape_fun_pkg.get_sep_pen_eligible(p_assignment_id,p_assignment_action_id,p_effective_date, information_type,aei_information6)
446: from per_assignment_extra_info
447: where
448: information_type = 'KR_YEA_LT_STOCK_SAVING_DETAILS'
449: and assignment_id = p_assignment_id
450: and trunc(fnd_date.canonical_to_date(aei_information1), 'YYYY') = trunc(p_effective_date, 'YYYY')