APPS.JL_AR_DOC_NUMBERING_PKG dependencies on HR_LOCATIONS

Line 274: -- Fetching the company Cuit from hr locations

270: l_count NUMBER;
271: BEGIN
272:
273: --oe_profile.get('MASTER_ORGANIZATION_ID',l_org_id);
274: -- Fetching the company Cuit from hr locations
275: BEGIN
276: SELECT registration_number
277: INTO l_comp_cuit
278: FROM xle_firstparty_information_v

Line 459: FROM hr_locations hrl,

455: IF l_loc_id is not null then
456: BEGIN
457: SELECT hrl.global_attribute1
458: INTO l_organization_class_code
459: FROM hr_locations hrl,
460: hr_organization_units hrou
461: WHERE hrou.organization_id = l_so_org_id
462: AND hrl.location_id = hrou.location_id;
463: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 1001: FROM hr_locations hl, hr_organization_units hou

997: BEGIN
998: BEGIN
999: SELECT hl.global_attribute7
1000: INTO l_br_numb_code
1001: FROM hr_locations hl, hr_organization_units hou
1002: WHERE hl.location_id = hou.location_id
1003: AND hou.organization_id = p_inv_org_id;
1004: EXCEPTION
1005: WHEN OTHERS THEN

Line 1080: FROM hr_locations hl

1076: BEGIN
1077: BEGIN
1078: SELECT lpad(substr(hl.global_attribute7,1,4),4,'0')
1079: INTO l_hr_br_number
1080: FROM hr_locations hl
1081: WHERE hl.location_id = p_location_id;
1082: EXCEPTION
1083: WHEN OTHERS THEN
1084: l_hr_br_number := null;