APPS.JL_AR_DOC_NUMBERING_PKG dependencies on HR_LOCATIONS

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

263: l_count NUMBER;
264: BEGIN
265:
266: --oe_profile.get('MASTER_ORGANIZATION_ID',l_org_id);
267: -- Fetching the company Cuit from hr locations
268: BEGIN
269: SELECT registration_number
270: INTO l_comp_cuit
271: FROM xle_firstparty_information_v

Line 445: FROM hr_locations hrl,

441: IF l_loc_id is not null then
442: BEGIN
443: SELECT hrl.global_attribute1
444: INTO l_organization_class_code
445: FROM hr_locations hrl,
446: hr_organization_units hrou
447: WHERE hrou.organization_id = l_so_org_id
448: AND hrl.location_id = hrou.location_id;
449: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 987: FROM hr_locations hl, hr_organization_units hou

983: BEGIN
984: BEGIN
985: SELECT hl.global_attribute7
986: INTO l_br_numb_code
987: FROM hr_locations hl, hr_organization_units hou
988: WHERE hl.location_id = hou.location_id
989: AND hou.organization_id = p_inv_org_id;
990: EXCEPTION
991: WHEN OTHERS THEN

Line 1066: FROM hr_locations hl

1062: BEGIN
1063: BEGIN
1064: SELECT lpad(substr(hl.global_attribute7,1,4),4,'0')
1065: INTO l_hr_br_number
1066: FROM hr_locations hl
1067: WHERE hl.location_id = p_location_id;
1068: EXCEPTION
1069: WHEN OTHERS THEN
1070: l_hr_br_number := null;