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 70: ,pay_magtape_generic.get_parameter_value('REPORTED_DATE')

66: ,hoi.org_information10 corp_id
67: ,'BP_COUNT=P'
68: , g_bp_count
69: ,'REPORTED_DATE=P'
70: ,pay_magtape_generic.get_parameter_value('REPORTED_DATE')
71: FROM hr_organization_information hoi
72: ,hr_organization_information ihoi
73: ,hr_organization_information choi
74: ,hr_organization_units hou

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

72: ,hr_organization_information ihoi
73: ,hr_organization_information choi
74: ,hr_organization_units hou
75: ,hr_locations_all hla
76: WHERE hou.organization_id = pay_magtape_generic.get_parameter_value('PRIMARY_BP_ID')
77: and hou.business_group_id = pay_magtape_generic.get_parameter_value('BUSINESS_GROUP_ID')
78: and hou.organization_id = hoi.organization_id
79: and hoi.org_information_context = 'KR_BUSINESS_PLACE_REGISTRATION'
80: and hou.organization_id = ihoi.organization_id

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

73: ,hr_organization_information choi
74: ,hr_organization_units hou
75: ,hr_locations_all hla
76: WHERE hou.organization_id = pay_magtape_generic.get_parameter_value('PRIMARY_BP_ID')
77: and hou.business_group_id = pay_magtape_generic.get_parameter_value('BUSINESS_GROUP_ID')
78: and hou.organization_id = hoi.organization_id
79: and hoi.org_information_context = 'KR_BUSINESS_PLACE_REGISTRATION'
80: and hou.organization_id = ihoi.organization_id
81: and ihoi.org_information_context = 'KR_INCOME_TAX_OFFICE'

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

112: ,hr_organization_information choi
113: WHERE hoi.org_information_context = 'KR_BUSINESS_PLACE_REGISTRATION'
114: and hoi.organization_id = ihoi.organization_id
115: and ihoi.org_information_context = 'KR_INCOME_TAX_OFFICE'
116: and hoi.org_information10 = pay_magtape_generic.get_parameter_value('CORPORATION_ID')
117: --Bug 5069923
118: and (
119: (pay_magtape_generic.get_parameter_value('REPORT_FOR')='A')
120: or (

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

115: and ihoi.org_information_context = 'KR_INCOME_TAX_OFFICE'
116: and hoi.org_information10 = pay_magtape_generic.get_parameter_value('CORPORATION_ID')
117: --Bug 5069923
118: and (
119: (pay_magtape_generic.get_parameter_value('REPORT_FOR')='A')
120: or (
121: (hoi.organization_id in (select
122: posev.ORGANIZATION_ID_child
123: from PER_ORG_STRUCTURE_ELEMENTS posev

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

120: or (
121: (hoi.organization_id in (select
122: posev.ORGANIZATION_ID_child
123: from PER_ORG_STRUCTURE_ELEMENTS posev
124: where posev.org_structure_version_id = (pay_magtape_generic.get_parameter_value('ORG_STRUC_VERSION_ID'))
125: and exists (
126: select null
127: from hr_organization_information
128: where organization_id = posev.ORGANIZATION_ID_child

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

128: where organization_id = posev.ORGANIZATION_ID_child
129: and org_information_context = 'CLASS'
130: and org_information1 = 'KR_BUSINESS_PLACE'
131: )
132: 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')))
133: connect by prior ORGANIZATION_ID_child = ORGANIZATION_ID_PARENT
134: )
135: )
136: or (hoi.organization_id = pay_magtape_generic.get_parameter_value('PRIMARY_BP_ID')

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

132: 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')))
133: connect by prior ORGANIZATION_ID_child = ORGANIZATION_ID_PARENT
134: )
135: )
136: or (hoi.organization_id = pay_magtape_generic.get_parameter_value('PRIMARY_BP_ID')
137: )
138: )
139: )
140: and choi.organization_id = to_number(hoi.org_information10)

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

146: ff_user_entities fue
147: where xppa.action_type = 'X'
148: and xppa.action_status = 'C'
149: --Bug 5069923
150: and xppa.payroll_action_id = nvl(pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID'),xpaa.payroll_action_id)
151: and xppa.effective_date between
152: to_date(pay_magtape_generic.get_parameter_value('TARGET_YEAR')||'0101','YYYYMMDD')
153: and to_date(pay_magtape_generic.get_parameter_value('TARGET_YEAR')||'1231','YYYYMMDD')
154: and xppa.payroll_action_id = xpaa.payroll_action_id

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

148: and xppa.action_status = 'C'
149: --Bug 5069923
150: and xppa.payroll_action_id = nvl(pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID'),xpaa.payroll_action_id)
151: and xppa.effective_date between
152: to_date(pay_magtape_generic.get_parameter_value('TARGET_YEAR')||'0101','YYYYMMDD')
153: and to_date(pay_magtape_generic.get_parameter_value('TARGET_YEAR')||'1231','YYYYMMDD')
154: and xppa.payroll_action_id = xpaa.payroll_action_id
155: and xpaa.action_status = 'C'
156: --Bug 5069923

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

149: --Bug 5069923
150: and xppa.payroll_action_id = nvl(pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID'),xpaa.payroll_action_id)
151: and xppa.effective_date between
152: to_date(pay_magtape_generic.get_parameter_value('TARGET_YEAR')||'0101','YYYYMMDD')
153: and to_date(pay_magtape_generic.get_parameter_value('TARGET_YEAR')||'1231','YYYYMMDD')
154: and xppa.payroll_action_id = xpaa.payroll_action_id
155: and xpaa.action_status = 'C'
156: --Bug 5069923
157: and ( (pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID') is null)

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

153: and to_date(pay_magtape_generic.get_parameter_value('TARGET_YEAR')||'1231','YYYYMMDD')
154: and xppa.payroll_action_id = xpaa.payroll_action_id
155: and xpaa.action_status = 'C'
156: --Bug 5069923
157: and ( (pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID') is null)
158: or (hr_assignment_set.assignment_in_set(pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID'), xpaa.assignment_id) = 'Y')
159: )
160: and xppa.report_type = 'KR_SEP'
161: and xppa.business_group_id = pay_magtape_generic.get_parameter_value('BUSINESS_GROUP_ID')

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

154: and xppa.payroll_action_id = xpaa.payroll_action_id
155: and xpaa.action_status = 'C'
156: --Bug 5069923
157: and ( (pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID') is null)
158: or (hr_assignment_set.assignment_in_set(pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID'), xpaa.assignment_id) = 'Y')
159: )
160: and xppa.report_type = 'KR_SEP'
161: and xppa.business_group_id = pay_magtape_generic.get_parameter_value('BUSINESS_GROUP_ID')
162: and hoi.organization_id = xpaa.tax_unit_id

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

157: and ( (pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID') is null)
158: or (hr_assignment_set.assignment_in_set(pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID'), xpaa.assignment_id) = 'Y')
159: )
160: and xppa.report_type = 'KR_SEP'
161: and xppa.business_group_id = pay_magtape_generic.get_parameter_value('BUSINESS_GROUP_ID')
162: and hoi.organization_id = xpaa.tax_unit_id
163: and fue.user_entity_id = fai.user_entity_id
164: and fue.user_entity_name in ('A_NON_STAT_SEP_PAY_TAXABLE_EARNINGS_ASG_RUN','A_RECEIVABLE_NON_STAT_SEP_PAY_ASG_RUN','A_RECEIVABLE_SEPARATION_PAY_ASG_RUN',
165: 'A_TAXABLE_EARNINGS_WI_PREV_ASG_RUN' ) --Bug 9409509

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

250: ,sum(decode(pay_kr_spay_efile_fun_pkg.get_emp_count(fue.user_entity_name,xpaa.assignment_action_id),0,0,1 )) EMPCOUNT -- Bug 9409509
251: ,'PREV_EMP_COUNT=P'
252: ,SUM(decode(fue.user_entity_name ,'X_KR_PREV_BP_NUMBER',1,0)) PREVEMPCOUNT
253: ,'REPORTING_PERIOD=P'
254: ,pay_magtape_generic.get_parameter_value('REPORTING_PERIOD')
255: FROM pay_assignment_actions xpaa
256: ,pay_payroll_actions xppa
257: ,hr_organization_information hoi
258: ,hr_organization_information ihoi

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

263: ,ff_archive_items fai1
264: WHERE xppa.action_type = 'X'
265: and xppa.action_status = 'C'
266: --Bug 5069923
267: and xppa.payroll_action_id = nvl(pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID'),xpaa.payroll_action_id)
268: and xppa.effective_date between
269: to_date(pay_magtape_generic.get_parameter_value('TARGET_YEAR')||'0101','YYYYMMDD')
270: and to_date(pay_magtape_generic.get_parameter_value('TARGET_YEAR')||'1231','YYYYMMDD')
271: and xppa.payroll_action_id = xpaa.payroll_action_id

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

265: and xppa.action_status = 'C'
266: --Bug 5069923
267: and xppa.payroll_action_id = nvl(pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID'),xpaa.payroll_action_id)
268: and xppa.effective_date between
269: to_date(pay_magtape_generic.get_parameter_value('TARGET_YEAR')||'0101','YYYYMMDD')
270: and to_date(pay_magtape_generic.get_parameter_value('TARGET_YEAR')||'1231','YYYYMMDD')
271: and xppa.payroll_action_id = xpaa.payroll_action_id
272: and xpaa.action_status = 'C'
273: and xppa.report_type = 'KR_SEP'

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

266: --Bug 5069923
267: and xppa.payroll_action_id = nvl(pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID'),xpaa.payroll_action_id)
268: and xppa.effective_date between
269: to_date(pay_magtape_generic.get_parameter_value('TARGET_YEAR')||'0101','YYYYMMDD')
270: and to_date(pay_magtape_generic.get_parameter_value('TARGET_YEAR')||'1231','YYYYMMDD')
271: and xppa.payroll_action_id = xpaa.payroll_action_id
272: and xpaa.action_status = 'C'
273: and xppa.report_type = 'KR_SEP'
274: and hoi.organization_id = xpaa.tax_unit_id

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

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

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

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

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

276: and hoi.organization_id = ihoi.organization_id
277: and ihoi.org_information_context = 'KR_INCOME_TAX_OFFICE'
278: and ihoi.org_information9 = pay_magtape_generic.get_parameter_value('TAX_OFFICE_CODE')
279: and hoi.org_information2 = pay_magtape_generic.get_parameter_value('BP_NUMBER')
280: and hoi.org_information10 = pay_magtape_generic.get_parameter_value('CORPORATION_ID')
281: and hoi.organization_id = hou.organization_id
282: and hou.business_group_id = pay_magtape_generic.get_parameter_value('BUSINESS_GROUP_ID')
283: and fai.user_entity_id = fue.user_entity_id
284: and fue.user_entity_name IN ('A_GROSS_ITAX_ASG_RUN',

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

278: and ihoi.org_information9 = pay_magtape_generic.get_parameter_value('TAX_OFFICE_CODE')
279: and hoi.org_information2 = pay_magtape_generic.get_parameter_value('BP_NUMBER')
280: and hoi.org_information10 = pay_magtape_generic.get_parameter_value('CORPORATION_ID')
281: and hoi.organization_id = hou.organization_id
282: and hou.business_group_id = pay_magtape_generic.get_parameter_value('BUSINESS_GROUP_ID')
283: and fai.user_entity_id = fue.user_entity_id
284: and fue.user_entity_name IN ('A_GROSS_ITAX_ASG_RUN',
285: 'A_GROSS_STAX_ASG_RUN',
286: 'A_GROSS_RTAX_ASG_RUN',

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

315: 'X_KR_PREV_LUMP_SUM_NST_ENT'
316: )
317: and fai.context1 = xpaa.assignment_Action_id
318: --Bug 5069923
319: and ( (pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID') is null)
320: or (hr_assignment_set.assignment_in_set(pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID'), xpaa.assignment_id) = 'Y')
321: )
322: and fue1.user_entity_name = pay_kr_spay_efile_fun_pkg.get_archive_item(xpaa.assignment_Action_id) -- Bug 9409509
323: and fue1.legislation_code = 'KR'

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

316: )
317: and fai.context1 = xpaa.assignment_Action_id
318: --Bug 5069923
319: and ( (pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID') is null)
320: or (hr_assignment_set.assignment_in_set(pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID'), xpaa.assignment_id) = 'Y')
321: )
322: and fue1.user_entity_name = pay_kr_spay_efile_fun_pkg.get_archive_item(xpaa.assignment_Action_id) -- Bug 9409509
323: and fue1.legislation_code = 'KR'
324: and fai1.user_entity_id = fue1.user_entity_id

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

333: *********************************************************/
334: cursor c_multiple_year -- 4095229
335: is
336: select 'START_DATE=P',
337: fnd_date.date_to_canonical( to_date(pay_magtape_generic.get_parameter_value('TARGET_YEAR') || '0101',
338: 'YYYYMMDD') ) start_date,
339: 'END_DATE=P',
340: fnd_date.date_to_canonical( to_date(pay_magtape_generic.get_parameter_value('TARGET_YEAR') || '1231',
341: 'YYYYMMDD') ) end_date

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

336: select 'START_DATE=P',
337: fnd_date.date_to_canonical( to_date(pay_magtape_generic.get_parameter_value('TARGET_YEAR') || '0101',
338: 'YYYYMMDD') ) start_date,
339: 'END_DATE=P',
340: fnd_date.date_to_canonical( to_date(pay_magtape_generic.get_parameter_value('TARGET_YEAR') || '1231',
341: 'YYYYMMDD') ) end_date
342:
343: from dual;
344:

Line 380: ,nvl(pay_kr_report_pkg.get_result_value_char( pay_kr_nonstat_spay_efile_fun.get_assignment_action_id(xpaa.assignment_action_id,xpaa.assignment_id),to_number(pay_magtape_generic.get_parameter_value('BUSINESS_GROUP_ID'))

376: ,'CORP_NAME=P'
377: ,hoi.org_information1
378: /* Bug 10216334 */
379: ,'PREV_SEP_PEN_ACCOUNT_NUMBER=P'
380: ,nvl(pay_kr_report_pkg.get_result_value_char( pay_kr_nonstat_spay_efile_fun.get_assignment_action_id(xpaa.assignment_action_id,xpaa.assignment_id),to_number(pay_magtape_generic.get_parameter_value('BUSINESS_GROUP_ID'))
381: ,'PREV_SEP_PENS_DTLS', 'Account Number'),' ')
382: ,'PREV_HIRING_DATE=P'
383: ,pay_kr_nonstat_spay_efile_fun.get_element_rr_date_value( pay_kr_nonstat_spay_efile_fun.get_assignment_action_id(xpaa.assignment_action_id,xpaa.assignment_id),
384: 'PREV_FH_DATE', 'WKPD')

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

405: ,ff_archive_items fai1
406: WHERE xppa.action_type = 'X'
407: and xppa.action_status = 'C'
408: and xppa.effective_date
409: between fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('START_DATE'))
410: and fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('END_DATE'))
411: and xppa.payroll_action_id = xpaa.payroll_action_id
412: --Bug 5069923
413: and xppa.payroll_action_id = nvl(pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID'),xpaa.payroll_action_id)

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

406: WHERE xppa.action_type = 'X'
407: and xppa.action_status = 'C'
408: and xppa.effective_date
409: between fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('START_DATE'))
410: and fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('END_DATE'))
411: and xppa.payroll_action_id = xpaa.payroll_action_id
412: --Bug 5069923
413: and xppa.payroll_action_id = nvl(pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID'),xpaa.payroll_action_id)
414: and xpaa.action_status = 'C'

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

409: between fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('START_DATE'))
410: and fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('END_DATE'))
411: and xppa.payroll_action_id = xpaa.payroll_action_id
412: --Bug 5069923
413: and xppa.payroll_action_id = nvl(pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID'),xpaa.payroll_action_id)
414: and xpaa.action_status = 'C'
415: and xppa.report_type = 'KR_SEP'
416: and hoi.organization_id = xpaa.tax_unit_id
417: and hoi.org_information_context = 'KR_BUSINESS_PLACE_REGISTRATION'

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

414: and xpaa.action_status = 'C'
415: and xppa.report_type = 'KR_SEP'
416: and hoi.organization_id = xpaa.tax_unit_id
417: and hoi.org_information_context = 'KR_BUSINESS_PLACE_REGISTRATION'
418: and hoi.org_information2 = pay_magtape_generic.get_parameter_value('BP_NUMBER')
419: and hoi.org_information10 = pay_magtape_generic.get_parameter_value('CORPORATION_ID')
420: and hoi.organization_id = hou.organization_id
421: and hou.business_group_id = pay_magtape_generic.get_parameter_value('BUSINESS_GROUP_ID')
422: and fue.user_entity_name = pay_kr_spay_efile_fun_pkg.get_archive_item(xpaa.assignment_Action_id) -- Bug 9409509

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

415: and xppa.report_type = 'KR_SEP'
416: and hoi.organization_id = xpaa.tax_unit_id
417: and hoi.org_information_context = 'KR_BUSINESS_PLACE_REGISTRATION'
418: and hoi.org_information2 = pay_magtape_generic.get_parameter_value('BP_NUMBER')
419: and hoi.org_information10 = pay_magtape_generic.get_parameter_value('CORPORATION_ID')
420: and hoi.organization_id = hou.organization_id
421: and hou.business_group_id = pay_magtape_generic.get_parameter_value('BUSINESS_GROUP_ID')
422: and fue.user_entity_name = pay_kr_spay_efile_fun_pkg.get_archive_item(xpaa.assignment_Action_id) -- Bug 9409509
423: and fue.legislation_code = 'KR'

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

417: and hoi.org_information_context = 'KR_BUSINESS_PLACE_REGISTRATION'
418: and hoi.org_information2 = pay_magtape_generic.get_parameter_value('BP_NUMBER')
419: and hoi.org_information10 = pay_magtape_generic.get_parameter_value('CORPORATION_ID')
420: and hoi.organization_id = hou.organization_id
421: and hou.business_group_id = pay_magtape_generic.get_parameter_value('BUSINESS_GROUP_ID')
422: and fue.user_entity_name = pay_kr_spay_efile_fun_pkg.get_archive_item(xpaa.assignment_Action_id) -- Bug 9409509
423: and fue.legislation_code = 'KR'
424: and fai.user_entity_id = fue.user_entity_id
425: and fai.context1 = xpaa.assignment_action_id

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

423: and fue.legislation_code = 'KR'
424: and fai.user_entity_id = fue.user_entity_id
425: and fai.context1 = xpaa.assignment_action_id
426: --Bug 5069923
427: and ( (pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID') is null)
428: or (hr_assignment_set.assignment_in_set(pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID'), xpaa.assignment_id) = 'Y')
429: )
430: and fai.value > '0'
431: and fue1.user_entity_name = 'X_KR_EMP_NI'

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

424: and fai.user_entity_id = fue.user_entity_id
425: and fai.context1 = xpaa.assignment_action_id
426: --Bug 5069923
427: and ( (pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID') is null)
428: or (hr_assignment_set.assignment_in_set(pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID'), xpaa.assignment_id) = 'Y')
429: )
430: and fai.value > '0'
431: and fue1.user_entity_name = 'X_KR_EMP_NI'
432: and fai1.user_entity_id = fue1.user_entity_id

Line 447: pay_kr_nonstat_spay_efile.get_record_d_context(pay_magtape_generic.get_parameter_value('ASSIGNMENT_ACTION_ID'))

443: cursor c_record_d
444: is
445: select
446: 'ELEMENT_ENTRY_ID=C',
447: pay_kr_nonstat_spay_efile.get_record_d_context(pay_magtape_generic.get_parameter_value('ASSIGNMENT_ACTION_ID'))
448: from dual;
449:
450: end pay_kr_nonstat_spay_efile;