28: cursor csr_b1 is
29: select count(*)
30: from pay_assignment_actions paa,
31: pay_payroll_actions ppa,
32: hr_organization_units bp,
33: hr_organization_information hoi1,
34: hr_organization_information hoi2
35: where hoi1.org_information2 = p_bp_number --Bug# 2822459
36: and hoi2.org_information9 = p_tax_office_code
58: select nvl(sum(greatest(to_number(i1.value), 0)), 0)
59: from ff_archive_items i1,
60: pay_assignment_actions paa,
61: pay_payroll_actions ppa,
62: hr_organization_units bp,
63: hr_organization_information hoi1,
64: hr_organization_information hoi2
65: where hoi1.org_information2 = p_bp_number --Bug# 2822459
66: and hoi2.org_information9 = p_tax_office_code
91: count(*)
92: from per_assignment_extra_info aei,
93: pay_assignment_actions paa,
94: pay_payroll_actions ppa,
95: hr_organization_units bp,
96: hr_organization_information hoi1,
97: hr_organization_information hoi2
98: where hoi1.org_information2 = p_bp_number --Bug# 2822459
99: and hoi2.org_information9 = p_tax_office_code