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