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_DON_EFILE_CONC_PKG dependencies on PAY_KR_YEA_DON_EFILE_PKG

Line 125: and ( (ppa.report_category in (pay_kr_yea_don_efile_pkg.g_normal_yea, pay_kr_yea_don_efile_pkg.g_interim_yea, pay_kr_yea_don_efile_pkg.g_re_yea))

121: and hoi2.org_information_context = 'KR_INCOME_TAX_OFFICE'
122: and ppa.business_group_id = bp.business_group_id
123: and ppa.report_type = 'YEA'
124: and ppa.report_qualifier = 'KR'
125: and ( (ppa.report_category in (pay_kr_yea_don_efile_pkg.g_normal_yea, pay_kr_yea_don_efile_pkg.g_interim_yea, pay_kr_yea_don_efile_pkg.g_re_yea))
126: or (ppa.payroll_action_id = pay_kr_yea_don_efile_pkg.g_payroll_action_id) )
127: and to_number(to_char(ppa.effective_date, 'YYYY')) = pay_kr_yea_don_efile_pkg.g_target_year
128: --
129: and ppa.action_type in ('B','X')

Line 126: or (ppa.payroll_action_id = pay_kr_yea_don_efile_pkg.g_payroll_action_id) )

122: and ppa.business_group_id = bp.business_group_id
123: and ppa.report_type = 'YEA'
124: and ppa.report_qualifier = 'KR'
125: and ( (ppa.report_category in (pay_kr_yea_don_efile_pkg.g_normal_yea, pay_kr_yea_don_efile_pkg.g_interim_yea, pay_kr_yea_don_efile_pkg.g_re_yea))
126: or (ppa.payroll_action_id = pay_kr_yea_don_efile_pkg.g_payroll_action_id) )
127: and to_number(to_char(ppa.effective_date, 'YYYY')) = pay_kr_yea_don_efile_pkg.g_target_year
128: --
129: and ppa.action_type in ('B','X')
130: and paa.payroll_action_id = ppa.payroll_action_id

Line 127: and to_number(to_char(ppa.effective_date, 'YYYY')) = pay_kr_yea_don_efile_pkg.g_target_year

123: and ppa.report_type = 'YEA'
124: and ppa.report_qualifier = 'KR'
125: and ( (ppa.report_category in (pay_kr_yea_don_efile_pkg.g_normal_yea, pay_kr_yea_don_efile_pkg.g_interim_yea, pay_kr_yea_don_efile_pkg.g_re_yea))
126: or (ppa.payroll_action_id = pay_kr_yea_don_efile_pkg.g_payroll_action_id) )
127: and to_number(to_char(ppa.effective_date, 'YYYY')) = pay_kr_yea_don_efile_pkg.g_target_year
128: --
129: and ppa.action_type in ('B','X')
130: and paa.payroll_action_id = ppa.payroll_action_id
131: and ppa.payroll_action_id = ppa.payroll_action_id

Line 134: (pay_kr_yea_don_efile_pkg.g_assignment_set_id is null) or

130: and paa.payroll_action_id = ppa.payroll_action_id
131: and ppa.payroll_action_id = ppa.payroll_action_id
132: --
133: and (
134: (pay_kr_yea_don_efile_pkg.g_assignment_set_id is null) or
135: (hr_assignment_set.assignment_in_set(pay_kr_yea_don_efile_pkg.g_assignment_set_id, paa.assignment_id) = 'Y')
136: )
137: and (
138: (pay_kr_yea_don_efile_pkg.g_re_yea <> 'R')

Line 135: (hr_assignment_set.assignment_in_set(pay_kr_yea_don_efile_pkg.g_assignment_set_id, paa.assignment_id) = 'Y')

131: and ppa.payroll_action_id = ppa.payroll_action_id
132: --
133: and (
134: (pay_kr_yea_don_efile_pkg.g_assignment_set_id is null) or
135: (hr_assignment_set.assignment_in_set(pay_kr_yea_don_efile_pkg.g_assignment_set_id, paa.assignment_id) = 'Y')
136: )
137: and (
138: (pay_kr_yea_don_efile_pkg.g_re_yea <> 'R')
139: or

Line 138: (pay_kr_yea_don_efile_pkg.g_re_yea <> 'R')

134: (pay_kr_yea_don_efile_pkg.g_assignment_set_id is null) or
135: (hr_assignment_set.assignment_in_set(pay_kr_yea_don_efile_pkg.g_assignment_set_id, paa.assignment_id) = 'Y')
136: )
137: and (
138: (pay_kr_yea_don_efile_pkg.g_re_yea <> 'R')
139: or
140: (pay_kr_yea_magtape_fun_pkg.latest_yea_action(paa.assignment_action_id, pay_kr_yea_don_efile_pkg.g_payroll_action_id, pay_kr_yea_don_efile_pkg.g_target_year) = 'Y')
141: )
142: --

Line 140: (pay_kr_yea_magtape_fun_pkg.latest_yea_action(paa.assignment_action_id, pay_kr_yea_don_efile_pkg.g_payroll_action_id, pay_kr_yea_don_efile_pkg.g_target_year) = 'Y')

136: )
137: and (
138: (pay_kr_yea_don_efile_pkg.g_re_yea <> 'R')
139: or
140: (pay_kr_yea_magtape_fun_pkg.latest_yea_action(paa.assignment_action_id, pay_kr_yea_don_efile_pkg.g_payroll_action_id, pay_kr_yea_don_efile_pkg.g_target_year) = 'Y')
141: )
142: --
143: and paa.tax_unit_id = bp.organization_id
144: and paa.action_status = 'C'

Line 153: and pae.aei_information2 <= pay_kr_yea_don_efile_pkg.g_target_year

149: and ppa.effective_date
150: between pp.effective_start_date and pp.effective_end_date
151: and pae.assignment_id = pa.assignment_id
152: and pae.information_type = 'KR_YEA_DONATION_TYPE_DETAIL'
153: and pae.aei_information2 <= pay_kr_yea_don_efile_pkg.g_target_year
154: and to_char(fnd_date.canonical_to_date(pae.aei_information1),'yyyy') = pay_kr_yea_don_efile_pkg.g_target_year;
155:
156: cursor csr_count_d is
157: select

Line 154: and to_char(fnd_date.canonical_to_date(pae.aei_information1),'yyyy') = pay_kr_yea_don_efile_pkg.g_target_year;

150: between pp.effective_start_date and pp.effective_end_date
151: and pae.assignment_id = pa.assignment_id
152: and pae.information_type = 'KR_YEA_DONATION_TYPE_DETAIL'
153: and pae.aei_information2 <= pay_kr_yea_don_efile_pkg.g_target_year
154: and to_char(fnd_date.canonical_to_date(pae.aei_information1),'yyyy') = pay_kr_yea_don_efile_pkg.g_target_year;
155:
156: cursor csr_count_d is
157: select
158: count(*)

Line 186: and ( (ppa.report_category in (pay_kr_yea_don_efile_pkg.g_normal_yea, pay_kr_yea_don_efile_pkg.g_interim_yea, pay_kr_yea_don_efile_pkg.g_re_yea)) or (ppa.payroll_action_id = pay_kr_yea_don_efile_pkg.g_payroll_action_id) )

182: and hoi2.org_information_context = 'KR_INCOME_TAX_OFFICE'
183: and hoi1.org_information_context like 'KR_BUSINESS_PLACE_REGISTRATION'
184: and ppa.report_type = 'YEA'
185: and ppa.report_qualifier = 'KR'
186: and ( (ppa.report_category in (pay_kr_yea_don_efile_pkg.g_normal_yea, pay_kr_yea_don_efile_pkg.g_interim_yea, pay_kr_yea_don_efile_pkg.g_re_yea)) or (ppa.payroll_action_id = pay_kr_yea_don_efile_pkg.g_payroll_action_id) )
187: and to_number(to_char(ppa.effective_date, 'YYYY')) = pay_kr_yea_don_efile_pkg.g_target_year
188: --
189: and ppa.action_type in ('B','X')
190: and paa.payroll_action_id = ppa.payroll_action_id

Line 187: and to_number(to_char(ppa.effective_date, 'YYYY')) = pay_kr_yea_don_efile_pkg.g_target_year

183: and hoi1.org_information_context like 'KR_BUSINESS_PLACE_REGISTRATION'
184: and ppa.report_type = 'YEA'
185: and ppa.report_qualifier = 'KR'
186: and ( (ppa.report_category in (pay_kr_yea_don_efile_pkg.g_normal_yea, pay_kr_yea_don_efile_pkg.g_interim_yea, pay_kr_yea_don_efile_pkg.g_re_yea)) or (ppa.payroll_action_id = pay_kr_yea_don_efile_pkg.g_payroll_action_id) )
187: and to_number(to_char(ppa.effective_date, 'YYYY')) = pay_kr_yea_don_efile_pkg.g_target_year
188: --
189: and ppa.action_type in ('B','X')
190: and paa.payroll_action_id = ppa.payroll_action_id
191: and ppa.payroll_action_id = ppa.payroll_action_id

Line 192: and ((pay_kr_yea_don_efile_pkg.g_assignment_set_id is null) or (hr_assignment_set.assignment_in_set(pay_kr_yea_don_efile_pkg.g_assignment_set_id, paa.assignment_id) = 'Y'))

188: --
189: and ppa.action_type in ('B','X')
190: and paa.payroll_action_id = ppa.payroll_action_id
191: and ppa.payroll_action_id = ppa.payroll_action_id
192: and ((pay_kr_yea_don_efile_pkg.g_assignment_set_id is null) or (hr_assignment_set.assignment_in_set(pay_kr_yea_don_efile_pkg.g_assignment_set_id, paa.assignment_id) = 'Y'))
193: and ((pay_kr_yea_don_efile_pkg.g_re_yea <> 'R') or (pay_kr_yea_magtape_fun_pkg.latest_yea_action(paa.assignment_action_id, pay_kr_yea_don_efile_pkg.g_payroll_action_id, pay_kr_yea_don_efile_pkg.g_target_year) = 'Y'))
194: --
195: and paa.tax_unit_id = bp.organization_id
196: and paa.action_status = 'C'

Line 193: and ((pay_kr_yea_don_efile_pkg.g_re_yea <> 'R') or (pay_kr_yea_magtape_fun_pkg.latest_yea_action(paa.assignment_action_id, pay_kr_yea_don_efile_pkg.g_payroll_action_id, pay_kr_yea_don_efile_pkg.g_target_year) = 'Y'))

189: and ppa.action_type in ('B','X')
190: and paa.payroll_action_id = ppa.payroll_action_id
191: and ppa.payroll_action_id = ppa.payroll_action_id
192: and ((pay_kr_yea_don_efile_pkg.g_assignment_set_id is null) or (hr_assignment_set.assignment_in_set(pay_kr_yea_don_efile_pkg.g_assignment_set_id, paa.assignment_id) = 'Y'))
193: and ((pay_kr_yea_don_efile_pkg.g_re_yea <> 'R') or (pay_kr_yea_magtape_fun_pkg.latest_yea_action(paa.assignment_action_id, pay_kr_yea_don_efile_pkg.g_payroll_action_id, pay_kr_yea_don_efile_pkg.g_target_year) = 'Y'))
194: --
195: and paa.tax_unit_id = bp.organization_id
196: and paa.action_status = 'C'
197: and pa.assignment_id = paa.assignment_id

Line 215: and to_char(fnd_date.canonical_to_date(aei.aei_information1),'yyyy') = pay_kr_yea_don_efile_pkg.g_target_year

211: and resreg.cont_person_id = pp.person_id
212: and pp.national_identifier = aei.aei_information13
213: and aei.assignment_id = pa.assignment_id
214: and aei.information_type = 'KR_YEA_DETAIL_DONATION_INFO'
215: and to_char(fnd_date.canonical_to_date(aei.aei_information1),'yyyy') = pay_kr_yea_don_efile_pkg.g_target_year
216: group by aei.assignment_id,
217: aei.aei_information13,
218: pp.last_name || pp.first_name,
219: aei.aei_information12,