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 PAY_KR_YEA_MAGTAPE_PKG

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

40: and hoi1.org_information_context = 'KR_BUSINESS_PLACE_REGISTRATION'
41: and ppa.report_type = 'YEA'
42: and ppa.report_qualifier = 'KR'
43: -- Bug 3248513
44: and ( (ppa.report_category in (pay_kr_yea_magtape_pkg.g_normal_yea, pay_kr_yea_magtape_pkg.g_interim_yea, pay_kr_yea_magtape_pkg.g_re_yea)) or (ppa.payroll_action_id = pay_kr_yea_magtape_pkg.g_payroll_action_id) )
45: and to_number(to_char(ppa.effective_date, 'YYYY')) = pay_kr_yea_magtape_pkg.g_target_year
46: --
47: and ppa.action_type in ('B','X')
48: and paa.payroll_action_id = ppa.payroll_action_id

Line 45: and to_number(to_char(ppa.effective_date, 'YYYY')) = pay_kr_yea_magtape_pkg.g_target_year

41: and ppa.report_type = 'YEA'
42: and ppa.report_qualifier = 'KR'
43: -- Bug 3248513
44: and ( (ppa.report_category in (pay_kr_yea_magtape_pkg.g_normal_yea, pay_kr_yea_magtape_pkg.g_interim_yea, pay_kr_yea_magtape_pkg.g_re_yea)) or (ppa.payroll_action_id = pay_kr_yea_magtape_pkg.g_payroll_action_id) )
45: and to_number(to_char(ppa.effective_date, 'YYYY')) = pay_kr_yea_magtape_pkg.g_target_year
46: --
47: and ppa.action_type in ('B','X')
48: and paa.payroll_action_id = ppa.payroll_action_id
49: and ppa.payroll_action_id = ppa.payroll_action_id

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

47: and ppa.action_type in ('B','X')
48: and paa.payroll_action_id = ppa.payroll_action_id
49: and ppa.payroll_action_id = ppa.payroll_action_id
50: -- Bug 3248513
51: and ((pay_kr_yea_magtape_pkg.g_assignment_set_id is null) or (hr_assignment_set.assignment_in_set(pay_kr_yea_magtape_pkg.g_assignment_set_id, paa.assignment_id) = 'Y'))
52: and ((pay_kr_yea_magtape_pkg.g_re_yea <> 'R') or (pay_kr_yea_magtape_fun_pkg.latest_yea_action(paa.assignment_action_id, pay_kr_yea_magtape_pkg.g_payroll_action_id, pay_kr_yea_magtape_pkg.g_target_year) = 'Y'))
53: --
54: and paa.tax_unit_id = bp.organization_id
55: and paa.action_status = 'C';

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

48: and paa.payroll_action_id = ppa.payroll_action_id
49: and ppa.payroll_action_id = ppa.payroll_action_id
50: -- Bug 3248513
51: and ((pay_kr_yea_magtape_pkg.g_assignment_set_id is null) or (hr_assignment_set.assignment_in_set(pay_kr_yea_magtape_pkg.g_assignment_set_id, paa.assignment_id) = 'Y'))
52: and ((pay_kr_yea_magtape_pkg.g_re_yea <> 'R') or (pay_kr_yea_magtape_fun_pkg.latest_yea_action(paa.assignment_action_id, pay_kr_yea_magtape_pkg.g_payroll_action_id, pay_kr_yea_magtape_pkg.g_target_year) = 'Y'))
53: --
54: and paa.tax_unit_id = bp.organization_id
55: and paa.action_status = 'C';
56:

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

70: and hoi1.org_information_context = 'KR_BUSINESS_PLACE_REGISTRATION'
71: and ppa.report_type = 'YEA'
72: and ppa.report_qualifier = 'KR'
73: -- Bug 3248513
74: and ( (ppa.report_category in (pay_kr_yea_magtape_pkg.g_normal_yea, pay_kr_yea_magtape_pkg.g_interim_yea, pay_kr_yea_magtape_pkg.g_re_yea)) or (ppa.payroll_action_id = pay_kr_yea_magtape_pkg.g_payroll_action_id) )
75: and to_number(to_char(ppa.effective_date, 'YYYY')) = pay_kr_yea_magtape_pkg.g_target_year
76: --
77: and ppa.action_type in ('B','X')
78: and paa.payroll_action_id = ppa.payroll_action_id

Line 75: and to_number(to_char(ppa.effective_date, 'YYYY')) = pay_kr_yea_magtape_pkg.g_target_year

71: and ppa.report_type = 'YEA'
72: and ppa.report_qualifier = 'KR'
73: -- Bug 3248513
74: and ( (ppa.report_category in (pay_kr_yea_magtape_pkg.g_normal_yea, pay_kr_yea_magtape_pkg.g_interim_yea, pay_kr_yea_magtape_pkg.g_re_yea)) or (ppa.payroll_action_id = pay_kr_yea_magtape_pkg.g_payroll_action_id) )
75: and to_number(to_char(ppa.effective_date, 'YYYY')) = pay_kr_yea_magtape_pkg.g_target_year
76: --
77: and ppa.action_type in ('B','X')
78: and paa.payroll_action_id = ppa.payroll_action_id
79: and ppa.payroll_action_id = ppa.payroll_action_id

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

77: and ppa.action_type in ('B','X')
78: and paa.payroll_action_id = ppa.payroll_action_id
79: and ppa.payroll_action_id = ppa.payroll_action_id
80: -- Bug 3248513
81: and ((pay_kr_yea_magtape_pkg.g_assignment_set_id is null) or (hr_assignment_set.assignment_in_set(pay_kr_yea_magtape_pkg.g_assignment_set_id, paa.assignment_id) = 'Y'))
82: and ((pay_kr_yea_magtape_pkg.g_re_yea <> 'R') or (pay_kr_yea_magtape_fun_pkg.latest_yea_action(paa.assignment_action_id, pay_kr_yea_magtape_pkg.g_payroll_action_id, pay_kr_yea_magtape_pkg.g_target_year) = 'Y'))
83: --
84: and paa.tax_unit_id = bp.organization_id
85: and paa.action_status = 'C'

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

78: and paa.payroll_action_id = ppa.payroll_action_id
79: and ppa.payroll_action_id = ppa.payroll_action_id
80: -- Bug 3248513
81: and ((pay_kr_yea_magtape_pkg.g_assignment_set_id is null) or (hr_assignment_set.assignment_in_set(pay_kr_yea_magtape_pkg.g_assignment_set_id, paa.assignment_id) = 'Y'))
82: and ((pay_kr_yea_magtape_pkg.g_re_yea <> 'R') or (pay_kr_yea_magtape_fun_pkg.latest_yea_action(paa.assignment_action_id, pay_kr_yea_magtape_pkg.g_payroll_action_id, pay_kr_yea_magtape_pkg.g_target_year) = 'Y'))
83: --
84: and paa.tax_unit_id = bp.organization_id
85: and paa.action_status = 'C'
86: and i1.context1(+) = paa.assignment_action_id

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

103: and hoi1.org_information_context like 'KR_BUSINESS_PLACE_REGISTRATION'
104: and ppa.report_type = 'YEA'
105: and ppa.report_qualifier = 'KR'
106: -- Bug 3248513
107: and ( (ppa.report_category in (pay_kr_yea_magtape_pkg.g_normal_yea, pay_kr_yea_magtape_pkg.g_interim_yea, pay_kr_yea_magtape_pkg.g_re_yea)) or (ppa.payroll_action_id = pay_kr_yea_magtape_pkg.g_payroll_action_id) )
108: and to_number(to_char(ppa.effective_date, 'YYYY')) = pay_kr_yea_magtape_pkg.g_target_year
109: --
110: and ppa.action_type in ('B','X')
111: and paa.payroll_action_id = ppa.payroll_action_id

Line 108: and to_number(to_char(ppa.effective_date, 'YYYY')) = pay_kr_yea_magtape_pkg.g_target_year

104: and ppa.report_type = 'YEA'
105: and ppa.report_qualifier = 'KR'
106: -- Bug 3248513
107: and ( (ppa.report_category in (pay_kr_yea_magtape_pkg.g_normal_yea, pay_kr_yea_magtape_pkg.g_interim_yea, pay_kr_yea_magtape_pkg.g_re_yea)) or (ppa.payroll_action_id = pay_kr_yea_magtape_pkg.g_payroll_action_id) )
108: and to_number(to_char(ppa.effective_date, 'YYYY')) = pay_kr_yea_magtape_pkg.g_target_year
109: --
110: and ppa.action_type in ('B','X')
111: and paa.payroll_action_id = ppa.payroll_action_id
112: and ppa.payroll_action_id = ppa.payroll_action_id

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

110: and ppa.action_type in ('B','X')
111: and paa.payroll_action_id = ppa.payroll_action_id
112: and ppa.payroll_action_id = ppa.payroll_action_id
113: -- Bug 3248513
114: and ((pay_kr_yea_magtape_pkg.g_assignment_set_id is null) or (hr_assignment_set.assignment_in_set(pay_kr_yea_magtape_pkg.g_assignment_set_id, paa.assignment_id) = 'Y'))
115: and ((pay_kr_yea_magtape_pkg.g_re_yea <> 'R') or (pay_kr_yea_magtape_fun_pkg.latest_yea_action(paa.assignment_action_id, pay_kr_yea_magtape_pkg.g_payroll_action_id, pay_kr_yea_magtape_pkg.g_target_year) = 'Y'))
116: --
117: and paa.tax_unit_id = bp.organization_id
118: and paa.action_status = 'C'

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

111: and paa.payroll_action_id = ppa.payroll_action_id
112: and ppa.payroll_action_id = ppa.payroll_action_id
113: -- Bug 3248513
114: and ((pay_kr_yea_magtape_pkg.g_assignment_set_id is null) or (hr_assignment_set.assignment_in_set(pay_kr_yea_magtape_pkg.g_assignment_set_id, paa.assignment_id) = 'Y'))
115: and ((pay_kr_yea_magtape_pkg.g_re_yea <> 'R') or (pay_kr_yea_magtape_fun_pkg.latest_yea_action(paa.assignment_action_id, pay_kr_yea_magtape_pkg.g_payroll_action_id, pay_kr_yea_magtape_pkg.g_target_year) = 'Y'))
116: --
117: and paa.tax_unit_id = bp.organization_id
118: and paa.action_status = 'C'
119: and aei.assignment_id = paa.assignment_id

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 130: open csr_b3(pay_kr_yea_magtape_pkg.g_taxable_id);

126: open csr_b1;
127: fetch csr_b1 into g_b_record.c_records;
128: close csr_b1;
129:
130: open csr_b3(pay_kr_yea_magtape_pkg.g_taxable_id);
131: fetch csr_b3 into g_b_record.taxable;
132: close csr_b3;
133:
134: open csr_b3(pay_kr_yea_magtape_pkg.g_annual_itax_id);

Line 134: open csr_b3(pay_kr_yea_magtape_pkg.g_annual_itax_id);

130: open csr_b3(pay_kr_yea_magtape_pkg.g_taxable_id);
131: fetch csr_b3 into g_b_record.taxable;
132: close csr_b3;
133:
134: open csr_b3(pay_kr_yea_magtape_pkg.g_annual_itax_id);
135: fetch csr_b3 into g_b_record.annual_itax;
136: close csr_b3;
137:
138: open csr_b3(pay_kr_yea_magtape_pkg.g_annual_rtax_id);

Line 138: open csr_b3(pay_kr_yea_magtape_pkg.g_annual_rtax_id);

134: open csr_b3(pay_kr_yea_magtape_pkg.g_annual_itax_id);
135: fetch csr_b3 into g_b_record.annual_itax;
136: close csr_b3;
137:
138: open csr_b3(pay_kr_yea_magtape_pkg.g_annual_rtax_id);
139: fetch csr_b3 into g_b_record.annual_rtax;
140: close csr_b3;
141:
142: open csr_b3(pay_kr_yea_magtape_pkg.g_annual_stax_id);

Line 142: open csr_b3(pay_kr_yea_magtape_pkg.g_annual_stax_id);

138: open csr_b3(pay_kr_yea_magtape_pkg.g_annual_rtax_id);
139: fetch csr_b3 into g_b_record.annual_rtax;
140: close csr_b3;
141:
142: open csr_b3(pay_kr_yea_magtape_pkg.g_annual_stax_id);
143: fetch csr_b3 into g_b_record.annual_stax;
144: close csr_b3;
145:
146: --

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