DBA Data[Home] [Help]

APPS.JL_AR_AUTOINV_PKG dependencies on HR_LOCATIONS

Line 119: FROM hr_locations hrl,

115:
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:

Line 135: FROM hr_locations hrl,

131: arp_file.write_log('Searching for Org Class Code in Org_ID='||l_so_org_id,0);
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: