DBA Data[Home] [Help]

APPS.PAY_KR_YEA_MAGTAPE_FUN_PKG dependencies on HR_ORGANIZATION_UNITS

Line 32: hr_organization_units bp,

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

Line 62: hr_organization_units bp,

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

Line 95: hr_organization_units bp,

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