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_SPAY_EFILE dependencies on PAY_MAGTAPE_GENERIC

Line 22: pay_magtape_generic.get_parameter_value('START_DATE')

18: ,hr_organization_information ihoi
19: WHERE xppa.action_type = 'X'
20: and xppa.action_status = 'C'
21: and xppa.effective_date between
22: pay_magtape_generic.get_parameter_value('START_DATE')
23: and
24: pay_magtape_generic.get_parameter_value('END_DATE')
25: and xppa.payroll_action_id = xpaa.payroll_action_id
26: and xpaa.action_status = 'C'

Line 24: pay_magtape_generic.get_parameter_value('END_DATE')

20: and xppa.action_status = 'C'
21: and xppa.effective_date between
22: pay_magtape_generic.get_parameter_value('START_DATE')
23: and
24: pay_magtape_generic.get_parameter_value('END_DATE')
25: and xppa.payroll_action_id = xpaa.payroll_action_id
26: and xpaa.action_status = 'C'
27: --Bug 5069923
28: and xppa.payroll_action_id = nvl(pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID'),xpaa.payroll_action_id) --Bug 5069923

Line 28: and xppa.payroll_action_id = nvl(pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID'),xpaa.payroll_action_id) --Bug 5069923

24: pay_magtape_generic.get_parameter_value('END_DATE')
25: and xppa.payroll_action_id = xpaa.payroll_action_id
26: and xpaa.action_status = 'C'
27: --Bug 5069923
28: and xppa.payroll_action_id = nvl(pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID'),xpaa.payroll_action_id) --Bug 5069923
29: --Bug 5069923
30: and ( (pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID') is null)
31: or (hr_assignment_set.assignment_in_set(pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID'), xpaa.assignment_id) = 'Y')
32: )

Line 30: and ( (pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID') is null)

26: and xpaa.action_status = 'C'
27: --Bug 5069923
28: and xppa.payroll_action_id = nvl(pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID'),xpaa.payroll_action_id) --Bug 5069923
29: --Bug 5069923
30: and ( (pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID') is null)
31: or (hr_assignment_set.assignment_in_set(pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID'), xpaa.assignment_id) = 'Y')
32: )
33: --Bug 5069923
34: and ( (pay_magtape_generic.get_parameter_value('REPORT_FOR')='A')

Line 31: or (hr_assignment_set.assignment_in_set(pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID'), xpaa.assignment_id) = 'Y')

27: --Bug 5069923
28: and xppa.payroll_action_id = nvl(pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID'),xpaa.payroll_action_id) --Bug 5069923
29: --Bug 5069923
30: and ( (pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID') is null)
31: or (hr_assignment_set.assignment_in_set(pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID'), xpaa.assignment_id) = 'Y')
32: )
33: --Bug 5069923
34: and ( (pay_magtape_generic.get_parameter_value('REPORT_FOR')='A')
35: or ( (hoi.organization_id in (select posev.ORGANIZATION_ID_child

Line 34: and ( (pay_magtape_generic.get_parameter_value('REPORT_FOR')='A')

30: and ( (pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID') is null)
31: or (hr_assignment_set.assignment_in_set(pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID'), xpaa.assignment_id) = 'Y')
32: )
33: --Bug 5069923
34: and ( (pay_magtape_generic.get_parameter_value('REPORT_FOR')='A')
35: or ( (hoi.organization_id in (select posev.ORGANIZATION_ID_child
36: from PER_ORG_STRUCTURE_ELEMENTS posev
37: where posev.org_structure_version_id=(pay_magtape_generic.get_parameter_value('ORG_STRUC_VERSION_ID'))
38: and exists ( select null

Line 37: where posev.org_structure_version_id=(pay_magtape_generic.get_parameter_value('ORG_STRUC_VERSION_ID'))

33: --Bug 5069923
34: and ( (pay_magtape_generic.get_parameter_value('REPORT_FOR')='A')
35: or ( (hoi.organization_id in (select posev.ORGANIZATION_ID_child
36: from PER_ORG_STRUCTURE_ELEMENTS posev
37: where posev.org_structure_version_id=(pay_magtape_generic.get_parameter_value('ORG_STRUC_VERSION_ID'))
38: and exists ( select null
39: from hr_organization_information
40: where organization_id = posev.ORGANIZATION_ID_child
41: and org_information_context = 'CLASS'

Line 44: start with ORGANIZATION_ID_PARENT = (decode(pay_magtape_generic.get_parameter_value('REPORT_FOR'),'S',null,'SUB',pay_magtape_generic.get_parameter_value('PRIMARY_BP_ID')))

40: where organization_id = posev.ORGANIZATION_ID_child
41: and org_information_context = 'CLASS'
42: and org_information1 = 'KR_BUSINESS_PLACE'
43: )
44: start with ORGANIZATION_ID_PARENT = (decode(pay_magtape_generic.get_parameter_value('REPORT_FOR'),'S',null,'SUB',pay_magtape_generic.get_parameter_value('PRIMARY_BP_ID')))
45: connect by prior ORGANIZATION_ID_child = ORGANIZATION_ID_PARENT
46: )
47: )
48: or (hoi.organization_id = pay_magtape_generic.get_parameter_value('PRIMARY_BP_ID')

Line 48: or (hoi.organization_id = pay_magtape_generic.get_parameter_value('PRIMARY_BP_ID')

44: start with ORGANIZATION_ID_PARENT = (decode(pay_magtape_generic.get_parameter_value('REPORT_FOR'),'S',null,'SUB',pay_magtape_generic.get_parameter_value('PRIMARY_BP_ID')))
45: connect by prior ORGANIZATION_ID_child = ORGANIZATION_ID_PARENT
46: )
47: )
48: or (hoi.organization_id = pay_magtape_generic.get_parameter_value('PRIMARY_BP_ID')
49: )
50: )
51: )
52: and xppa.report_type = 'KR_SEP'

Line 57: and phou.organization_id = pay_magtape_generic.get_parameter_value('PRIMARY_BP_ID')

53: and xpaa.tax_unit_id = hou.organization_id
54: and hou.organization_id = hoi.organization_id
55: and hoi.org_information_context = 'KR_BUSINESS_PLACE_REGISTRATION'
56: and hoi.org_information10 = phoi.org_information10
57: and phou.organization_id = pay_magtape_generic.get_parameter_value('PRIMARY_BP_ID')
58: and phou.organization_id = phoi.organization_id
59: and phoi.org_information_context = 'KR_BUSINESS_PLACE_REGISTRATION'
60: and ihoi.org_information_context = 'KR_INCOME_TAX_OFFICE'
61: --Bug 5069923

Line 62: and xppa.business_group_id = pay_magtape_generic.get_parameter_value('BUSINESS_GROUP_ID')

58: and phou.organization_id = phoi.organization_id
59: and phoi.org_information_context = 'KR_BUSINESS_PLACE_REGISTRATION'
60: and ihoi.org_information_context = 'KR_INCOME_TAX_OFFICE'
61: --Bug 5069923
62: and xppa.business_group_id = pay_magtape_generic.get_parameter_value('BUSINESS_GROUP_ID')
63: and ihoi.organization_id = hou.organization_id
64: group by hoi.org_information10;
65:
66: cursor c_sep_tax_header

Line 81: ,fnd_date.date_to_canonical(pay_magtape_generic.get_parameter_value('REPORTED_DATE'))

77: ,choi.org_information2 corp_number
78: ,'BP_NUMBER=P'
79: ,hoi.org_information2 bp_number
80: ,'REPORTED_DATE=P'
81: ,fnd_date.date_to_canonical(pay_magtape_generic.get_parameter_value('REPORTED_DATE'))
82: ,'CHARACTER_TYPE=P'
83: ,'101' character_type
84: ,'REPORTING_PERIOD_P=P'
85: ,'1' reporting_period

Line 87: ,nvl(pay_magtape_generic.get_parameter_value('HOME_TAX_ID'), ' ')

83: ,'101' character_type
84: ,'REPORTING_PERIOD_P=P'
85: ,'1' reporting_period
86: ,'HOME_TAX_ID=P'
87: ,nvl(pay_magtape_generic.get_parameter_value('HOME_TAX_ID'), ' ')
88: FROM hr_organization_information hoi
89: ,hr_organization_information ihoi
90: ,hr_organization_information choi
91: ,hr_organization_units hou

Line 93: WHERE hou.organization_id = pay_magtape_generic.get_parameter_value('PRIMARY_BP_ID')

89: ,hr_organization_information ihoi
90: ,hr_organization_information choi
91: ,hr_organization_units hou
92: ,hr_locations_all hla
93: WHERE hou.organization_id = pay_magtape_generic.get_parameter_value('PRIMARY_BP_ID')
94: and hou.organization_id = hoi.organization_id
95: and hoi.org_information_context = 'KR_BUSINESS_PLACE_REGISTRATION'
96: and hou.organization_id = ihoi.organization_id
97: and ihoi.org_information_context = 'KR_INCOME_TAX_OFFICE'

Line 108: and xppa.effective_date between pay_magtape_generic.get_parameter_value('START_DATE')

104: from pay_assignment_actions xpaa
105: ,pay_payroll_actions xppa
106: where xppa.action_type = 'X'
107: and xppa.action_status = 'C'
108: and xppa.effective_date between pay_magtape_generic.get_parameter_value('START_DATE')
109: and pay_magtape_generic.get_parameter_value('END_DATE')
110: and xppa.payroll_action_id = xpaa.payroll_action_id
111: --Bug 5069923
112: and xppa.payroll_action_id = nvl(pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID'),xpaa.payroll_action_id) --Bug 5069923

Line 109: and pay_magtape_generic.get_parameter_value('END_DATE')

105: ,pay_payroll_actions xppa
106: where xppa.action_type = 'X'
107: and xppa.action_status = 'C'
108: and xppa.effective_date between pay_magtape_generic.get_parameter_value('START_DATE')
109: and pay_magtape_generic.get_parameter_value('END_DATE')
110: and xppa.payroll_action_id = xpaa.payroll_action_id
111: --Bug 5069923
112: and xppa.payroll_action_id = nvl(pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID'),xpaa.payroll_action_id) --Bug 5069923
113: --Bug 5069923

Line 112: and xppa.payroll_action_id = nvl(pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID'),xpaa.payroll_action_id) --Bug 5069923

108: and xppa.effective_date between pay_magtape_generic.get_parameter_value('START_DATE')
109: and pay_magtape_generic.get_parameter_value('END_DATE')
110: and xppa.payroll_action_id = xpaa.payroll_action_id
111: --Bug 5069923
112: and xppa.payroll_action_id = nvl(pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID'),xpaa.payroll_action_id) --Bug 5069923
113: --Bug 5069923
114: and ( (pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID') is null)
115: or (hr_assignment_set.assignment_in_set(pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID'), xpaa.assignment_id) = 'Y')
116: )

Line 114: and ( (pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID') is null)

110: and xppa.payroll_action_id = xpaa.payroll_action_id
111: --Bug 5069923
112: and xppa.payroll_action_id = nvl(pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID'),xpaa.payroll_action_id) --Bug 5069923
113: --Bug 5069923
114: and ( (pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID') is null)
115: or (hr_assignment_set.assignment_in_set(pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID'), xpaa.assignment_id) = 'Y')
116: )
117: and xpaa.action_status = 'C'
118: and xppa.report_type = 'KR_SEP'

Line 115: or (hr_assignment_set.assignment_in_set(pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID'), xpaa.assignment_id) = 'Y')

111: --Bug 5069923
112: and xppa.payroll_action_id = nvl(pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID'),xpaa.payroll_action_id) --Bug 5069923
113: --Bug 5069923
114: and ( (pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID') is null)
115: or (hr_assignment_set.assignment_in_set(pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID'), xpaa.assignment_id) = 'Y')
116: )
117: and xpaa.action_status = 'C'
118: and xppa.report_type = 'KR_SEP'
119: and xppa.report_category = 'KR_SEP'

Line 140: pay_magtape_generic.get_parameter_value('START_DATE')

136: WHERE xppa.action_type = 'X'
137: and xppa.action_status = 'C'
138: and xppa.effective_date between
139: -- Bug 4253329
140: pay_magtape_generic.get_parameter_value('START_DATE')
141: -- End of 4253329
142: and pay_magtape_generic.get_parameter_value('END_DATE')
143: and xppa.payroll_action_id = xpaa.payroll_action_id
144: --Bug 5069923

Line 142: and pay_magtape_generic.get_parameter_value('END_DATE')

138: and xppa.effective_date between
139: -- Bug 4253329
140: pay_magtape_generic.get_parameter_value('START_DATE')
141: -- End of 4253329
142: and pay_magtape_generic.get_parameter_value('END_DATE')
143: and xppa.payroll_action_id = xpaa.payroll_action_id
144: --Bug 5069923
145: and xppa.payroll_action_id = nvl(pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID'),xpaa.payroll_action_id)
146: --Bug 5069923

Line 145: and xppa.payroll_action_id = nvl(pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID'),xpaa.payroll_action_id)

141: -- End of 4253329
142: and pay_magtape_generic.get_parameter_value('END_DATE')
143: and xppa.payroll_action_id = xpaa.payroll_action_id
144: --Bug 5069923
145: and xppa.payroll_action_id = nvl(pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID'),xpaa.payroll_action_id)
146: --Bug 5069923
147: and ( (pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID') is null)
148: or (hr_assignment_set.assignment_in_set(pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID'), xpaa.assignment_id) = 'Y')
149: )

Line 147: and ( (pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID') is null)

143: and xppa.payroll_action_id = xpaa.payroll_action_id
144: --Bug 5069923
145: and xppa.payroll_action_id = nvl(pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID'),xpaa.payroll_action_id)
146: --Bug 5069923
147: and ( (pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID') is null)
148: or (hr_assignment_set.assignment_in_set(pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID'), xpaa.assignment_id) = 'Y')
149: )
150: and xpaa.action_status = 'C'
151: and xppa.report_type = 'KR_SEP'

Line 148: or (hr_assignment_set.assignment_in_set(pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID'), xpaa.assignment_id) = 'Y')

144: --Bug 5069923
145: and xppa.payroll_action_id = nvl(pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID'),xpaa.payroll_action_id)
146: --Bug 5069923
147: and ( (pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID') is null)
148: or (hr_assignment_set.assignment_in_set(pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID'), xpaa.assignment_id) = 'Y')
149: )
150: and xpaa.action_status = 'C'
151: and xppa.report_type = 'KR_SEP'
152: --Bug 5069923

Line 153: and ( (pay_magtape_generic.get_parameter_value('REPORT_FOR')='A')

149: )
150: and xpaa.action_status = 'C'
151: and xppa.report_type = 'KR_SEP'
152: --Bug 5069923
153: and ( (pay_magtape_generic.get_parameter_value('REPORT_FOR')='A')
154: or ( (hoi.organization_id in ( select posev.ORGANIZATION_ID_child
155: from PER_ORG_STRUCTURE_ELEMENTS posev
156: where posev.org_structure_version_id=(pay_magtape_generic.get_parameter_value('ORG_STRUC_VERSION_ID'))
157: and exists (select null

Line 156: where posev.org_structure_version_id=(pay_magtape_generic.get_parameter_value('ORG_STRUC_VERSION_ID'))

152: --Bug 5069923
153: and ( (pay_magtape_generic.get_parameter_value('REPORT_FOR')='A')
154: or ( (hoi.organization_id in ( select posev.ORGANIZATION_ID_child
155: from PER_ORG_STRUCTURE_ELEMENTS posev
156: where posev.org_structure_version_id=(pay_magtape_generic.get_parameter_value('ORG_STRUC_VERSION_ID'))
157: and exists (select null
158: from hr_organization_information
159: where organization_id = posev.ORGANIZATION_ID_child
160: and org_information_context = 'CLASS'

Line 163: start with ORGANIZATION_ID_PARENT = (decode(pay_magtape_generic.get_parameter_value('REPORT_FOR'),'S',null,'SUB',pay_magtape_generic.get_parameter_value('PRIMARY_BP_ID')))

159: where organization_id = posev.ORGANIZATION_ID_child
160: and org_information_context = 'CLASS'
161: and org_information1 = 'KR_BUSINESS_PLACE'
162: )
163: start with ORGANIZATION_ID_PARENT = (decode(pay_magtape_generic.get_parameter_value('REPORT_FOR'),'S',null,'SUB',pay_magtape_generic.get_parameter_value('PRIMARY_BP_ID')))
164: connect by prior ORGANIZATION_ID_child = ORGANIZATION_ID_PARENT
165: )
166: )
167: or (hoi.organization_id = pay_magtape_generic.get_parameter_value('PRIMARY_BP_ID')

Line 167: or (hoi.organization_id = pay_magtape_generic.get_parameter_value('PRIMARY_BP_ID')

163: start with ORGANIZATION_ID_PARENT = (decode(pay_magtape_generic.get_parameter_value('REPORT_FOR'),'S',null,'SUB',pay_magtape_generic.get_parameter_value('PRIMARY_BP_ID')))
164: connect by prior ORGANIZATION_ID_child = ORGANIZATION_ID_PARENT
165: )
166: )
167: or (hoi.organization_id = pay_magtape_generic.get_parameter_value('PRIMARY_BP_ID')
168: )
169: )
170: )
171: and hoi.organization_id = xpaa.tax_unit_id

Line 175: and hoi.org_information10 = pay_magtape_generic.get_parameter_value('CORPORATION_ID')

171: and hoi.organization_id = xpaa.tax_unit_id
172: and hoi.org_information_context = 'KR_BUSINESS_PLACE_REGISTRATION'
173: and hoi.organization_id = ihoi.organization_id
174: and ihoi.org_information_context = 'KR_INCOME_TAX_OFFICE'
175: and hoi.org_information10 = pay_magtape_generic.get_parameter_value('CORPORATION_ID')
176: and xppa.business_group_id = pay_magtape_generic.get_parameter_value('BUSINESS_GROUP_ID')
177: order by hoi.org_information2;
178:
179: cursor c_sep_tax_B_summary

Line 176: and xppa.business_group_id = pay_magtape_generic.get_parameter_value('BUSINESS_GROUP_ID')

172: and hoi.org_information_context = 'KR_BUSINESS_PLACE_REGISTRATION'
173: and hoi.organization_id = ihoi.organization_id
174: and ihoi.org_information_context = 'KR_INCOME_TAX_OFFICE'
175: and hoi.org_information10 = pay_magtape_generic.get_parameter_value('CORPORATION_ID')
176: and xppa.business_group_id = pay_magtape_generic.get_parameter_value('BUSINESS_GROUP_ID')
177: order by hoi.org_information2;
178:
179: cursor c_sep_tax_B_summary
180: is

Line 206: pay_magtape_generic.get_parameter_value('START_DATE')

202: WHERE xppa.action_type = 'X'
203: and xppa.action_status = 'C'
204: and xppa.effective_date between
205: -- Bug 4253329
206: pay_magtape_generic.get_parameter_value('START_DATE')
207: -- End of 4253329
208: and pay_magtape_generic.get_parameter_value('END_DATE')
209: and xppa.payroll_action_id = xpaa.payroll_action_id
210: --Bug 5069923

Line 208: and pay_magtape_generic.get_parameter_value('END_DATE')

204: and xppa.effective_date between
205: -- Bug 4253329
206: pay_magtape_generic.get_parameter_value('START_DATE')
207: -- End of 4253329
208: and pay_magtape_generic.get_parameter_value('END_DATE')
209: and xppa.payroll_action_id = xpaa.payroll_action_id
210: --Bug 5069923
211: and xppa.payroll_action_id = nvl(pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID'),xpaa.payroll_action_id)
212: and xpaa.action_status = 'C'

Line 211: and xppa.payroll_action_id = nvl(pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID'),xpaa.payroll_action_id)

207: -- End of 4253329
208: and pay_magtape_generic.get_parameter_value('END_DATE')
209: and xppa.payroll_action_id = xpaa.payroll_action_id
210: --Bug 5069923
211: and xppa.payroll_action_id = nvl(pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID'),xpaa.payroll_action_id)
212: and xpaa.action_status = 'C'
213: and xppa.report_type = 'KR_SEP'
214: and hoi.organization_id = xpaa.tax_unit_id
215: and hoi.org_information_context = 'KR_BUSINESS_PLACE_REGISTRATION'

Line 218: and ihoi.org_information9 = pay_magtape_generic.get_parameter_value('TAX_OFFICE_CODE')

214: and hoi.organization_id = xpaa.tax_unit_id
215: and hoi.org_information_context = 'KR_BUSINESS_PLACE_REGISTRATION'
216: and hoi.organization_id = ihoi.organization_id
217: and ihoi.org_information_context = 'KR_INCOME_TAX_OFFICE'
218: and ihoi.org_information9 = pay_magtape_generic.get_parameter_value('TAX_OFFICE_CODE')
219: and hoi.org_information2 = pay_magtape_generic.get_parameter_value('BP_NUMBER')
220: and hoi.org_information10 = pay_magtape_generic.get_parameter_value('CORPORATION_ID')
221: and hoi.organization_id = hou.organization_id
222: and hou.business_group_id = pay_magtape_generic.get_parameter_value('BUSINESS_GROUP_ID')

Line 219: and hoi.org_information2 = pay_magtape_generic.get_parameter_value('BP_NUMBER')

215: and hoi.org_information_context = 'KR_BUSINESS_PLACE_REGISTRATION'
216: and hoi.organization_id = ihoi.organization_id
217: and ihoi.org_information_context = 'KR_INCOME_TAX_OFFICE'
218: and ihoi.org_information9 = pay_magtape_generic.get_parameter_value('TAX_OFFICE_CODE')
219: and hoi.org_information2 = pay_magtape_generic.get_parameter_value('BP_NUMBER')
220: and hoi.org_information10 = pay_magtape_generic.get_parameter_value('CORPORATION_ID')
221: and hoi.organization_id = hou.organization_id
222: and hou.business_group_id = pay_magtape_generic.get_parameter_value('BUSINESS_GROUP_ID')
223: and fai.user_entity_id = fue.user_entity_id

Line 220: and hoi.org_information10 = pay_magtape_generic.get_parameter_value('CORPORATION_ID')

216: and hoi.organization_id = ihoi.organization_id
217: and ihoi.org_information_context = 'KR_INCOME_TAX_OFFICE'
218: and ihoi.org_information9 = pay_magtape_generic.get_parameter_value('TAX_OFFICE_CODE')
219: and hoi.org_information2 = pay_magtape_generic.get_parameter_value('BP_NUMBER')
220: and hoi.org_information10 = pay_magtape_generic.get_parameter_value('CORPORATION_ID')
221: and hoi.organization_id = hou.organization_id
222: and hou.business_group_id = pay_magtape_generic.get_parameter_value('BUSINESS_GROUP_ID')
223: and fai.user_entity_id = fue.user_entity_id
224: and fue.user_entity_name IN ('A_GROSS_ITAX_ASG_RUN',

Line 222: and hou.business_group_id = pay_magtape_generic.get_parameter_value('BUSINESS_GROUP_ID')

218: and ihoi.org_information9 = pay_magtape_generic.get_parameter_value('TAX_OFFICE_CODE')
219: and hoi.org_information2 = pay_magtape_generic.get_parameter_value('BP_NUMBER')
220: and hoi.org_information10 = pay_magtape_generic.get_parameter_value('CORPORATION_ID')
221: and hoi.organization_id = hou.organization_id
222: and hou.business_group_id = pay_magtape_generic.get_parameter_value('BUSINESS_GROUP_ID')
223: and fai.user_entity_id = fue.user_entity_id
224: and fue.user_entity_name IN ('A_GROSS_ITAX_ASG_RUN',
225: 'A_GROSS_STAX_ASG_RUN',
226: 'A_GROSS_RTAX_ASG_RUN',

Line 231: and ( (pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID') is null)

227: 'A_TAXABLE_EARNINGS_WI_PREV_ASG_RUN',
228: 'X_KR_EMP_NAME',
229: 'X_KR_PREV_BP_NUMBER')
230: --Bug 5069923
231: and ( (pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID') is null)
232: or (hr_assignment_set.assignment_in_set(pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID'), xpaa.assignment_id) = 'Y')
233: )
234: and fai.context1= xpaa.assignment_action_id
235: -- 3627111

Line 232: or (hr_assignment_set.assignment_in_set(pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID'), xpaa.assignment_id) = 'Y')

228: 'X_KR_EMP_NAME',
229: 'X_KR_PREV_BP_NUMBER')
230: --Bug 5069923
231: and ( (pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID') is null)
232: or (hr_assignment_set.assignment_in_set(pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID'), xpaa.assignment_id) = 'Y')
233: )
234: and fai.context1= xpaa.assignment_action_id
235: -- 3627111
236: and not exists ( select 'x'

Line 251: ,pay_magtape_generic.get_parameter_value('REPORTING_PERIOD')

247: is
248: SELECT 'ASSIGNMENT_ACTION_ID=C'
249: ,max(xpaa.assignment_action_id)
250: ,'REPORTING_PERIOD=P'
251: ,pay_magtape_generic.get_parameter_value('REPORTING_PERIOD')
252: FROM pay_assignment_actions xpaa
253: ,pay_payroll_actions xppa
254: ,hr_organization_information hoi
255: ,hr_organization_information ihoi

Line 261: pay_magtape_generic.get_parameter_value('START_DATE')

257: WHERE xppa.action_type = 'X'
258: and xppa.action_status = 'C'
259: and xppa.effective_date between
260: -- Bug 4253329
261: pay_magtape_generic.get_parameter_value('START_DATE')
262: -- End of 4253329
263: and pay_magtape_generic.get_parameter_value('END_DATE')
264: and xppa.payroll_action_id = xpaa.payroll_action_id
265: --Bug 5069923

Line 263: and pay_magtape_generic.get_parameter_value('END_DATE')

259: and xppa.effective_date between
260: -- Bug 4253329
261: pay_magtape_generic.get_parameter_value('START_DATE')
262: -- End of 4253329
263: and pay_magtape_generic.get_parameter_value('END_DATE')
264: and xppa.payroll_action_id = xpaa.payroll_action_id
265: --Bug 5069923
266: and xppa.payroll_action_id = nvl(pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID'),xpaa.payroll_action_id)
267: and xpaa.action_status = 'C'

Line 266: and xppa.payroll_action_id = nvl(pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID'),xpaa.payroll_action_id)

262: -- End of 4253329
263: and pay_magtape_generic.get_parameter_value('END_DATE')
264: and xppa.payroll_action_id = xpaa.payroll_action_id
265: --Bug 5069923
266: and xppa.payroll_action_id = nvl(pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID'),xpaa.payroll_action_id)
267: and xpaa.action_status = 'C'
268: and xppa.report_type = 'KR_SEP'
269: and hoi.organization_id = xpaa.tax_unit_id
270: and hoi.org_information_context = 'KR_BUSINESS_PLACE_REGISTRATION'

Line 273: and ( (pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID') is null)

269: and hoi.organization_id = xpaa.tax_unit_id
270: and hoi.org_information_context = 'KR_BUSINESS_PLACE_REGISTRATION'
271: and hoi.organization_id = ihoi.organization_id
272: --Bug 5069923
273: and ( (pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID') is null)
274: or (hr_assignment_set.assignment_in_set(pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID'), xpaa.assignment_id) = 'Y')
275: )
276: and ihoi.org_information_context = 'KR_INCOME_TAX_OFFICE'
277: and ihoi.org_information9 = pay_magtape_generic.get_parameter_value('TAX_OFFICE_CODE')

Line 274: or (hr_assignment_set.assignment_in_set(pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID'), xpaa.assignment_id) = 'Y')

270: and hoi.org_information_context = 'KR_BUSINESS_PLACE_REGISTRATION'
271: and hoi.organization_id = ihoi.organization_id
272: --Bug 5069923
273: and ( (pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID') is null)
274: or (hr_assignment_set.assignment_in_set(pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID'), xpaa.assignment_id) = 'Y')
275: )
276: and ihoi.org_information_context = 'KR_INCOME_TAX_OFFICE'
277: and ihoi.org_information9 = pay_magtape_generic.get_parameter_value('TAX_OFFICE_CODE')
278: and hoi.org_information2 = pay_magtape_generic.get_parameter_value('BP_NUMBER')

Line 277: and ihoi.org_information9 = pay_magtape_generic.get_parameter_value('TAX_OFFICE_CODE')

273: and ( (pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID') is null)
274: or (hr_assignment_set.assignment_in_set(pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID'), xpaa.assignment_id) = 'Y')
275: )
276: and ihoi.org_information_context = 'KR_INCOME_TAX_OFFICE'
277: and ihoi.org_information9 = pay_magtape_generic.get_parameter_value('TAX_OFFICE_CODE')
278: and hoi.org_information2 = pay_magtape_generic.get_parameter_value('BP_NUMBER')
279: and hoi.org_information10 = pay_magtape_generic.get_parameter_value('CORPORATION_ID')
280: and hoi.organization_id = hou.organization_id
281: and hou.business_group_id = pay_magtape_generic.get_parameter_value('BUSINESS_GROUP_ID');

Line 278: and hoi.org_information2 = pay_magtape_generic.get_parameter_value('BP_NUMBER')

274: or (hr_assignment_set.assignment_in_set(pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID'), xpaa.assignment_id) = 'Y')
275: )
276: and ihoi.org_information_context = 'KR_INCOME_TAX_OFFICE'
277: and ihoi.org_information9 = pay_magtape_generic.get_parameter_value('TAX_OFFICE_CODE')
278: and hoi.org_information2 = pay_magtape_generic.get_parameter_value('BP_NUMBER')
279: and hoi.org_information10 = pay_magtape_generic.get_parameter_value('CORPORATION_ID')
280: and hoi.organization_id = hou.organization_id
281: and hou.business_group_id = pay_magtape_generic.get_parameter_value('BUSINESS_GROUP_ID');
282:

Line 279: and hoi.org_information10 = pay_magtape_generic.get_parameter_value('CORPORATION_ID')

275: )
276: and ihoi.org_information_context = 'KR_INCOME_TAX_OFFICE'
277: and ihoi.org_information9 = pay_magtape_generic.get_parameter_value('TAX_OFFICE_CODE')
278: and hoi.org_information2 = pay_magtape_generic.get_parameter_value('BP_NUMBER')
279: and hoi.org_information10 = pay_magtape_generic.get_parameter_value('CORPORATION_ID')
280: and hoi.organization_id = hou.organization_id
281: and hou.business_group_id = pay_magtape_generic.get_parameter_value('BUSINESS_GROUP_ID');
282:
283:

Line 281: and hou.business_group_id = pay_magtape_generic.get_parameter_value('BUSINESS_GROUP_ID');

277: and ihoi.org_information9 = pay_magtape_generic.get_parameter_value('TAX_OFFICE_CODE')
278: and hoi.org_information2 = pay_magtape_generic.get_parameter_value('BP_NUMBER')
279: and hoi.org_information10 = pay_magtape_generic.get_parameter_value('CORPORATION_ID')
280: and hoi.organization_id = hou.organization_id
281: and hou.business_group_id = pay_magtape_generic.get_parameter_value('BUSINESS_GROUP_ID');
282:
283:
284: cursor c_sep_tax_C
285: is

Line 297: ,fnd_date.date_to_canonical(pay_magtape_generic.get_parameter_value('START_DATE'))

293: ,xpaa.assignment_id
294: ,'PREVIOUS_EMP_COUNT=P'
295: ,nvl(pay_kr_spay_efile_fun_pkg.get_prev_emp_count(xpaa.assignment_action_id),0)
296: ,'SRS_START_DATE=P'
297: ,fnd_date.date_to_canonical(pay_magtape_generic.get_parameter_value('START_DATE'))
298: ,'SRS_END_DATE=P'
299: ,fnd_date.date_to_canonical(pay_magtape_generic.get_parameter_value('END_DATE'))
300: -- Bug 4201616
301: ,'RUN_TYPE_NAME=P'

Line 299: ,fnd_date.date_to_canonical(pay_magtape_generic.get_parameter_value('END_DATE'))

295: ,nvl(pay_kr_spay_efile_fun_pkg.get_prev_emp_count(xpaa.assignment_action_id),0)
296: ,'SRS_START_DATE=P'
297: ,fnd_date.date_to_canonical(pay_magtape_generic.get_parameter_value('START_DATE'))
298: ,'SRS_END_DATE=P'
299: ,fnd_date.date_to_canonical(pay_magtape_generic.get_parameter_value('END_DATE'))
300: -- Bug 4201616
301: ,'RUN_TYPE_NAME=P'
302: ,prt.run_type_name
303: ,'PAYROLL_EFFECTIVE_DATE=P'

Line 328: pay_magtape_generic.get_parameter_value('START_DATE')

324: WHERE xppa.action_type = 'X'
325: and xppa.action_status = 'C'
326: and xppa.effective_date between
327: -- Bug 4253329
328: pay_magtape_generic.get_parameter_value('START_DATE')
329: -- End of 4253329
330: and pay_magtape_generic.get_parameter_value('END_DATE')
331: and xppa.payroll_action_id = xpaa.payroll_action_id
332: --Bug 5069923

Line 330: and pay_magtape_generic.get_parameter_value('END_DATE')

326: and xppa.effective_date between
327: -- Bug 4253329
328: pay_magtape_generic.get_parameter_value('START_DATE')
329: -- End of 4253329
330: and pay_magtape_generic.get_parameter_value('END_DATE')
331: and xppa.payroll_action_id = xpaa.payroll_action_id
332: --Bug 5069923
333: and xppa.payroll_action_id = nvl(pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID'),xpaa.payroll_action_id)
334: and xpaa.action_status = 'C'

Line 333: and xppa.payroll_action_id = nvl(pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID'),xpaa.payroll_action_id)

329: -- End of 4253329
330: and pay_magtape_generic.get_parameter_value('END_DATE')
331: and xppa.payroll_action_id = xpaa.payroll_action_id
332: --Bug 5069923
333: and xppa.payroll_action_id = nvl(pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID'),xpaa.payroll_action_id)
334: and xpaa.action_status = 'C'
335: and xppa.report_type = 'KR_SEP'
336: -- Bug 4201616
337: and paa.action_status = 'C'

Line 347: and ihoi.org_information9 = pay_magtape_generic.get_parameter_value('TAX_OFFICE_CODE')

343: and hoi.organization_id = xpaa.tax_unit_id
344: and hoi.org_information_context = 'KR_BUSINESS_PLACE_REGISTRATION'
345: and hoi.organization_id = ihoi.organization_id
346: and ihoi.org_information_context = 'KR_INCOME_TAX_OFFICE'
347: and ihoi.org_information9 = pay_magtape_generic.get_parameter_value('TAX_OFFICE_CODE')
348: and hoi.org_information2 = pay_magtape_generic.get_parameter_value('BP_NUMBER')
349: and hoi.org_information10 = pay_magtape_generic.get_parameter_value('CORPORATION_ID')
350: and hoi.organization_id = hou.organization_id
351: --Bug 5069923

Line 348: and hoi.org_information2 = pay_magtape_generic.get_parameter_value('BP_NUMBER')

344: and hoi.org_information_context = 'KR_BUSINESS_PLACE_REGISTRATION'
345: and hoi.organization_id = ihoi.organization_id
346: and ihoi.org_information_context = 'KR_INCOME_TAX_OFFICE'
347: and ihoi.org_information9 = pay_magtape_generic.get_parameter_value('TAX_OFFICE_CODE')
348: and hoi.org_information2 = pay_magtape_generic.get_parameter_value('BP_NUMBER')
349: and hoi.org_information10 = pay_magtape_generic.get_parameter_value('CORPORATION_ID')
350: and hoi.organization_id = hou.organization_id
351: --Bug 5069923
352: and ( (pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID') is null)

Line 349: and hoi.org_information10 = pay_magtape_generic.get_parameter_value('CORPORATION_ID')

345: and hoi.organization_id = ihoi.organization_id
346: and ihoi.org_information_context = 'KR_INCOME_TAX_OFFICE'
347: and ihoi.org_information9 = pay_magtape_generic.get_parameter_value('TAX_OFFICE_CODE')
348: and hoi.org_information2 = pay_magtape_generic.get_parameter_value('BP_NUMBER')
349: and hoi.org_information10 = pay_magtape_generic.get_parameter_value('CORPORATION_ID')
350: and hoi.organization_id = hou.organization_id
351: --Bug 5069923
352: and ( (pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID') is null)
353: or (hr_assignment_set.assignment_in_set(pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID'), xpaa.assignment_id) = 'Y')

Line 352: and ( (pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID') is null)

348: and hoi.org_information2 = pay_magtape_generic.get_parameter_value('BP_NUMBER')
349: and hoi.org_information10 = pay_magtape_generic.get_parameter_value('CORPORATION_ID')
350: and hoi.organization_id = hou.organization_id
351: --Bug 5069923
352: and ( (pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID') is null)
353: or (hr_assignment_set.assignment_in_set(pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID'), xpaa.assignment_id) = 'Y')
354: )
355: and hou.business_group_id = pay_magtape_generic.get_parameter_value('BUSINESS_GROUP_ID')
356: and fue.user_entity_name in ('A_TAXABLE_EARNINGS_WI_PREV_ASG_RUN')

Line 353: or (hr_assignment_set.assignment_in_set(pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID'), xpaa.assignment_id) = 'Y')

349: and hoi.org_information10 = pay_magtape_generic.get_parameter_value('CORPORATION_ID')
350: and hoi.organization_id = hou.organization_id
351: --Bug 5069923
352: and ( (pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID') is null)
353: or (hr_assignment_set.assignment_in_set(pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID'), xpaa.assignment_id) = 'Y')
354: )
355: and hou.business_group_id = pay_magtape_generic.get_parameter_value('BUSINESS_GROUP_ID')
356: and fue.user_entity_name in ('A_TAXABLE_EARNINGS_WI_PREV_ASG_RUN')
357: and fai.user_entity_id = fue.user_entity_id

Line 355: and hou.business_group_id = pay_magtape_generic.get_parameter_value('BUSINESS_GROUP_ID')

351: --Bug 5069923
352: and ( (pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID') is null)
353: or (hr_assignment_set.assignment_in_set(pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID'), xpaa.assignment_id) = 'Y')
354: )
355: and hou.business_group_id = pay_magtape_generic.get_parameter_value('BUSINESS_GROUP_ID')
356: and fue.user_entity_name in ('A_TAXABLE_EARNINGS_WI_PREV_ASG_RUN')
357: and fai.user_entity_id = fue.user_entity_id
358: and fai.context1 = xpaa.assignment_action_id
359: and prt.run_type_id = paa.run_type_id -- Bug 4201616

Line 397: and fai.context1 = pay_magtape_generic.get_parameter_value('ASSIGNMENT_ACTION_ID')

393: and fue.legislation_code = 'KR'
394: and fue.route_id = frc.route_id
395: and frc.context_id = fc.context_id
396: and fc.context_name = 'ELEMENT_ENTRY_ID'
397: and fai.context1 = pay_magtape_generic.get_parameter_value('ASSIGNMENT_ACTION_ID')
398: and fai.user_entity_id = fue.user_entity_id
399: and fac.archive_item_id = fai.archive_item_id
400: and fac.context_id = fc.context_id
401: order by