APPS.PAY_KR_NONSTAT_SPAY_EFILE dependencies on HR_ASSIGNMENT_SET

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