DBA Data[Home] [Help]

APPS.JL_AR_AUTOINV_PKG dependencies on HR_ORGANIZATION_UNITS

Line 120: hr_organization_units hrou

116: BEGIN
117: SELECT hrl.global_attribute1
118: INTO l_organization_class_code
119: FROM hr_locations hrl,
120: hr_organization_units hrou
121: WHERE hrou.organization_id = trx_lines_rec.org_id
122: AND hrl.location_id = hrou.location_id;
123:
124: arp_file.write_log('Organization class code '||l_organization_class_code,0);

Line 136: hr_organization_units hrou

132: BEGIN
133: SELECT hrl.global_attribute1
134: INTO l_organization_class_code
135: FROM hr_locations hrl,
136: hr_organization_units hrou
137: WHERE hrou.organization_id = l_so_org_id
138: AND hrl.location_id = hrou.location_id;
139:
140: arp_file.write_log('Organization class code '||l_organization_class_code,0);