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

Line 64: ,pay_magtape_generic.get_parameter_value('REPORTED_DATE')

60: ,hoi.org_information10 corp_id
61: ,'BP_COUNT=P'
62: , g_bp_count
63: ,'REPORTED_DATE=P'
64: ,pay_magtape_generic.get_parameter_value('REPORTED_DATE')
65: FROM hr_organization_information hoi
66: ,hr_organization_information ihoi
67: ,hr_organization_information choi
68: ,hr_organization_units hou

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

66: ,hr_organization_information ihoi
67: ,hr_organization_information choi
68: ,hr_organization_units hou
69: ,hr_locations_all hla
70: WHERE hou.organization_id = pay_magtape_generic.get_parameter_value('PRIMARY_BP_ID')
71: and hou.business_group_id = pay_magtape_generic.get_parameter_value('BUSINESS_GROUP_ID')
72: and hou.organization_id = hoi.organization_id
73: and hoi.org_information_context = 'KR_BUSINESS_PLACE_REGISTRATION'
74: and hou.organization_id = ihoi.organization_id

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

67: ,hr_organization_information choi
68: ,hr_organization_units hou
69: ,hr_locations_all hla
70: WHERE hou.organization_id = pay_magtape_generic.get_parameter_value('PRIMARY_BP_ID')
71: and hou.business_group_id = pay_magtape_generic.get_parameter_value('BUSINESS_GROUP_ID')
72: and hou.organization_id = hoi.organization_id
73: and hoi.org_information_context = 'KR_BUSINESS_PLACE_REGISTRATION'
74: and hou.organization_id = ihoi.organization_id
75: and ihoi.org_information_context = 'KR_INCOME_TAX_OFFICE'

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

106: ,hr_organization_information choi
107: WHERE hoi.org_information_context = 'KR_BUSINESS_PLACE_REGISTRATION'
108: and hoi.organization_id = ihoi.organization_id
109: and ihoi.org_information_context = 'KR_INCOME_TAX_OFFICE'
110: and hoi.org_information10 = pay_magtape_generic.get_parameter_value('CORPORATION_ID')
111: --Bug 5069923
112: and (
113: (pay_magtape_generic.get_parameter_value('REPORT_FOR')='A')
114: or (

Line 113: (pay_magtape_generic.get_parameter_value('REPORT_FOR')='A')

109: and ihoi.org_information_context = 'KR_INCOME_TAX_OFFICE'
110: and hoi.org_information10 = pay_magtape_generic.get_parameter_value('CORPORATION_ID')
111: --Bug 5069923
112: and (
113: (pay_magtape_generic.get_parameter_value('REPORT_FOR')='A')
114: or (
115: (hoi.organization_id in (select
116: posev.ORGANIZATION_ID_child
117: from PER_ORG_STRUCTURE_ELEMENTS posev

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

114: or (
115: (hoi.organization_id in (select
116: posev.ORGANIZATION_ID_child
117: from PER_ORG_STRUCTURE_ELEMENTS posev
118: where posev.org_structure_version_id = (pay_magtape_generic.get_parameter_value('ORG_STRUC_VERSION_ID'))
119: and exists (
120: select null
121: from hr_organization_information
122: where organization_id = posev.ORGANIZATION_ID_child

Line 126: 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')))

122: where organization_id = posev.ORGANIZATION_ID_child
123: and org_information_context = 'CLASS'
124: and org_information1 = 'KR_BUSINESS_PLACE'
125: )
126: 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')))
127: connect by prior ORGANIZATION_ID_child = ORGANIZATION_ID_PARENT
128: )
129: )
130: or (hoi.organization_id = pay_magtape_generic.get_parameter_value('PRIMARY_BP_ID')

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

126: 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')))
127: connect by prior ORGANIZATION_ID_child = ORGANIZATION_ID_PARENT
128: )
129: )
130: or (hoi.organization_id = pay_magtape_generic.get_parameter_value('PRIMARY_BP_ID')
131: )
132: )
133: )
134: and choi.organization_id = to_number(hoi.org_information10)

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

140: ff_user_entities fue
141: where xppa.action_type = 'X'
142: and xppa.action_status = 'C'
143: --Bug 5069923
144: and xppa.payroll_action_id = nvl(pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID'),xpaa.payroll_action_id)
145: and xppa.effective_date between
146: to_date(pay_magtape_generic.get_parameter_value('TARGET_YEAR')||'0101','YYYYMMDD')
147: and to_date(pay_magtape_generic.get_parameter_value('TARGET_YEAR')||'1231','YYYYMMDD')
148: and xppa.payroll_action_id = xpaa.payroll_action_id

Line 146: to_date(pay_magtape_generic.get_parameter_value('TARGET_YEAR')||'0101','YYYYMMDD')

142: and xppa.action_status = 'C'
143: --Bug 5069923
144: and xppa.payroll_action_id = nvl(pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID'),xpaa.payroll_action_id)
145: and xppa.effective_date between
146: to_date(pay_magtape_generic.get_parameter_value('TARGET_YEAR')||'0101','YYYYMMDD')
147: and to_date(pay_magtape_generic.get_parameter_value('TARGET_YEAR')||'1231','YYYYMMDD')
148: and xppa.payroll_action_id = xpaa.payroll_action_id
149: and xpaa.action_status = 'C'
150: --Bug 5069923

Line 147: and to_date(pay_magtape_generic.get_parameter_value('TARGET_YEAR')||'1231','YYYYMMDD')

143: --Bug 5069923
144: and xppa.payroll_action_id = nvl(pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID'),xpaa.payroll_action_id)
145: and xppa.effective_date between
146: to_date(pay_magtape_generic.get_parameter_value('TARGET_YEAR')||'0101','YYYYMMDD')
147: and to_date(pay_magtape_generic.get_parameter_value('TARGET_YEAR')||'1231','YYYYMMDD')
148: and xppa.payroll_action_id = xpaa.payroll_action_id
149: and xpaa.action_status = 'C'
150: --Bug 5069923
151: and ( (pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID') is null)

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

147: and to_date(pay_magtape_generic.get_parameter_value('TARGET_YEAR')||'1231','YYYYMMDD')
148: and xppa.payroll_action_id = xpaa.payroll_action_id
149: and xpaa.action_status = 'C'
150: --Bug 5069923
151: and ( (pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID') is null)
152: or (hr_assignment_set.assignment_in_set(pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID'), xpaa.assignment_id) = 'Y')
153: )
154: and xppa.report_type = 'KR_SEP'
155: and xppa.business_group_id = pay_magtape_generic.get_parameter_value('BUSINESS_GROUP_ID')

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

148: and xppa.payroll_action_id = xpaa.payroll_action_id
149: and xpaa.action_status = 'C'
150: --Bug 5069923
151: and ( (pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID') is null)
152: or (hr_assignment_set.assignment_in_set(pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID'), xpaa.assignment_id) = 'Y')
153: )
154: and xppa.report_type = 'KR_SEP'
155: and xppa.business_group_id = pay_magtape_generic.get_parameter_value('BUSINESS_GROUP_ID')
156: and hoi.organization_id = xpaa.tax_unit_id

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

151: and ( (pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID') is null)
152: or (hr_assignment_set.assignment_in_set(pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID'), xpaa.assignment_id) = 'Y')
153: )
154: and xppa.report_type = 'KR_SEP'
155: and xppa.business_group_id = pay_magtape_generic.get_parameter_value('BUSINESS_GROUP_ID')
156: and hoi.organization_id = xpaa.tax_unit_id
157: and fue.user_entity_id = fai.user_entity_id
158: and fue.user_entity_name = 'A_NON_STAT_SEP_PAY_TAXABLE_EARNINGS_ASG_RUN'
159: and fue.legislation_code = 'KR'

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

202: ,ff_archive_items fai1
203: WHERE xppa.action_type = 'X'
204: and xppa.action_status = 'C'
205: --Bug 5069923
206: and xppa.payroll_action_id = nvl(pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID'),xpaa.payroll_action_id)
207: and xppa.effective_date between
208: to_date(pay_magtape_generic.get_parameter_value('TARGET_YEAR')||'0101','YYYYMMDD')
209: and to_date(pay_magtape_generic.get_parameter_value('TARGET_YEAR')||'1231','YYYYMMDD')
210: and xppa.payroll_action_id = xpaa.payroll_action_id

Line 208: to_date(pay_magtape_generic.get_parameter_value('TARGET_YEAR')||'0101','YYYYMMDD')

204: and xppa.action_status = 'C'
205: --Bug 5069923
206: and xppa.payroll_action_id = nvl(pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID'),xpaa.payroll_action_id)
207: and xppa.effective_date between
208: to_date(pay_magtape_generic.get_parameter_value('TARGET_YEAR')||'0101','YYYYMMDD')
209: and to_date(pay_magtape_generic.get_parameter_value('TARGET_YEAR')||'1231','YYYYMMDD')
210: and xppa.payroll_action_id = xpaa.payroll_action_id
211: and xpaa.action_status = 'C'
212: and xppa.report_type = 'KR_SEP'

Line 209: and to_date(pay_magtape_generic.get_parameter_value('TARGET_YEAR')||'1231','YYYYMMDD')

205: --Bug 5069923
206: and xppa.payroll_action_id = nvl(pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID'),xpaa.payroll_action_id)
207: and xppa.effective_date between
208: to_date(pay_magtape_generic.get_parameter_value('TARGET_YEAR')||'0101','YYYYMMDD')
209: and to_date(pay_magtape_generic.get_parameter_value('TARGET_YEAR')||'1231','YYYYMMDD')
210: and xppa.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

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 231: and ( (pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID') is null)

227: 'X_KR_PREV_BP_NUMBER',
228: 'A_NON_STAT_SEP_PAY_TAXABLE_EARNINGS_ASG_RUN')
229: and fai.context1 = xpaa.assignment_Action_id
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 fue1.user_entity_name = 'A_NON_STAT_SEP_PAY_TAXABLE_EARNINGS_ASG_RUN'
235: and fue1.legislation_code = 'KR'

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

228: 'A_NON_STAT_SEP_PAY_TAXABLE_EARNINGS_ASG_RUN')
229: and fai.context1 = xpaa.assignment_Action_id
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 fue1.user_entity_name = 'A_NON_STAT_SEP_PAY_TAXABLE_EARNINGS_ASG_RUN'
235: and fue1.legislation_code = 'KR'
236: and fai1.user_entity_id = fue1.user_entity_id

Line 249: fnd_date.date_to_canonical( to_date(pay_magtape_generic.get_parameter_value('TARGET_YEAR') || '0101',

245: *********************************************************/
246: cursor c_multiple_year -- 4095229
247: is
248: select 'START_DATE=P',
249: fnd_date.date_to_canonical( to_date(pay_magtape_generic.get_parameter_value('TARGET_YEAR') || '0101',
250: 'YYYYMMDD') ) start_date,
251: 'END_DATE=P',
252: fnd_date.date_to_canonical( to_date(pay_magtape_generic.get_parameter_value('TARGET_YEAR') || '1231',
253: 'YYYYMMDD') ) end_date

Line 252: fnd_date.date_to_canonical( to_date(pay_magtape_generic.get_parameter_value('TARGET_YEAR') || '1231',

248: select 'START_DATE=P',
249: fnd_date.date_to_canonical( to_date(pay_magtape_generic.get_parameter_value('TARGET_YEAR') || '0101',
250: 'YYYYMMDD') ) start_date,
251: 'END_DATE=P',
252: fnd_date.date_to_canonical( to_date(pay_magtape_generic.get_parameter_value('TARGET_YEAR') || '1231',
253: 'YYYYMMDD') ) end_date
254:
255: from dual;
256:

Line 291: between fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('START_DATE'))

287: ,ff_archive_items fai1
288: WHERE xppa.action_type = 'X'
289: and xppa.action_status = 'C'
290: and xppa.effective_date
291: between fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('START_DATE'))
292: and fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('END_DATE'))
293: and xppa.payroll_action_id = xpaa.payroll_action_id
294: --Bug 5069923
295: and xppa.payroll_action_id = nvl(pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID'),xpaa.payroll_action_id)

Line 292: and fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('END_DATE'))

288: WHERE xppa.action_type = 'X'
289: and xppa.action_status = 'C'
290: and xppa.effective_date
291: between fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('START_DATE'))
292: and fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('END_DATE'))
293: and xppa.payroll_action_id = xpaa.payroll_action_id
294: --Bug 5069923
295: and xppa.payroll_action_id = nvl(pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID'),xpaa.payroll_action_id)
296: and xpaa.action_status = 'C'

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

291: between fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('START_DATE'))
292: and fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('END_DATE'))
293: and xppa.payroll_action_id = xpaa.payroll_action_id
294: --Bug 5069923
295: and xppa.payroll_action_id = nvl(pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID'),xpaa.payroll_action_id)
296: and xpaa.action_status = 'C'
297: and xppa.report_type = 'KR_SEP'
298: and hoi.organization_id = xpaa.tax_unit_id
299: and hoi.org_information_context = 'KR_BUSINESS_PLACE_REGISTRATION'

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

296: and xpaa.action_status = 'C'
297: and xppa.report_type = 'KR_SEP'
298: and hoi.organization_id = xpaa.tax_unit_id
299: and hoi.org_information_context = 'KR_BUSINESS_PLACE_REGISTRATION'
300: and hoi.org_information2 = pay_magtape_generic.get_parameter_value('BP_NUMBER')
301: and hoi.org_information10 = pay_magtape_generic.get_parameter_value('CORPORATION_ID')
302: and hoi.organization_id = hou.organization_id
303: and hou.business_group_id = pay_magtape_generic.get_parameter_value('BUSINESS_GROUP_ID')
304: and fue.user_entity_name = 'A_NON_STAT_SEP_PAY_TAXABLE_EARNINGS_ASG_RUN'

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

297: and xppa.report_type = 'KR_SEP'
298: and hoi.organization_id = xpaa.tax_unit_id
299: and hoi.org_information_context = 'KR_BUSINESS_PLACE_REGISTRATION'
300: and hoi.org_information2 = pay_magtape_generic.get_parameter_value('BP_NUMBER')
301: and hoi.org_information10 = pay_magtape_generic.get_parameter_value('CORPORATION_ID')
302: and hoi.organization_id = hou.organization_id
303: and hou.business_group_id = pay_magtape_generic.get_parameter_value('BUSINESS_GROUP_ID')
304: and fue.user_entity_name = 'A_NON_STAT_SEP_PAY_TAXABLE_EARNINGS_ASG_RUN'
305: and fue.legislation_code = 'KR'

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

299: and hoi.org_information_context = 'KR_BUSINESS_PLACE_REGISTRATION'
300: and hoi.org_information2 = pay_magtape_generic.get_parameter_value('BP_NUMBER')
301: and hoi.org_information10 = pay_magtape_generic.get_parameter_value('CORPORATION_ID')
302: and hoi.organization_id = hou.organization_id
303: and hou.business_group_id = pay_magtape_generic.get_parameter_value('BUSINESS_GROUP_ID')
304: and fue.user_entity_name = 'A_NON_STAT_SEP_PAY_TAXABLE_EARNINGS_ASG_RUN'
305: and fue.legislation_code = 'KR'
306: and fai.user_entity_id = fue.user_entity_id
307: and fai.context1 = xpaa.assignment_action_id

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

305: and fue.legislation_code = 'KR'
306: and fai.user_entity_id = fue.user_entity_id
307: and fai.context1 = xpaa.assignment_action_id
308: --Bug 5069923
309: and ( (pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID') is null)
310: or (hr_assignment_set.assignment_in_set(pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID'), xpaa.assignment_id) = 'Y')
311: )
312: and fai.value > '0'
313: and fue1.user_entity_name = 'X_KR_EMP_NI'

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

306: and fai.user_entity_id = fue.user_entity_id
307: and fai.context1 = xpaa.assignment_action_id
308: --Bug 5069923
309: and ( (pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID') is null)
310: or (hr_assignment_set.assignment_in_set(pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID'), xpaa.assignment_id) = 'Y')
311: )
312: and fai.value > '0'
313: and fue1.user_entity_name = 'X_KR_EMP_NI'
314: and fai1.user_entity_id = fue1.user_entity_id

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

338: and fue.legislation_code = 'KR'
339: and fue.route_id = frc.route_id
340: and frc.context_id = fc.context_id
341: and fc.context_name = 'ELEMENT_ENTRY_ID'
342: and fai.context1 = pay_magtape_generic.get_parameter_value('ASSIGNMENT_ACTION_ID')
343: and fai.user_entity_id = fue.user_entity_id
344: and fac.archive_item_id = fai.archive_item_id
345: and fac.context_id = fc.context_id
346: order by