DBA Data[Home] [Help]

APPS.PAY_KR_YEA_MAGTAPE_FUN_PKG dependencies on HR_ASSIGNMENT_SET

Line 51: and ((pay_kr_yea_magtape_pkg.g_assignment_set_id is null) or (hr_assignment_set.assignment_in_set(pay_kr_yea_magtape_pkg.g_assignment_set_id, paa.assignment_id) = 'Y'))

47: and ppa.action_type in ('B','X')
48: and paa.payroll_action_id = ppa.payroll_action_id
49: and ppa.payroll_action_id = ppa.payroll_action_id
50: -- Bug 3248513
51: and ((pay_kr_yea_magtape_pkg.g_assignment_set_id is null) or (hr_assignment_set.assignment_in_set(pay_kr_yea_magtape_pkg.g_assignment_set_id, paa.assignment_id) = 'Y'))
52: and ((pay_kr_yea_magtape_pkg.g_re_yea <> 'R') or (pay_kr_yea_magtape_fun_pkg.latest_yea_action(paa.assignment_action_id, pay_kr_yea_magtape_pkg.g_payroll_action_id, pay_kr_yea_magtape_pkg.g_target_year) = 'Y'))
53: --
54: and paa.tax_unit_id = bp.organization_id
55: and paa.action_status = 'C';

Line 81: and ((pay_kr_yea_magtape_pkg.g_assignment_set_id is null) or (hr_assignment_set.assignment_in_set(pay_kr_yea_magtape_pkg.g_assignment_set_id, paa.assignment_id) = 'Y'))

77: and ppa.action_type in ('B','X')
78: and paa.payroll_action_id = ppa.payroll_action_id
79: and ppa.payroll_action_id = ppa.payroll_action_id
80: -- Bug 3248513
81: and ((pay_kr_yea_magtape_pkg.g_assignment_set_id is null) or (hr_assignment_set.assignment_in_set(pay_kr_yea_magtape_pkg.g_assignment_set_id, paa.assignment_id) = 'Y'))
82: and ((pay_kr_yea_magtape_pkg.g_re_yea <> 'R') or (pay_kr_yea_magtape_fun_pkg.latest_yea_action(paa.assignment_action_id, pay_kr_yea_magtape_pkg.g_payroll_action_id, pay_kr_yea_magtape_pkg.g_target_year) = 'Y'))
83: --
84: and paa.tax_unit_id = bp.organization_id
85: and paa.action_status = 'C'

Line 114: and ((pay_kr_yea_magtape_pkg.g_assignment_set_id is null) or (hr_assignment_set.assignment_in_set(pay_kr_yea_magtape_pkg.g_assignment_set_id, paa.assignment_id) = 'Y'))

110: and ppa.action_type in ('B','X')
111: and paa.payroll_action_id = ppa.payroll_action_id
112: and ppa.payroll_action_id = ppa.payroll_action_id
113: -- Bug 3248513
114: and ((pay_kr_yea_magtape_pkg.g_assignment_set_id is null) or (hr_assignment_set.assignment_in_set(pay_kr_yea_magtape_pkg.g_assignment_set_id, paa.assignment_id) = 'Y'))
115: and ((pay_kr_yea_magtape_pkg.g_re_yea <> 'R') or (pay_kr_yea_magtape_fun_pkg.latest_yea_action(paa.assignment_action_id, pay_kr_yea_magtape_pkg.g_payroll_action_id, pay_kr_yea_magtape_pkg.g_target_year) = 'Y'))
116: --
117: and paa.tax_unit_id = bp.organization_id
118: and paa.action_status = 'C'