DBA Data[Home] [Help]

APPS.PAY_KR_SPAY_EFILE dependencies on HR_ASSIGNMENT_SET

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