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'
85: ,'1' reporting_period

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

83: ,'101' character_type
84: ,'REPORTING_PERIOD=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 205: pay_magtape_generic.get_parameter_value('START_DATE')

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 258: pay_magtape_generic.get_parameter_value('START_DATE')

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 321: pay_magtape_generic.get_parameter_value('START_DATE')

317: WHERE xppa.action_type = 'X'
318: and xppa.action_status = 'C'
319: and xppa.effective_date between
320: -- Bug 4253329
321: pay_magtape_generic.get_parameter_value('START_DATE')
322: -- End of 4253329
323: and pay_magtape_generic.get_parameter_value('END_DATE')
324: and xppa.payroll_action_id = xpaa.payroll_action_id
325: --Bug 5069923

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

319: and xppa.effective_date between
320: -- Bug 4253329
321: pay_magtape_generic.get_parameter_value('START_DATE')
322: -- End of 4253329
323: and pay_magtape_generic.get_parameter_value('END_DATE')
324: and xppa.payroll_action_id = xpaa.payroll_action_id
325: --Bug 5069923
326: and xppa.payroll_action_id = nvl(pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID'),xpaa.payroll_action_id)
327: and xpaa.action_status = 'C'

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

322: -- End of 4253329
323: and pay_magtape_generic.get_parameter_value('END_DATE')
324: and xppa.payroll_action_id = xpaa.payroll_action_id
325: --Bug 5069923
326: and xppa.payroll_action_id = nvl(pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID'),xpaa.payroll_action_id)
327: and xpaa.action_status = 'C'
328: and xppa.report_type = 'KR_SEP'
329: -- Bug 4201616
330: and paa.action_status = 'C'

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

336: and hoi.organization_id = xpaa.tax_unit_id
337: and hoi.org_information_context = 'KR_BUSINESS_PLACE_REGISTRATION'
338: and hoi.organization_id = ihoi.organization_id
339: and ihoi.org_information_context = 'KR_INCOME_TAX_OFFICE'
340: and ihoi.org_information9 = pay_magtape_generic.get_parameter_value('TAX_OFFICE_CODE')
341: and hoi.org_information2 = pay_magtape_generic.get_parameter_value('BP_NUMBER')
342: and hoi.org_information10 = pay_magtape_generic.get_parameter_value('CORPORATION_ID')
343: and hoi.organization_id = hou.organization_id
344: --Bug 5069923

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

337: and hoi.org_information_context = 'KR_BUSINESS_PLACE_REGISTRATION'
338: and hoi.organization_id = ihoi.organization_id
339: and ihoi.org_information_context = 'KR_INCOME_TAX_OFFICE'
340: and ihoi.org_information9 = pay_magtape_generic.get_parameter_value('TAX_OFFICE_CODE')
341: and hoi.org_information2 = pay_magtape_generic.get_parameter_value('BP_NUMBER')
342: and hoi.org_information10 = pay_magtape_generic.get_parameter_value('CORPORATION_ID')
343: and hoi.organization_id = hou.organization_id
344: --Bug 5069923
345: and ( (pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID') is null)

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

338: and hoi.organization_id = ihoi.organization_id
339: and ihoi.org_information_context = 'KR_INCOME_TAX_OFFICE'
340: and ihoi.org_information9 = pay_magtape_generic.get_parameter_value('TAX_OFFICE_CODE')
341: and hoi.org_information2 = pay_magtape_generic.get_parameter_value('BP_NUMBER')
342: and hoi.org_information10 = pay_magtape_generic.get_parameter_value('CORPORATION_ID')
343: and hoi.organization_id = hou.organization_id
344: --Bug 5069923
345: and ( (pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID') is null)
346: or (hr_assignment_set.assignment_in_set(pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID'), xpaa.assignment_id) = 'Y')

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

341: and hoi.org_information2 = pay_magtape_generic.get_parameter_value('BP_NUMBER')
342: and hoi.org_information10 = pay_magtape_generic.get_parameter_value('CORPORATION_ID')
343: and hoi.organization_id = hou.organization_id
344: --Bug 5069923
345: and ( (pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID') is null)
346: or (hr_assignment_set.assignment_in_set(pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID'), xpaa.assignment_id) = 'Y')
347: )
348: and hou.business_group_id = pay_magtape_generic.get_parameter_value('BUSINESS_GROUP_ID')
349: and fue.user_entity_name in ('X_KR_EMP_NI','A_TAXABLE_EARNINGS_WI_PREV_ASG_RUN')

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

342: and hoi.org_information10 = pay_magtape_generic.get_parameter_value('CORPORATION_ID')
343: and hoi.organization_id = hou.organization_id
344: --Bug 5069923
345: and ( (pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID') is null)
346: or (hr_assignment_set.assignment_in_set(pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID'), xpaa.assignment_id) = 'Y')
347: )
348: and hou.business_group_id = pay_magtape_generic.get_parameter_value('BUSINESS_GROUP_ID')
349: and fue.user_entity_name in ('X_KR_EMP_NI','A_TAXABLE_EARNINGS_WI_PREV_ASG_RUN')
350: and fai.user_entity_id = fue.user_entity_id

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

344: --Bug 5069923
345: and ( (pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID') is null)
346: or (hr_assignment_set.assignment_in_set(pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID'), xpaa.assignment_id) = 'Y')
347: )
348: and hou.business_group_id = pay_magtape_generic.get_parameter_value('BUSINESS_GROUP_ID')
349: and fue.user_entity_name in ('X_KR_EMP_NI','A_TAXABLE_EARNINGS_WI_PREV_ASG_RUN')
350: and fai.user_entity_id = fue.user_entity_id
351: and fai.context1 = xpaa.assignment_action_id
352: and decode(fue.user_entity_name,'A_TAXABLE_EARNINGS_WI_PREV_ASG_RUN',fai.value) > 0

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

379: and fue.legislation_code = 'KR'
380: and fue.route_id = frc.route_id
381: and frc.context_id = fc.context_id
382: and fc.context_name = 'ELEMENT_ENTRY_ID'
383: and fai.context1 = pay_magtape_generic.get_parameter_value('ASSIGNMENT_ACTION_ID')
384: and fai.user_entity_id = fue.user_entity_id
385: and fac.archive_item_id = fai.archive_item_id
386: and fac.context_id = fc.context_id
387: order by