DBA Data[Home] [Help]

APPS.PAY_US_PTO_CO_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 172: l_legislation_code hr_organization_information.org_information9%TYPE;

168:
169: -- Bug no 2932073 And 2878657
170: -- added local Variable to hold the ligislation code.
171:
172: l_legislation_code hr_organization_information.org_information9%TYPE;
173:
174: -- Cursor for selecting the Legislation code
175:
176: cursor c_legislation_code (p_bg_id number) is

Line 179: , hr_organization_information hoi

175:
176: cursor c_legislation_code (p_bg_id number) is
177: select hoi.org_information9
178: from hr_all_organization_units org
179: , hr_organization_information hoi
180: where hoi.organization_id = org.business_group_id
181: and hoi.org_information_context = 'Business Group Information'
182: and org.business_group_id = p_bg_id;
183: