APPS.PAY_KR_NONSTAT_SPAY_EFILE dependencies on HR_ASSIGNMENT_SET

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